ArcGIS online マップに動的に表示されるジオコードされた SharePoint データ

Question

こんにちは、

ジオコードされたレコードを含む SharePoint リストと、ジオコードされたレコードを含む .csv ファイルを提供するフローをいくつか実行しています。

これらのうちの一つをデータソースとして使用し、リストまたは .csv ファイルが更新されるたびにマップが更新され、そのレコードがマップ上に表示されるようにしたいと考えています。理想的には、これは自動的に行われ、私が手動でフローを実行したりフィーチャ レイヤーを編集したりする必要はありません。

空の .csv をテンプレートとして使用してホスト フィーチャ レイヤーを作成したので、更新されたリストまたは .csv データが ArcGIS online に配置される場所があります。ただ、それをリストまたは SharePoint ホストの .csv からそのフィーチャ レイヤーに自動的に毎回取得する方法がわかりません。

もう頭がパンクしそうです。何か提案はありますか？

<\/P>

RaajRaaj · Answer

Hello @AdamRoesel --

We are in the process of adding a feature enhancement in the October 2025 release of ArcGIS for SharePoint which would allow you to automate geocoding SharePoint lists using this new feature enhancement. The automation capability will be added to the existing "Geoenablement" feature. Similar to the "Extract EXIF Data" feature, you will be able to set up a "Geoenablement" workflow by leveraging the "ArcGIS" connectors but the app will take care of setting up the flow (behind the scenes). As a user, you would just need to select your "Power Automate Environment, "ArcGIS" and "SharePoint" connections and that's all.

Stay tuned!

I will be posting a blog update (on Esri Community) once the app is updated in Microsoft App Source.

https://appsource.microsoft.com/en-us/product/office/wa200003118?tab=overview

Special thanks to @AustinAverill for your detailed post on setting up a Power Automate flow to accomplish @AdamRoesel's workflow.

Please let me know if you have any questions.

Thanks & Regards,

Raaj

AustinAverill · Answer

Probably also worth mentioning that his can be made slightly less complicated using the ArcGIS Connectors if you pay for them. But if you don't using HTTP requests and the REST API gets the job done for sure.

AustinAverill · Answer

This is going to be a bit lengthy, so bare with me. I will include a picture of an overall example flow

This example operates for individual additions to a SharePoint list. If you bulk add items, it may be more effective to use a timed/manual trigger and then use the "Get Items" action with an appropriate query to pull the data. If you use this method, the following steps would just need to nested inside of a "Apply to each" action so that it loops through each row that was added to the list.

The first step will be to parse your X and Y variables from the location attribute in the list. In the example, my coordinates are listed as ['DispName'] in the body as a pair in string format. So, I parse those and convert them to a float as follows:

After I have my x and y coordinates parsed and available, I find it a best practice to initialize a new variable to create the JSON for my feature. Just remember that when you add string data into the attributes section from your list item response, you need to surround it in quotes for proper JSON syntax:

Once you have the feature json definition ready, you can generate a token, and sent the POST request to add the feature to your AGOL layer. (If you are doing a batch of features instead of one, you should move the generate token action to before your "Apply to each" action set so that you aren't creating unneeded overhead). So first, generate your token:

Then, you can send the POST request to add the feature to your hosted feature layer using the token from the previous request and the json object created for the new feature.

Finally, it is a good idea to keep a column on your sharepoint list for the hosted objectid. Once you add the feature, the JSON response will include the objectid for the created feature that you can use to update your list item. This will be useful later if you want to set up other flows to update or remove items on the hosted feature layer using the editFeatures method.

One final note to keep in mind is that the standard geometry pair that is given with sharepoint geometry is WKID 4326. If your hosted feature layer is not in this spatial reference you will need to add a request into the flow to use the project utility from Arcgis or some other service that would allow you to project the coordinate to the required reference.