Power Automate フローで Sharepoint から ArcGIS Enterprise Server へデータをリアルタイムでコピーする方法

_CameronPearson

こんにちは、私たちはフラットファイルのデータをリアルタイムで ArcGIS Enterprise ポータルにコピーするフローを実装しようとしています。エンドユーザーが Sharepoint にある住所や位置情報を含む属性を持つフラットファイルを更新・変更するたびに、そのデータがほぼリアルタイムで ArcGIS Enterprise Server にコピー・更新されるようにしたいと考えています。これにより、私たちのマップ、アプリ、ダッシュボードが最新のデータと同期されます。最も簡単なワークフローについてのご助言をいただけると大変ありがたいです。<\/P>

よろしくお願いいたします。<\/P>

キャメロン<\/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.