Actualizar una clase de entidad cuando hay cambios en una fila de Excel

Question

Actualmente tengo un flujo automatizado donde Survey123 actualiza filas en una tabla de Excel y luego se envía un correo electrónico con la información actualizada de la encuesta. Mi problema es que no puedo pensar en una forma de actualizar la clase de entidad cuando alguien actualiza una celda dentro de la tabla de Excel.<\/P> ¿Es posible tener ambas opciones, actualizar la tabla de Excel desde la encuesta y\/o poder actualizar la clase de entidad a partir de los cambios realizados en la tabla de Excel? Y también tengo conocimientos muy limitados de Power Automate, ¡pero estoy haciendo mi mejor esfuerzo! <\/P> Este es mi flujo..<\/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