Aktualizace třídy prvků při změnách v řádku Excelu

Question

Momentálně mám automatizovaný tok, kde Survey123 aktualizuje řádky v tabulce Excel a poté je odeslán e-mail s aktualizovanými informacemi z průzkumu. Můj problém je, že nemohu přijít na způsob, jak aktualizovat třídu prvků, když někdo upraví buňku v tabulce Excel.<\/P> Je možné mít obě možnosti, tedy aktualizovat tabulku Excel z průzkumu a/nebo být schopen aktualizovat třídu prvků ze změn provedených v tabulce Excel? A také mám velmi omezené znalosti Power Automate, ale snažím se co nejvíce! <\/P> Toto je můj tok..<\/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