{"id":2981585,"date":"2026-09-08T10:20:51","date_gmt":"2026-09-08T17:20:51","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2981585"},"modified":"2026-09-09T19:21:59","modified_gmt":"2026-09-10T02:21:59","slug":"email-weekly-statistic-from-feature-layer-with-power-automate","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate","title":{"rendered":"Send weekly feature layer statistics with Power Automate Part 1: Send a field average"},"author":421552,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851],"tags":[780592,86442,761682,780839,27911],"industry":[],"product":[770122],"class_list":["post-2981585","blog","type-blog","status-publish","format-standard","hentry","category-data-management","tag-arcgis-connectors-for-power-automate","tag-data-management","tag-power-automate","tag-spatial-automation","tag-tutorial","product-microsoft-365"],"acf":{"authors":[{"ID":421552,"user_firstname":"Brandley","user_lastname":"Simms","nickname":"Brandley Simms","user_nicename":"bsimmsesri-com_esriinc-2-2","display_name":"Brandley Simms","user_email":"bsimms@esri.com","user_url":"","user_registered":"2025-11-15 00:18:28","user_description":"Brandley is a Product Engineering Writer for ArcGIS Hub and ArcGIS Connectors for Microsoft Power Automate. He received his MS in Geographic Information Science from the University of Redlands. Along with geography, Brandley is passionate about education, history, and poetry.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/02\/brandley-pic-e1772149071532-261x261.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"short_description":"Learn how to use ArcGIS Connectors for Power Automate to email a weekly statistic from a feature layer field","flexible_content":[{"acf_fc_layout":"content","content":"<p>With <a href=\"https:\/\/doc.arcgis.com\/en\/power-automate\/latest\/get-started\/get-started-with-arcgis-connectors-for-power-automate.htm\">ArcGIS Connectors for Power Automate<\/a>, you can ensure you stay up to date on dynamic spatial data. This blog article shows you how to set up a reoccurring report of the weekly average of a feature layer field using the <a href=\"https:\/\/doc.arcgis.com\/en\/power-automate\/latest\/automate\/get-data-from-feature-layer.htm\">Get data from feature layer<\/a> action. Uses for this workflow include the following:<\/p>\n<ul>\n<li>Aggregating air quality measurements for a town with multiple sensors<\/li>\n<li>Assessing the average value of houses recently sold in a city<\/li>\n<li>Evaluating the condition of a neighborhood\u2019s water system through samples taken at several locations<\/li>\n<\/ul>\n<p>The ArcGIS connectors are available with a premium license to Microsoft Power Automate and are accessible with ArcGIS Online (ArcGIS) or ArcGIS Enterprise connectors. To learn more, see <a href=\"https:\/\/doc.arcgis.com\/en\/power-automate\/latest\/get-started\/set-up-the-arcgis-online-arcgis-connector.htm\">Set up the ArcGIS Online (ArcGIS) connector<\/a> and <a href=\"https:\/\/doc.arcgis.com\/en\/power-automate\/latest\/get-started\/set-up-the-arcgis-enterprise-connector.htm\">Set up the ArcGIS Enterprise connector<\/a>.<\/p>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981591,"id":2981591,"title":"Screenshot 2026-08-03 164536","filename":"Screenshot-2026-08-03-164536.png","filesize":30474,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-08-03-164536","alt":"A Power Automate flow fetching data from a feature layer","author":"421552","description":"","caption":"","name":"screenshot-2026-08-03-164536","status":"inherit","uploaded_to":2981585,"date":"2026-09-03 23:08:40","modified":"2026-09-03 23:08:58","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":406,"height":585,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536.png","medium-width":181,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536.png","medium_large-width":406,"medium_large-height":585,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536.png","large-width":406,"large-height":585,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536.png","1536x1536-width":406,"1536x1536-height":585,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536.png","2048x2048-width":406,"2048x2048-height":585,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536-323x465.png","card_image-width":323,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-03-164536.png","wide_image-width":406,"wide_image-height":585}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Before you start<\/h2>\n<p>This flow automates notifications that summarize recent updates to a feature layer. Before you begin, ensure you have the following:<\/p>\n<ul>\n<li>A connection to the <a href=\"https:\/\/doc.arcgis.com\/en\/power-automate\/latest\/get-started\/set-up-the-arcgis-online-arcgis-connector.htm\">ArcGIS Online (ArcGIS) connector<\/a>, from a login or API key, or the <a href=\"https:\/\/doc.arcgis.com\/en\/power-automate\/latest\/get-started\/set-up-the-arcgis-enterprise-connector.htm\">ArcGIS Enterprise connector <\/a>in Microsoft Power Automate<\/li>\n<li>A connection to <a href=\"https:\/\/learn.microsoft.com\/en-us\/connectors\/office365\/\">Office 365 Outlook<\/a><\/li>\n<li>A feature layer with a <a href=\"https:\/\/doc.arcgis.com\/en\/arcgis-online\/manage-data\/work-with-date-fields.htm#ESRI_SECTION1_46B0A13294DB457BA62A8422AC600A64\">Date<\/a> field and numerical field<\/li>\n<\/ul>\n<p>This example uses an air quality readings feature layer to aggregate air quality measurements throughout a town. Your results will differ depending on the feature layer you query.<\/p>\n<h2>Create a flow that triggers weekly<\/h2>\n<p>As the feature layer is continuously updated, this flow will summarize its data at the weekly time you choose. Complete the following steps to set up the flow to trigger once a week:<\/p>\n<p><strong>1.<\/strong> From the Power Automate home page, click <strong>Create<\/strong> on the sidebar.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2963151,"id":2963151,"title":"Power Automate Create","filename":"Power-Automate-Create.png","filesize":8350,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/create-a-flow-with-arcgis-connectors-for-microsoft-power-automate\/power-automate-create","alt":"The Create button in Power Automate","author":"421552","description":"","caption":"","name":"power-automate-create","status":"inherit","uploaded_to":2963142,"date":"2026-04-17 23:36:00","modified":"2026-09-03 23:18:36","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":166,"height":178,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","thumbnail-width":166,"thumbnail-height":178,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","medium-width":166,"medium-height":178,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","medium_large-width":166,"medium_large-height":178,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","large-width":166,"large-height":178,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","1536x1536-width":166,"1536x1536-height":178,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","2048x2048-width":166,"2048x2048-height":178,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","card_image-width":166,"card_image-height":178,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-Create.png","wide_image-width":166,"wide_image-height":178}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <strong>Create<\/strong> page opens, showing a variety of flow types.<\/p>\n<p><strong>2.<\/strong> Click <strong>Scheduled cloud flow<\/strong>.<\/p>\n<p><strong>3.<\/strong> In the <strong>Build a scheduled cloud flow<\/strong> window, provide a name for the flow.<\/p>\n<p><strong>4. <\/strong>Choose a time of day for the flow to run and set the frequency in the <strong>Repeat every<\/strong> fields to <u>1<\/u> and <u>Week<\/u> so that the flow runs once a week.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981611,"id":2981611,"title":"Power-Automate-Build-Cloud","filename":"Screenshot-2026-06-30-143619.png","filesize":23854,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-06-30-143619","alt":"The Build a scheduled cloud flow window","author":"421552","description":"","caption":"","name":"screenshot-2026-06-30-143619","status":"inherit","uploaded_to":2981585,"date":"2026-09-03 23:56:32","modified":"2026-09-03 23:57:47","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":471,"height":428,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","medium-width":287,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","medium_large-width":471,"medium_large-height":428,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","large-width":471,"large-height":428,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","1536x1536-width":471,"1536x1536-height":428,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","2048x2048-width":471,"2048x2048-height":428,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","card_image-width":471,"card_image-height":428,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-143619.png","wide_image-width":471,"wide_image-height":428}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <strong>On these days<\/strong> section appears, with each day of the week selected.<\/p>\n<p><strong>5.<\/strong> Click the day of the week buttons to deselect the days you do not want the flow to run. Ensure only the day of the week you want the flow to run is selected.<\/p>\n<p>6. Click\u00a0<strong>Create<\/strong>.<\/p>\n<h2>Generate a statistical summary<\/h2>\n<p>After creating a flow that triggers once a week, you can configure ArcGIS actions that will provide you with weekly summary statistics on the feature layer. To ensure the flow only retrieves data from the previous week, you will first add a <strong>Get past time<\/strong> action. Complete the following steps to retrieve the weekly average from a field in the feature layer:<\/p>\n<p><strong>1.<\/strong> Under the <strong>Recurrence<\/strong> trigger, click the button to add an action.<\/p>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981608,"id":2981608,"title":"Reoccurrence-Action-Power-Automate","filename":"Screenshot-2026-06-30-145040.png","filesize":5271,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-06-30-145040","alt":"The reoccurrence action card","author":"421552","description":"","caption":"","name":"screenshot-2026-06-30-145040","status":"inherit","uploaded_to":2981585,"date":"2026-09-03 23:50:20","modified":"2026-09-03 23:51:17","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":300,"height":134,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040-213x134.png","thumbnail-width":213,"thumbnail-height":134,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","medium-width":300,"medium-height":134,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","medium_large-width":300,"medium_large-height":134,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","large-width":300,"large-height":134,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","1536x1536-width":300,"1536x1536-height":134,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","2048x2048-width":300,"2048x2048-height":134,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","card_image-width":300,"card_image-height":134,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-06-30-145040.png","wide_image-width":300,"wide_image-height":134}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>2.<\/strong> In the <strong>Add an action<\/strong> window, type <u>Get past time<\/u> into the search bar.<\/p>\n<p><strong>3. <\/strong>Click the <strong>Get past time<\/strong> action from the results.<\/p>\n<p>The <strong>Get past time <\/strong>action window opens.<\/p>\n<p><strong>4.<\/strong> In the <strong>Interval<\/strong> parameter, type <u>1<\/u>, and set <strong>Time unit<\/strong> to <strong>Week<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981691,"id":2981691,"title":"Power-Automate-Get-Past-Week","filename":"Screenshot-2026-09-01-120204.png","filesize":6693,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-09-01-120204","alt":"The Get past time action set to one week.","author":"421552","description":"","caption":"","name":"screenshot-2026-09-01-120204","status":"inherit","uploaded_to":2981585,"date":"2026-09-07 22:57:33","modified":"2026-09-07 22:58:17","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":613,"height":196,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204-213x196.png","thumbnail-width":213,"thumbnail-height":196,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","medium-width":464,"medium-height":148,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","medium_large-width":613,"medium_large-height":196,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","large-width":613,"large-height":196,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","1536x1536-width":613,"1536x1536-height":196,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","2048x2048-width":613,"2048x2048-height":196,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","card_image-width":613,"card_image-height":196,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-120204.png","wide_image-width":613,"wide_image-height":196}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>You can now reference this action in the flow to filter data one week prior to its runtime.<\/p>\n<p><strong>5.<\/strong> Click the button to add an action under the <strong>Get past time<\/strong> action and search for the <strong>Get data from feature layer<\/strong> After it appears in the ArcGIS section, add it to the flow.<\/p>\n<p>The <strong>Get data from feature layer<\/strong> action opens.<\/p>\n<p><strong>6.<\/strong> Click the <strong>Feature layer <\/strong>parameter, and from the drop-down menu, select the feature layer from which you want to receive statistics.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981613,"id":2981613,"title":"Power-Automate-Get-data-csv","filename":"Screenshot-2026-08-25-125608.png","filesize":20778,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-08-25-125608","alt":"The Get data from feature layer action","author":"421552","description":"","caption":"","name":"screenshot-2026-08-25-125608","status":"inherit","uploaded_to":2981585,"date":"2026-09-04 00:07:08","modified":"2026-09-04 00:08:43","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":787,"height":479,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608.png","medium-width":429,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608.png","medium_large-width":768,"medium_large-height":467,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608.png","large-width":787,"large-height":479,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608.png","1536x1536-width":787,"1536x1536-height":479,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608.png","2048x2048-width":787,"2048x2048-height":479,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608-764x465.png","card_image-width":764,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-25-125608.png","wide_image-width":787,"wide_image-height":479}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>In this example, the air quality readings feature layer is selected.<\/p>\n<p><strong>7.<\/strong> Set the <strong>Show statistics<\/strong> parameter to <strong>Yes<\/strong>.<\/p>\n<p><strong>8.<\/strong> Click the <strong>Advanced parameters<\/strong> drop-down menu and select the following parameters:<\/p>\n<ul>\n<li><strong>Query by field<\/strong><\/li>\n<li><strong>Comparison type<\/strong><\/li>\n<li><strong>Search value<\/strong><\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":2981616,"id":2981616,"title":"Power-Automate-Get-data-Advanced","filename":"Screenshot-2026-07-02-115944.png","filesize":27704,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-07-02-115944","alt":"Advanced parameters in the Get data from feature layer action window","author":"421552","description":"","caption":"","name":"screenshot-2026-07-02-115944","status":"inherit","uploaded_to":2981585,"date":"2026-09-04 00:13:08","modified":"2026-09-04 00:14:09","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":685,"height":382,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","medium-width":464,"medium-height":259,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","medium_large-width":685,"medium_large-height":382,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","large-width":685,"large-height":382,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","1536x1536-width":685,"1536x1536-height":382,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","2048x2048-width":685,"2048x2048-height":382,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","card_image-width":685,"card_image-height":382,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-115944.png","wide_image-width":685,"wide_image-height":382}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The window shows these three parameters.<\/p>\n<p><strong>9.<\/strong> For each field, do the following:<\/p>\n<ul>\n<li>For<strong> Query by field<\/strong>, select the field in the dataset that contains the time and date of each record.<\/li>\n<li>For<strong> Comparison type<\/strong>, select <strong>Greater than<\/strong>.<\/li>\n<li>For<strong> Search value<\/strong>, type a slash (<u>\/)<\/u>, select <strong>Insert dynamic content<\/strong>, and select <strong>Past time<\/strong>, the output from the previous action.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":2981682,"id":2981682,"title":"Power-Automate-Query-Field","filename":"Screenshot-2026-09-07-111844.png","filesize":18648,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-09-07-111844","alt":"The Get data from feature layer action set to filter out data older than a week.","author":"421552","description":"","caption":"","name":"screenshot-2026-09-07-111844","status":"inherit","uploaded_to":2981585,"date":"2026-09-07 18:19:48","modified":"2026-09-07 18:21:40","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":494,"height":479,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844.png","medium-width":269,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844.png","medium_large-width":494,"medium_large-height":479,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844.png","large-width":494,"large-height":479,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844.png","1536x1536-width":494,"1536x1536-height":479,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844.png","2048x2048-width":494,"2048x2048-height":479,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844-480x465.png","card_image-width":480,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-111844.png","wide_image-width":494,"wide_image-height":479}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The <strong>Get data from feature layer<\/strong> action now filters out records older than a week.<\/p>\n<p><strong>10.<\/strong> Click the <span style=\"font-weight: normal !msorm\"><strong>Advanced parameters<\/strong><\/span> drop-down menu, and select <strong>Output statistics<\/strong>.<\/p>\n<p>The parameters list shows the <strong>Output statistics<\/strong> box.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981684,"id":2981684,"title":"Power-Automate-Output-Statistics","filename":"Screenshot-2026-07-02-121432.png","filesize":34659,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-07-02-121432","alt":"The Output statistics box in the Get data from feature layer action.","author":"421552","description":"","caption":"","name":"screenshot-2026-07-02-121432","status":"inherit","uploaded_to":2981585,"date":"2026-09-07 18:27:04","modified":"2026-09-07 18:27:51","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":677,"height":395,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","medium-width":447,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","medium_large-width":677,"medium_large-height":395,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","large-width":677,"large-height":395,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","1536x1536-width":677,"1536x1536-height":395,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","2048x2048-width":677,"2048x2048-height":395,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","card_image-width":677,"card_image-height":395,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-07-02-121432.png","wide_image-width":677,"wide_image-height":395}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>11.<\/strong> For each field that appears under <strong>Output statistics<\/strong>, do the following:<\/p>\n<ul>\n<li>For <strong>On Statistic Field<\/strong>, select the field that holds the values you want to average.<\/li>\n<li>For <strong>Statistic Type<\/strong>, select avg.<\/li>\n<li>For <strong>Output Field Name<\/strong>, type <span style=\"text-decoration: underline\">Average-<\/span>.<\/li>\n<li>Leave the <strong>Sorting<\/strong> parameter empty, as sorting won\u2019t affect this operation.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":2981685,"id":2981685,"title":"Power-Automate-Output-Average","filename":"Screenshot-2026-09-07-113143.png","filesize":25927,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-09-07-113143","alt":"The output statistics box set to retrieve an average from an air quality feature layer.","author":"421552","description":"","caption":"","name":"screenshot-2026-09-07-113143","status":"inherit","uploaded_to":2981585,"date":"2026-09-07 18:32:29","modified":"2026-09-07 18:33:31","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":661,"height":400,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","medium-width":431,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","medium_large-width":661,"medium_large-height":400,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","large-width":661,"large-height":400,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","1536x1536-width":661,"1536x1536-height":400,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","2048x2048-width":661,"2048x2048-height":400,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","card_image-width":661,"card_image-height":400,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-07-113143.png","wide_image-width":661,"wide_image-height":400}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>The flow now produces a weekly average on a field selected from the feature layer.<\/p>\n<h2>Send an email report<\/h2>\n<p>Now that the flow will calculate a weekly average from the feature layer, you can include that information in an email sent to yourself and other stakeholders. Complete the following steps to automate a weekly report:<\/p>\n<p><strong>1.<\/strong> Click the button to add an action under the <strong>Get data from feature layer <\/strong>action, search for the <strong>Send an email (V2) <\/strong>action, and add it to the flow.<\/p>\n<p>The <strong>Send an email (V2)<\/strong> window opens.<\/p>\n<p><strong>2.<\/strong> In the <strong>To <\/strong>parameter, provide the email addresses of the desired recipients.<\/p>\n<p><strong>3.<\/strong> In the <strong>Subject <\/strong>parameter, type <u>Weekly average of <\/u>and type the field name.<\/p>\n<p><strong>4.<\/strong> In the <strong>Body<\/strong> parameter, type <u>Here is the weekly average <\/u>[field name]<u> from <\/u>[your feature layer]:, using the field name and feature layer included in the report.<\/p>\n<p><strong>5.<\/strong> Press <em>Enter<\/em>.<\/p>\n<p><strong>6.<\/strong> Type a slash (<u>\/)<\/u>, select <strong>Insert dynamic content<\/strong>, and select<strong> CSV<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981686,"id":2981686,"title":"Power_Automate-Email-Action-Average","filename":"Screenshot-2026-08-27-112847.png","filesize":17267,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-08-27-112847","alt":"The Subject and Body parameters of the Send an Email (V2) action","author":"421552","description":"","caption":"","name":"screenshot-2026-08-27-112847","status":"inherit","uploaded_to":2981585,"date":"2026-09-07 18:37:57","modified":"2026-09-07 20:05:06","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":730,"height":292,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","medium-width":464,"medium-height":186,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","medium_large-width":730,"medium_large-height":292,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","large-width":730,"large-height":292,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","1536x1536-width":730,"1536x1536-height":292,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","2048x2048-width":730,"2048x2048-height":292,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","card_image-width":730,"card_image-height":292,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-112847.png","wide_image-width":730,"wide_image-height":292}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><strong>7.<\/strong> Click <strong>Save<\/strong> at the top of the flow designer, and then click <strong>Test<\/strong> to ensure the flow works.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2963225,"id":2963225,"title":"Power Automate designer tool bar","filename":"Power-Automate-designer-tool-bar.png","filesize":9392,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/create-a-flow-with-arcgis-connectors-for-microsoft-power-automate\/power-automate-designer-tool-bar","alt":"The test button on the Power Automate designer toolbar","author":"421552","description":"","caption":"","name":"power-automate-designer-tool-bar","status":"inherit","uploaded_to":2963142,"date":"2026-04-20 21:36:15","modified":"2026-04-20 21:36:45","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":510,"height":42,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar-213x42.png","thumbnail-width":213,"thumbnail-height":42,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","medium-width":464,"medium-height":38,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","medium_large-width":510,"medium_large-height":42,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","large-width":510,"large-height":42,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","1536x1536-width":510,"1536x1536-height":42,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","2048x2048-width":510,"2048x2048-height":42,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","card_image-width":510,"card_image-height":42,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/04\/Power-Automate-designer-tool-bar.png","wide_image-width":510,"wide_image-height":42}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Your flow now sends an email detailing a weekly average from the feature layer.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981688,"id":2981688,"title":"Power_Automate-Email-Result-Average","filename":"Screenshot-2026-08-27-114101.png","filesize":55335,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\/screenshot-2026-08-27-114101","alt":"A test email containing the feature layer field average.","author":"421552","description":"","caption":"","name":"screenshot-2026-08-27-114101","status":"inherit","uploaded_to":2981585,"date":"2026-09-07 20:11:18","modified":"2026-09-07 20:15:55","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1154,"height":316,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101.png","medium-width":464,"medium-height":127,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101.png","medium_large-width":768,"medium_large-height":210,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101.png","large-width":1154,"large-height":316,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101.png","1536x1536-width":1154,"1536x1536-height":316,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101.png","2048x2048-width":1154,"2048x2048-height":316,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101-826x226.png","card_image-width":826,"card_image-height":226,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-114101.png","wide_image-width":1154,"wide_image-height":316}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>This blog article outlines the process of creating a Microsoft Power Automate flow that sends you a weekly statistic from an ArcGIS feature layer field. Learn how to upgrade the flow to <a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\">send multiple statistics in a formatted table<\/a>.<\/p>\n<h2>Additional Resources<\/h2>\n<p>For more information on ArcGIS Connectors for Microsoft Power Automate see the following resources:<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li><a href=\"https:\/\/doc.arcgis.com\/en\/power-automate\/latest\/get-started\/get-started-with-arcgis-connectors-for-power-automate.htm\">ArcGIS Connectors for Power Automate documentation<\/a><\/li>\n<li><a href=\"https:\/\/community.esri.com\/t5\/arcgis-connectors-for-power-automate\/ct-p\/arcgis-for-power-automate\">Esri Community for ArcGIS Connectors for Power Automate<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/field-maps\/field-mobility\/automate-field-notifications-with-microsoft-power-automate\">Blog &#8211; Automate field notifications with Microsoft Power Automate<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/add-coordinates-to-your-sharepoint-list\">Blog &#8211; Add coordinates to your SharePoint list using ArcGIS Connectors for Power Automate<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n"}],"related_articles":[{"ID":2963142,"post_author":"421552","post_date":"2026-04-22 14:02:10","post_date_gmt":"2026-04-22 21:02:10","post_content":"","post_title":"Create a flow with ArcGIS Connectors for Microsoft Power Automate","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"create-a-flow-with-arcgis-connectors-for-microsoft-power-automate","to_ping":"","pinged":"","post_modified":"2026-06-04 15:24:18","post_modified_gmt":"2026-06-04 22:24:18","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2963142","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":2757342,"post_author":"352692","post_date":"2025-04-14 08:56:43","post_date_gmt":"2025-04-14 15:56:43","post_content":"","post_title":"Streamlining water system management with ArcGIS Connectors for Power Automate","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"streamlining-water-system-management-with-arcgis-connectors-for-power-automate","to_ping":"","pinged":"","post_modified":"2025-04-28 17:46:04","post_modified_gmt":"2025-04-29 00:46:04","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2757342","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":2339152,"post_author":"10102","post_date":"2024-05-20 11:25:21","post_date_gmt":"2024-05-20 18:25:21","post_content":"","post_title":"Automate field notifications with Microsoft Power Automate","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"automate-field-notifications-with-microsoft-power-automate","to_ping":"","pinged":"","post_modified":"2024-05-20 11:30:28","post_modified_gmt":"2024-05-20 18:30:28","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2339152","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"1","filter":"raw"},{"ID":2005922,"post_author":"338542","post_date":"2023-06-29 12:35:52","post_date_gmt":"2023-06-29 19:35:52","post_content":"","post_title":"Add coordinates to your SharePoint list using ArcGIS Connectors for Power Automate","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"add-coordinates-to-your-sharepoint-list","to_ping":"","pinged":"","post_modified":"2025-09-24 09:20:31","post_modified_gmt":"2025-09-24 16:20:31","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2005922","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"show_article_image":false,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/adobestock-119621975-6.jpg","wide_image":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Email a weekly ArcGIS feature layer average with Power Automate<\/title>\n<meta name=\"description\" content=\"Learn how to use ArcGIS Connectors for Power Automate to email a weekly statistic from a feature layer field\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Send weekly feature layer statistics with Power Automate Part 1: Send a field average\" \/>\n<meta property=\"og:description\" content=\"Learn how to use ArcGIS Connectors for Power Automate to email a weekly statistic from a feature layer field\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-10T02:21:59+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\"},\"author\":{\"name\":\"Brandley Simms\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bf3c65008e65261cf0db56d2491daec4\"},\"headline\":\"Send weekly feature layer statistics with Power Automate Part 1: Send a field average\",\"datePublished\":\"2026-09-08T17:20:51+00:00\",\"dateModified\":\"2026-09-10T02:21:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\"},\"wordCount\":13,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS Connectors for Power Automate\",\"data management\",\"power automate\",\"spatial automation\",\"Tutorial\"],\"articleSection\":[\"Data Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\",\"name\":\"Email a weekly ArcGIS feature layer average with Power Automate\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2026-09-08T17:20:51+00:00\",\"dateModified\":\"2026-09-10T02:21:59+00:00\",\"description\":\"Learn how to use ArcGIS Connectors for Power Automate to email a weekly statistic from a feature layer field\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Send weekly feature layer statistics with Power Automate Part 1: Send a field average\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bf3c65008e65261cf0db56d2491daec4\",\"name\":\"Brandley Simms\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/02\/brandley-pic-e1772149071532-261x261.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/02\/brandley-pic-e1772149071532-261x261.jpg\",\"caption\":\"Brandley Simms\"},\"description\":\"Brandley is a Product Engineering Writer for ArcGIS Hub and ArcGIS Connectors for Microsoft Power Automate. He received his MS in Geographic Information Science from the University of Redlands. Along with geography, Brandley is passionate about education, history, and poetry.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/bsimmsesri-com_esriinc-2-2\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Email a weekly ArcGIS feature layer average with Power Automate","description":"Learn how to use ArcGIS Connectors for Power Automate to email a weekly statistic from a feature layer field","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate","og_locale":"en_US","og_type":"article","og_title":"Send weekly feature layer statistics with Power Automate Part 1: Send a field average","og_description":"Learn how to use ArcGIS Connectors for Power Automate to email a weekly statistic from a feature layer field","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2026-09-10T02:21:59+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate"},"author":{"name":"Brandley Simms","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bf3c65008e65261cf0db56d2491daec4"},"headline":"Send weekly feature layer statistics with Power Automate Part 1: Send a field average","datePublished":"2026-09-08T17:20:51+00:00","dateModified":"2026-09-10T02:21:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate"},"wordCount":13,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS Connectors for Power Automate","data management","power automate","spatial automation","Tutorial"],"articleSection":["Data Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate","name":"Email a weekly ArcGIS feature layer average with Power Automate","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2026-09-08T17:20:51+00:00","dateModified":"2026-09-10T02:21:59+00:00","description":"Learn how to use ArcGIS Connectors for Power Automate to email a weekly statistic from a feature layer field","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/email-weekly-statistic-from-feature-layer-with-power-automate#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Send weekly feature layer statistics with Power Automate Part 1: Send a field average"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bf3c65008e65261cf0db56d2491daec4","name":"Brandley Simms","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/02\/brandley-pic-e1772149071532-261x261.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/02\/brandley-pic-e1772149071532-261x261.jpg","caption":"Brandley Simms"},"description":"Brandley is a Product Engineering Writer for ArcGIS Hub and ArcGIS Connectors for Microsoft Power Automate. He received his MS in Geographic Information Science from the University of Redlands. Along with geography, Brandley is passionate about education, history, and poetry.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/bsimmsesri-com_esriinc-2-2"}]}},"text_date":"September 8, 2026","author_name":"Brandley Simms","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/bsimmsesri-com_esriinc-2-2","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/Newsroom-Keyart-Wide-1920-x-1080.jpg","primary_product":"ArcGIS for Microsoft 365","tag_data":[{"term_id":780592,"name":"ArcGIS Connectors for Power Automate","slug":"arcgis-connectors-for-power-automate","term_group":0,"term_taxonomy_id":780592,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"},{"term_id":86442,"name":"data management","slug":"data-management","term_group":0,"term_taxonomy_id":86442,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":761682,"name":"power automate","slug":"power-automate","term_group":0,"term_taxonomy_id":761682,"taxonomy":"post_tag","description":"","parent":0,"count":10,"filter":"raw"},{"term_id":780839,"name":"spatial automation","slug":"spatial-automation","term_group":0,"term_taxonomy_id":780839,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":27911,"name":"Tutorial","slug":"tutorial","term_group":0,"term_taxonomy_id":27911,"taxonomy":"post_tag","description":"","parent":0,"count":186,"filter":"raw"}],"category_data":[{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":973,"filter":"raw"}],"product_data":[{"term_id":770122,"name":"ArcGIS for Microsoft 365","slug":"microsoft-365","term_group":0,"term_taxonomy_id":770122,"taxonomy":"product","description":"","parent":36591,"count":50,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=microsoft-365","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2981585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/421552"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=2981585"}],"version-history":[{"count":23,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2981585\/revisions"}],"predecessor-version":[{"id":2981933,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2981585\/revisions\/2981933"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2981585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2981585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2981585"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2981585"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2981585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}