Mise à jour d'une classe d'entités lorsqu'il y a des modifications dans une ligne Excel

Question

J'ai actuellement un flux automatisé où un Survey123 met à jour les lignes dans un tableau Excel, puis un e-mail est envoyé avec les informations mises à jour du sondage. Mon problème est que je ne trouve pas de moyen pour mettre à jour la classe d'entités lorsqu'une personne modifie une cellule dans le tableau Excel.<\/P> Est-il possible d'avoir les deux options, mettre à jour le tableau Excel depuis le sondage et\/ou pouvoir mettre à jour la classe d'entités à partir des modifications apportées au tableau Excel ? Et j'ai aussi des connaissances très limitées en Power Automate, mais je fais de mon mieux ! <\/P> Voici mon flux..<\/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