Geocodeerde SharePoint-gegevens dynamisch weergegeven in ArcGIS online kaart

Question

Hallo,

Ik heb een aantal flows draaien die mij een SharePoint-lijst met geocodeerde records geven, en een .csv-bestand met geocodeerde records.

Wat ik graag zou willen doen is een van deze gebruiken als gegevensbron om een kaart te maken die elke keer wordt bijgewerkt wanneer de lijst of het .csv-bestand wordt bijgewerkt, en die die records op een kaart weergeeft. Idealiter gebeurt dit automatisch en hoeft ik niet handmatig een flow uit te voeren of een feature layer te bewerken.

Ik heb een hosted feature layer gemaakt met behulp van een leeg .csv-bestand als sjabloon, zodat ik een plek heb waar de bijgewerkte lijst- of .csv-gegevens in ArcGIS online kunnen landen. Ik kan alleen niet uitvinden hoe ik het automatisch van de lijst of SharePoint hosted .csv naar die feature layer krijg, elke keer.

Mijn hoofd is op dit punt helemaal leeg. Heeft iemand suggesties?

<\/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.