Power Automate Flow pro kopírování dat ze Sharepointu do ArcGIS Enterprise Serveru za běhu

_CameronPearson

Dobrý den, snažíme se implementovat flow pro kopírování dat z flat file do našeho portálu ArcGIS Enterprise za běhu. Kdykoli koncový uživatel aktualizuje nebo změní flat file uložený na Sharepointu, který obsahuje adresu nebo lokaci v atributech, chtěli bychom, aby byla data zkopírována nebo aktualizována na našem ArcGIS Enterprise Serveru téměř v reálném čase. To umožní našim mapám, aplikacím a dashboardům být synchronizovány s aktuálními daty. Jakákoli pomoc s nejjednodušším workflow by byla velmi oceněna.<\/P>

S pozdravem,<\/P>

Cameron<\/P>

SeanKMcGinnis

Good Day @_CameronPearson - at this time, the ArcGIS Connector for Power Automate only connects to ArcGIS Online. We are working on identifying the security best practices that will allow the connector to authenticate against Enterprise and are planning to release it by the end of this year.

That being said, the workflow you are laying out is possible with existing actions and triggers against hosted feature layers in ArcGIS Online. Microsoft does have a trigger to listen for new or edited files. The flat file would have to be structured so it could be iterated through and include unique ID's for each record. There will be some complexity in determining if the record needs to be updated because of a change or created because it is a new record. But the ArcGIS Connector's update and create record actions could handle it.

One thing that might make the process a little easier is instead of a flat file, using a SharePoint list. The Power Automate trigger for lists knows which record has been created or edited and would pass the unique ID and the flow is working with a single record and not having to infer the delta(s).

I hope this helps and feel free to share any comments or other questions you may have.