Excelの行に変更があった場合のフィーチャクラスの更新

Question

現在、Survey123がExcelテーブルの行を更新し、その後調査からの更新情報を含むメールが送信される自動化フローを持っています。私の問題は、誰かがExcelテーブル内のセルを更新したときにフィーチャクラスを更新する方法が思いつかないことです。<\/P> 調査からExcelテーブルを更新する方法と、Excelテーブルで行われた変更からフィーチャクラスを更新する方法の両方を実現することは可能でしょうか？また、Power Automateの知識は非常に限られていますが、最善を尽くしています！ <\/P> これが私のフローです..<\/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