How to update attributes of features within a newly created polygon?

Question

I got help at the ESRI UC to start building a Power Automate workflow that is supposed to automatically update fields within existing point and line features that intersect the newly created polygon features. I've been fiddling with it and although my current flow says it is running successfully, when it gets to the part where it is supposed to update point and line features, it skips this part. I am new to all of this and would appreciate tips or advice!

In the above image, the left side is to update lines and the right side is to update points. I was testing if the additional query step was helpful or not. Since neither lines nor points updated, neither option worked.

And here is where I see it has skipped updating any points:

Akshay Harshe · Answer

@IngridHogle Looking at the flow you can and your comments Likely that the `Get data from feature layer` action is not returning any results. The geometry combined with the Where clause is probably the culprit.

You can open a run that was successful in Power automate and click on the action. On the left hand pane you should see Show Raw outputs (or inputs) this should show you the JSON output of your query.

From Show raw inputs you can copy the parameters and run the query directly on the REST Endpoint to see what is wrong with it and what fixes it. You can see ArcGIS REST API documentation for the Query endpoint here: Query (Feature Service/Layer) | ArcGIS REST APIs | Esri Developer for more details. the `Get data from feature layer uses this endpoint behind the scenes. Hope you find the issue and the solution. The flow logic looks good to me.

IngridHogle · Answer

Thank you, @CalvinHarmin . Good suggestion. I added email notification to check what was happening with my Fetch updates action, and indeed it is not actually pulling info of new features. I'll report back if I make any progress!

CalvinHarmin · Answer

If I had to guess, the for each action is being provided an empty array [], so it is skipping the action since there are no items to iterate over.

My suggestion is to look at the 'outputs' of one of your flow attempts:

* Fetch updates action* Does the body of the outputs for this action actually contain a reference to a polygon feature?
* If not, you'll need to diagnose that to understand how and when it actually pulls info of a new feature
* If so...

* Get data from feature layer* Does the output body have an array of 1 or more intersecting features?