the previous blog article workflow<\/a>, only one summary statistic is retrieved from the feature layer. Complete the following steps to retrieve multiple summary statistics grouped by a field from the feature layer:<\/p>\n1.<\/strong> If necessary, reopen the designer for the flow that creates a weekly notification for a single statistic.<\/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":"2.<\/strong> Click the Get data from feature layer <\/strong>action to open its window.<\/p>\n3.<\/strong> For the Output format<\/strong> parameter, select JSON<\/u>.<\/p>\n4.<\/strong> Click the Advanced parameters<\/strong> drop-down menu and select Group by fields for statistics<\/strong>.<\/p>\n5.<\/strong> In the Group by fields for statistics<\/strong> parameter box, select the feature layer field to group your statistics by.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981809,"id":2981809,"title":"Power-Automate-Group-By-town","filename":"Screenshot-2026-09-01-153317.png","filesize":14138,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-01-153317","alt":"The Group by field parameter","author":"421552","description":"","caption":"","name":"screenshot-2026-09-01-153317","status":"inherit","uploaded_to":2981696,"date":"2026-09-08 22:50:33","modified":"2026-09-08 22:51:13","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":738,"height":215,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","medium-width":464,"medium-height":135,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","medium_large-width":738,"medium_large-height":215,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","large-width":738,"large-height":215,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","1536x1536-width":738,"1536x1536-height":215,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","2048x2048-width":738,"2048x2048-height":215,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","card_image-width":738,"card_image-height":215,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-153317.png","wide_image-width":738,"wide_image-height":215}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"In this example, the statistics will be grouped by a field that holds the town where each measurement is taken.<\/p>\n
Note: <\/strong>If you do not have a field to group statistics by, omit this step<\/p>\n6.<\/strong> Find the Output statistics<\/strong> parameter you configured to fetch the feature layer average. In the\u00a0Output Field Name<\/strong> parameter, change the input to average-air-quality<\/span>.<\/p>\n7.<\/strong> Under the average statistic you configured, click Add new item<\/strong>.<\/p>\n8. <\/strong>For each field that appears in the new statistic box, do the following:<\/p>\n\n- For On Statistic Field<\/strong>, select the field that holds the values you want to summarize.<\/li>\n
- For Statistic Type<\/strong>, select stddev<\/strong>.<\/li>\n
- For Output Field Name<\/strong>, type standard-deviation-air-quality<\/u>\u00a0and type the field name.<\/li>\n
- For Sorting<\/strong>, leave empty.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"image","image":{"ID":2981913,"id":2981913,"title":"Power Automate Get Data Average and Standard Deviation","filename":"Screenshot-2026-09-09-135214.png","filesize":26643,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-09-135214","alt":"The Get data from feature layer action set to retrieve an average and standard deviation","author":"421552","description":"","caption":"","name":"screenshot-2026-09-09-135214","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 21:22:12","modified":"2026-09-09 21:23: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":438,"height":427,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","medium-width":268,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","medium_large-width":438,"medium_large-height":427,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","large-width":438,"large-height":427,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","1536x1536-width":438,"1536x1536-height":427,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","2048x2048-width":438,"2048x2048-height":427,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","card_image-width":438,"card_image-height":427,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-135214.png","wide_image-width":438,"wide_image-height":427}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
9.<\/strong> Repeat steps 7 and 8 for each statistic you want to include in the report. In this demonstration, the average, standard deviation, count, and variance are retrieved.<\/p>\n10.\u00a0 <\/strong>Click Save<\/strong> at the top of the flow designer, and then click Test<\/strong>.<\/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":"10.<\/strong> In the Test flow<\/strong> window, select Manually<\/strong>, and click Test<\/strong>.<\/p>\n11.<\/strong> Click Run flow<\/strong> and then click Done<\/strong>. Once the flow runs, leave the run window open.<\/p>\nCreate an HTML table with your data<\/h2>\n
Now that the flow is prompted to retrieve multiple statistics from a feature layer, you\u2019ll format the results so that they are organized in a table. Complete the following steps to generate an HTML table with your data:<\/p>\n
1. <\/strong>After the flow runs, click on the Get data from feature layer<\/strong> action to open the run results.<\/p>\n2. <\/strong>Scroll down to the Outputs<\/strong> section and select Show raw outputs<\/strong>.<\/p>\nA code window appears showing the raw output data. At the bottom of this code you will see your statistic results.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981914,"id":2981914,"title":"Get data output data array","filename":"Screenshot-2026-09-09-140428.png","filesize":22276,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-09-140428","alt":"The data array in the output of the Get data from feature layer action","author":"421552","description":"","caption":"","name":"screenshot-2026-09-09-140428","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 21:25:01","modified":"2026-09-09 21:25:49","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":569,"height":383,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","medium-width":388,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","medium_large-width":569,"medium_large-height":383,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","large-width":569,"large-height":383,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","1536x1536-width":569,"1536x1536-height":383,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","2048x2048-width":569,"2048x2048-height":383,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","card_image-width":569,"card_image-height":383,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140428.png","wide_image-width":569,"wide_image-height":383}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
3.<\/strong> In the section containing your statistics, select the contents of the “data”<\/strong> array by clicking just before the opening square bracket and highlighting the code until just after the closing square bracket.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981915,"id":2981915,"title":"Get data output highlight","filename":"Screenshot-2026-09-09-140502.png","filesize":25591,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-09-140502","alt":"The output data array highlighted","author":"421552","description":"","caption":"","name":"screenshot-2026-09-09-140502","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 21:26:31","modified":"2026-09-09 21:27:13","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":572,"height":383,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","medium-width":390,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","medium_large-width":572,"medium_large-height":383,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","large-width":572,"large-height":383,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","1536x1536-width":572,"1536x1536-height":383,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","2048x2048-width":572,"2048x2048-height":383,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","card_image-width":572,"card_image-height":383,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140502.png","wide_image-width":572,"wide_image-height":383}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"4. <\/strong>Copy the highlighted section.<\/p>\n5. <\/strong>At the top of the designer, click Edit<\/strong>.<\/p>\n6. <\/strong>Between the Get data from feature layer <\/strong>action and Send an email (V2)<\/strong> action, add a new action.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981816,"id":2981816,"title":"Power-Automate-Add-Action-Between","filename":"Screenshot-2026-09-08-161600.png","filesize":12273,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-08-161600","alt":"The button to add an action between two actions","author":"421552","description":"","caption":"","name":"screenshot-2026-09-08-161600","status":"inherit","uploaded_to":2981696,"date":"2026-09-08 23:18:01","modified":"2026-09-08 23:18:42","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":259,"height":165,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600-213x165.png","thumbnail-width":213,"thumbnail-height":165,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","medium-width":259,"medium-height":165,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","medium_large-width":259,"medium_large-height":165,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","large-width":259,"large-height":165,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","1536x1536-width":259,"1536x1536-height":165,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","2048x2048-width":259,"2048x2048-height":165,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","card_image-width":259,"card_image-height":165,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-161600.png","wide_image-width":259,"wide_image-height":165}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"7. <\/strong>Search for, and add, the Parse JSON<\/strong><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981817,"id":2981817,"title":"Power-Automate-Parse-JSON","filename":"Screenshot-2026-08-27-160902.png","filesize":18571,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-08-27-160902","alt":"The Parse JSON action","author":"421552","description":"","caption":"","name":"screenshot-2026-08-27-160902","status":"inherit","uploaded_to":2981696,"date":"2026-09-08 23:23:13","modified":"2026-09-08 23:24: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":779,"height":495,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902.png","medium-width":411,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902.png","medium_large-width":768,"medium_large-height":488,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902.png","large-width":779,"large-height":495,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902.png","1536x1536-width":779,"1536x1536-height":495,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902.png","2048x2048-width":779,"2048x2048-height":495,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902-732x465.png","card_image-width":732,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-08-27-160902.png","wide_image-width":779,"wide_image-height":495}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"The Parse JSON <\/strong>window opens.<\/p>\n8. <\/strong>In the Content<\/strong> parameter, type a slash (\/<\/u>) and select Insert dynamic content<\/strong>.<\/p>\n9. <\/strong>On the Get data from feature layer<\/strong> menu of the dynamic content pane, click See more <\/strong>to expand the list, and select body\/data<\/strong>.<\/p>\n10. <\/strong>Under the Schema parameter, click Use sample payload to generate schema<\/strong>.<\/p>\n11. <\/strong>In the blank code window, paste the copied code, and click Done<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981916,"id":2981916,"title":"Power Automate Parse JSON automatic schema","filename":"Screenshot-2026-09-09-140851.png","filesize":27592,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-09-140851","alt":"An automated schema in the Parse JSON action","author":"421552","description":"","caption":"","name":"screenshot-2026-09-09-140851","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 21:28:09","modified":"2026-09-09 21:29:14","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":611,"height":491,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851.png","medium-width":325,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851.png","medium_large-width":611,"medium_large-height":491,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851.png","large-width":611,"large-height":491,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851.png","1536x1536-width":611,"1536x1536-height":491,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851.png","2048x2048-width":611,"2048x2048-height":491,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851-579x465.png","card_image-width":579,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-140851.png","wide_image-width":611,"wide_image-height":491}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"The generated schema appears in the Schema <\/strong>parameter. You have now created independent attributes for each statistic value that you can reference later as dynamic content.<\/p>\n12. Below the Parse JSON<\/strong> action, add a new action.<\/p>\n13. Search for and add the Create HTML<\/strong> action.<\/p>\nThe Create HTML <\/strong>window opens.<\/p>\n14. In the From<\/strong> parameter, type a slash (\/<\/u>) and\u00a0select Insert dynamic content<\/strong>.<\/p>\n15. Select Body<\/strong> from the Parse JSON\u00a0<\/strong>menu.<\/p>\n16. Click the Advanced parameters<\/strong> menu and select Columns<\/strong>.<\/p>\n17. In the Columns<\/strong> parameter, change the selection to Custom<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981831,"id":2981831,"title":"Power-Automate-Create-HTML","filename":"Screenshot-2026-09-01-161352.png","filesize":16923,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-01-161352","alt":"The Create HTML table action window","author":"421552","description":"","caption":"","name":"screenshot-2026-09-01-161352","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 04:12:33","modified":"2026-09-09 04:13:19","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":766,"height":395,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","medium-width":464,"medium-height":239,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","medium_large-width":766,"medium_large-height":395,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","large-width":766,"large-height":395,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","1536x1536-width":766,"1536x1536-height":395,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","2048x2048-width":766,"2048x2048-height":395,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","card_image-width":766,"card_image-height":395,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-01-161352.png","wide_image-width":766,"wide_image-height":395}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"18.<\/strong> In the Header<\/strong> field, type the name of the first column you want to display.<\/p>\nIn this example, the Town grouping field will be in the first column.<\/p>\n
19.<\/strong> In the Value <\/strong>field, type a slash (\/<\/u>)\u00a0and select Insert dynamic content<\/strong>.<\/p>\n20.<\/strong> Select the dynamic content option that includes the name of the content you want to display in the first column.<\/p>\nIn this example, the attribute corresponding to the grouping field, Body town<\/strong>, is selected.<\/p>\n21.<\/strong> Repeat steps 18-21 for each statistic you retrieved from the feature layer, typing the display title for each statistic in Header<\/strong> and its corresponding dynamic attribute in Value<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981917,"id":2981917,"title":"Power Automate HTML table custom columns","filename":"Screenshot-2026-09-09-141220.png","filesize":24402,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-09-141220","alt":"Custom columns configured in the Create HTML table action","author":"421552","description":"","caption":"","name":"screenshot-2026-09-09-141220","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 21:30:20","modified":"2026-09-09 21:31:12","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":604,"height":329,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","medium-width":464,"medium-height":253,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","medium_large-width":604,"medium_large-height":329,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","large-width":604,"large-height":329,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","1536x1536-width":604,"1536x1536-height":329,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","2048x2048-width":604,"2048x2048-height":329,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","card_image-width":604,"card_image-height":329,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-141220.png","wide_image-width":604,"wide_image-height":329}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"You have now created an HTML table that will be dynamically populated with your statistics data.<\/p>\n
Format a table in an email<\/h2>\n
With an HTML table of your statistics data, you can now use CSS to format the table in an email to send to yourself or stakeholders. Complete the following steps to automate an email containing the styled table:<\/p>\n
1.<\/strong> Click the button to add an action under the Create HTML table <\/strong>action, search for the Compose<\/strong> action, and add it to the flow.<\/p>\n2.<\/strong> In the Input<\/strong> parameter, paste the following code:<\/p>\n\n<style>
\ntable {
\nborder-collapse: collapse;
\n}
\ntable td, table th {
\nborder: 1px solid #AAAAAA;
\npadding: 3px 10px;
\n}
\ntable tr:nth-child(even) {
\nbackground: #D9E1F2;
\n}
\ntable thead {
\nbackground: #4472C4;
\n}
\ntable thead th {
\nfont-size: 15px;
\nfont-weight: bold;
\ncolor: #FFFFFF;
\ntext-align: left;
\n}
\ntable tfoot {
\nfont-weight: bold;
\n}
\n<\/style><\/p>\n<\/blockquote>\n
3.<\/strong> Click after <\/style>, type a slash (\/)<\/u>, and select Insert dynamic content.<\/strong><\/p>\n4.<\/strong> Under the Create HTML table<\/strong> menu, select Output<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981844,"id":2981844,"title":"Power-Automate-Compose-CSS","filename":"Screenshot-2026-09-08-223142.png","filesize":22802,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-08-223142","alt":"CSS code entered into the Compose action","author":"421552","description":"","caption":"","name":"screenshot-2026-09-08-223142","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 05:32:36","modified":"2026-09-09 05:33:19","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":570,"height":604,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142.png","medium-width":246,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142.png","medium_large-width":570,"medium_large-height":604,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142.png","large-width":570,"large-height":604,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142.png","1536x1536-width":570,"1536x1536-height":604,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142.png","2048x2048-width":570,"2048x2048-height":604,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142-439x465.png","card_image-width":439,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-08-223142.png","wide_image-width":570,"wide_image-height":604}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"The table is now styled with delineated cells and blue backgrounds for the headers.<\/p>\n
5.<\/strong> Click the Send an email (V2) <\/strong>action at the bottom of the flow.<\/p>\nThe Send an email (V2)<\/strong> window opens.<\/p>\n6.<\/strong> Update Subject <\/strong>and Body<\/strong> parameters with the following information:<\/p>\n\n- For the Subject <\/strong>parameter, type Weekly statistics for<\/u> and type your value field.<\/li>\n
- In the Body<\/strong> parameter, type Here is the weekly statistical report for [field] from [feature layer]<\/u>: using the value field name and feature layer included in the report.<\/li>\n<\/ul>\n
7.<\/strong> Press the Toggle code view<\/strong> button\u00a0(<\/><\/strong>).<\/p>\n8.<\/strong> Place your cursor after the last paragraph tag (<\/p><\/strong>), type a slash (\/)<\/u>, select Insert dynamic content<\/strong>, and select Outputs<\/strong>.<\/p>\n9.<\/strong> Press the Toggle code view<\/strong> button\u00a0(<\/><\/strong>) to return to text view.<\/p>\n <\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981923,"id":2981923,"title":"Power Automate send email code view","filename":"Screenshot-2026-09-09-155209.png","filesize":24993,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-09-155209","alt":"The code view of the Body parameter in the Send an Email (V2) action","author":"421552","description":"","caption":"","name":"screenshot-2026-09-09-155209","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 22:54:17","modified":"2026-09-09 22:55:14","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":757,"height":313,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","medium-width":464,"medium-height":192,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","medium_large-width":757,"medium_large-height":313,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","large-width":757,"large-height":313,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","1536x1536-width":757,"1536x1536-height":313,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","2048x2048-width":757,"2048x2048-height":313,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","card_image-width":757,"card_image-height":313,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-155209.png","wide_image-width":757,"wide_image-height":313}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
10.<\/strong> Click Save<\/strong> at the top of the flow designer, and then click 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":"The flow will now send an email detailing the weekly statistics of a field from the feature layer in a formatted table.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2981920,"id":2981920,"title":"Power Automate statistic table email","filename":"Screenshot-2026-09-09-142018.png","filesize":74752,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\/screenshot-2026-09-09-142018","alt":"A test email generated from the workflow","author":"421552","description":"","caption":"","name":"screenshot-2026-09-09-142018","status":"inherit","uploaded_to":2981696,"date":"2026-09-09 22:28:28","modified":"2026-09-09 22:29:26","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":381,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018.png","medium-width":464,"medium-height":153,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018.png","medium_large-width":768,"medium_large-height":254,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018.png","large-width":1154,"large-height":381,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018.png","1536x1536-width":1154,"1536x1536-height":381,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018.png","2048x2048-width":1154,"2048x2048-height":381,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018-826x273.png","card_image-width":826,"card_image-height":273,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/Screenshot-2026-09-09-142018.png","wide_image-width":1154,"wide_image-height":381}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Note:<\/strong> If CSS styling breaks in the Microsoft Outlook desktop app, try opening the test email in a separate window.<\/p>\nBy formatting dynamic content for automated data reports, you can share multiple statistics, with multiple people, without manually composing emails. This blog series enables continuous updates to collaborators and decision-makers on dynamic feature layers.\u00a0<\/span><\/p>\n"}],"related_articles":"","show_article_image":false,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2026\/09\/adobestock-182072963.jpg","wide_image":false},"yoast_head":"\nFormat a weekly feature layer statistics table with Power Automate<\/title>\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\/format-an-automatic-table\" \/>\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 2: Format an automatic table\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\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=\"10 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\/format-an-automatic-table#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\"},\"author\":{\"name\":\"Brandley Simms\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bf3c65008e65261cf0db56d2491daec4\"},\"headline\":\"Send weekly feature layer statistics with Power Automate Part 2: Format an automatic table\",\"datePublished\":\"2026-09-10T00:02:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\"},\"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\/format-an-automatic-table#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\",\"name\":\"Format a weekly feature layer statistics table with Power Automate\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2026-09-10T00:02:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table#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 2: Format an automatic table\"}]},{\"@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\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Format a weekly feature layer statistics table with Power Automate","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\/format-an-automatic-table","og_locale":"en_US","og_type":"article","og_title":"Send weekly feature layer statistics with Power Automate Part 2: Format an automatic table","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table"},"author":{"name":"Brandley Simms","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bf3c65008e65261cf0db56d2491daec4"},"headline":"Send weekly feature layer statistics with Power Automate Part 2: Format an automatic table","datePublished":"2026-09-10T00:02:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table"},"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\/format-an-automatic-table#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table","name":"Format a weekly feature layer statistics table with Power Automate","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2026-09-10T00:02:33+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/microsoft-365\/data-management\/format-an-automatic-table#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 2: Format an automatic table"}]},{"@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"}]}},"text_date":"September 9, 2026","author_name":"Brandley Simms","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/bsimmsesri-com_esriinc-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":974,"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\/2981696","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=2981696"}],"version-history":[{"count":14,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2981696\/revisions"}],"predecessor-version":[{"id":2981930,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2981696\/revisions\/2981930"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2981696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2981696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2981696"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2981696"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2981696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
"}],"short_description":"Upgrade a weekly power automate flow to format a table of statistics from a feature layer field.","flexible_content":[{"acf_fc_layout":"content","content":"