Een feature class bijwerken wanneer er wijzigingen zijn in een Excel-rij

Question

Ik heb momenteel een geautomatiseerde flow waarbij een Survey123 rijen in een Excel-tabel bijwerkt en vervolgens wordt er een e-mail verzonden met de bijgewerkte informatie uit de enquête. Mijn probleem is dat ik geen manier kan bedenken om de feature class bij te werken wanneer iemand een cel binnen de Excel-tabel aanpast.<\/P> Is het mogelijk om het op beide manieren te doen, de Excel-tabel bijwerken vanuit de enquête en\/of de feature class kunnen bijwerken vanuit wijzigingen die in de Excel-tabel zijn aangebracht? En ik heb ook zeer beperkte kennis van Power Automate, maar ik doe mijn best! <\/P> Dit is mijn 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