Power Automate Flow to Copy Data from Sharepoint to ArcGIS Enterprise Server on the Fly

_CameronPearson

Hello, We are trying to implement a flow to copy flat file data to our ArcGIS Enterprise portal on the fly. Anytime an end user updates/changes the flat file sitting in Sharepoint which has address/location within the attributes we would like the data copied/updated on our ArcGIS Enterprise Server in near real time. This will allow our maps/apps/dashboards to get synced with up to date data. Any help on the easiest workflow would be greatly appreciated.

Regards,

Cameron

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.