Aktualisierung einer Feature-Class bei Änderungen an einer Excel-Zeile

Question

Ich habe derzeit einen automatisierten Flow, bei dem ein Survey123 Zeilen in einer Excel-Tabelle aktualisiert und anschließend eine E-Mail mit den aktualisierten Informationen aus der Umfrage versendet wird. Mein Problem ist, dass ich keine Möglichkeit finde, die Feature-Class zu aktualisieren, wenn jemand eine Zelle innerhalb der Excel-Tabelle ändert.<\/P> Ist es möglich, beides zu haben: die Excel-Tabelle aus der Umfrage zu aktualisieren und/oder die Feature-Class basierend auf Änderungen in der Excel-Tabelle zu aktualisieren? Und ich habe auch nur sehr begrenzte Power Automate-Kenntnisse, aber ich gebe mein Bestes! <\/P> Dies ist mein Flow..<\/P> <\/span><\/P> <\/P>

CodyPatterson · Answer

Hey @JessMiller1

No worries at all, I'm sorry my original information didn't end up helping. I found this here though, which provides some insight on using Survey123 responses: https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/changing-hosted-feature-layers-with-power-automate/td-p/1144399

In terms of a user updating an Excel row, there does not seem to be support to check if that occurs. What is possible though would be to have a scheduled flow to run at a set amount of time, which then checks the Excel sheet for updated information, and adds that to a class. In order to send these edits to a feature class, you would need to follow the link above to send POST requests out after retrieving a token. This is a quite advanced flow, but I believe it is possible, I have not set something up that is this involved, but I am sure that I can help in any way!

Hope this helps!

Cody

JessMiller1 · Answer

I apologize I never thanked you for the reply! I appreciate your assistance with the documentation, but unfortunately they are no help for my specific issue. I'm looking for a way to update a feature class based on a change in an excel table. The excel is a part of my flow Survey123->Add Row in Excel -> Email. But I want the user to be able to update the row/cell in excel and it will update the feature class. Any other ideas?

CodyPatterson · Answer

Hey @JessMiller1

You may find some luck with this document here, I have used this previously and it has worked pretty well for me, https://learn.microsoft.com/en-us/connectors/arcgis/#update-a-record-in-a-feature-layer

Here is the main documentation page for ArcGIS and Power Automate, I've recently been involved in a pretty heavy project with Power Automate, so I will gladly help if I can!

https://learn.microsoft.com/en-us/connectors/arcgis/

Cody