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

[AndreaFaganLittleton]

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! 

[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/?rsourc...

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.