nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Scheduling a single, weekly summary email of all features in a hosted ArcGIS Online Feature layer View

AndreaF-CO

I am struggling to create a flow in Power Automate that will look in a hosted ArcGIS Online feature layer view and summarize the features in a single email. I have Googled and ChatGPTed this question to death, but I can't get it to work, even though it's very clear it is possible. The closest I've gotten is sending a single email for each feature (1. Setting Recurrence 2. Get data from feature layer 3. Apply to each (Send an email notification)), but I'd like them all listed in a single email.

I have the ArcGIS premium connector. I've tried all varieties of using an array (Initializing a variable (array), Appending to array variable, Creating HTML table, etc) without any luck. I'm confident I'm just missing a small piece of information or have things ordered incorrectly or am just missing a single checkbox.

Can anyone provide the exact steps to accomplish this? Screenshots would be a major bonus!

Find more posts tagged with

Accepted answers

AndreaF-CO

Thank you @abureaux and @JeffSilberberg for the suggestions! I finally got this to work after about 20 ChatGPT adjustments back and forth. A lot of online ideas and AI pointed to creating an array variable to accomplish this, and others suggested building an html table to hold the content to insert into an email. Most of the things I tried would throw errors regarding field type mismatches or that the type was NULL and it was expecting text, etc. Too many errors to post!

I finally got to a point of sending an email for each record in my feature class, but I wanted it all in one email. This was due to the apply to each automatically getting nested which is not what I wanted, and none of the online help explicitly said to NOT nest them.

This entirely came down to my lack of knowledge of Power Automate (PA) and building flows and what pieces to use and how to nest them - I'm still learning!

For anyone that happens across this post that is new to PA like me, this is how I got it to work. I'm sure it's rudimentary for a seasoned PA user, but it just wasn't intuitive to me for some reason.

1. Create a scheduled flow

2. Set the recurrence

3. Use the Get data from feature layer ArcGIS Connector tool

-Add each field at the bottom that you may need in your email

4. Initialize a String variable (this is where ChatGPT finally landed for me after I kept getting errors creating an array variable and html table and ChatGPT couldn't resolve them)

5. Add an Apply to each function. Set the input as Data from your Get Data function.

6. Add an Append to string variable. Here you format the feature content that will repeat in your email.

Note the syntax for each attribute. ChatGPT provided this and I couldn't replicate it by choosing a Dynamic Content item, so I had to copy it in. I'm sure it was just user error...

7. Add a send email function (yours may not be the same as mine, fyi)

So far it's working great!

All comments

JeffSilberberg

You haven't really said what you have tried and how you are working this. But:

https://doc.arcgis.com/en/power-automate/latest/automate/actions.htm

Get data from feature layer action

https://developers.arcgis.com/rest/services-reference/enterprise/query-feature-service-layer/?rsource=https%3A%2F%2Flinks.esri.com%2Fpa-doc%2Fquery-layer-api

Set the Request parameters to get the data you want --

Then process the JSON Response Object you get back.

ChatGPT will give you a decent place to start--

Show a Power Automate script to use the AGOL automate actions to query a feature layer and then iterate through the returned JSON, creating a table of all the features returned. Finally sending the table in the body of and email.

abureaux

What is the issue you are experiencing?

The only thing that comes to mind for me is size. Get Data can only get so much data in one execution. You may need to dump it into a Do Until to return everything.

For example, in my test here I have 776 items, but I only get 150 at a time (but we could be talking over 100,000 items):

To get everything, I would need to iterate through the data until nothing else is returned. There is even a handy property that will tell you if there is more data:

General Process

Disclaimer. This was just a super quick thing I tossed together during my endless meetings. It may not be the best way to do this, but it is at least a starting point.

As you can see from the final step here, I was able to get all 776 items by iterating through the layer.

This flow consists of...

Three variables:

A do until loop:

With these steps:

Note the few things I set at the end. For my super quick example, I just grabbed ObjectID and did a union. You probably don't want to do that. Again, this is just a quick example.

union(
    variables('completeData'),
    outputs('Get_data_from_feature_layer')?['body/data']
)

@{outputs('Compose_-_completeData')}

@{outputs('Get_data_from_feature_layer')?['headers/hasMoreData']}

length(outputs('Get_data_from_feature_layer')?['body/data'])

EDIT: I have a couple things after the Do Until loop that I didn't mention (you can see them in the first screen shot). They don't really contribute to the flow beyond proving that it worked. In your case, you'd probably have something like a Create HTML Table after the loop to format your data.

Tips

Return Geometry should be "No" for better performance. Unless you actually need it, that is.

You can modify the number of records returned. Doing this depends on your use-case. If you don't have too many records, you could just increase this to grab everything.

AndreaF-CO

This entirely came down to my lack of knowledge of Power Automate (PA) and building flows and what pieces to use and how to nest them - I'm still learning!

For anyone that happens across this post that is new to PA like me, this is how I got it to work. I'm sure it's rudimentary for a seasoned PA user, but it just wasn't intuitive to me for some reason.

1. Create a scheduled flow

2. Set the recurrence

3. Use the Get data from feature layer ArcGIS Connector tool

-Add each field at the bottom that you may need in your email

4. Initialize a String variable (this is where ChatGPT finally landed for me after I kept getting errors creating an array variable and html table and ChatGPT couldn't resolve them)

5. Add an Apply to each function. Set the input as Data from your Get Data function.

6. Add an Append to string variable. Here you format the feature content that will repeat in your email.

Note the syntax for each attribute. ChatGPT provided this and I couldn't replicate it by choosing a Dynamic Content item, so I had to copy it in. I'm sure it was just user error...

7. Add a send email function (yours may not be the same as mine, fyi)

So far it's working great!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.