Données SharePoint géocodées affichées dynamiquement dans une carte ArcGIS online

Question

Bonjour,

J'ai des flux en cours d'exécution qui me fournissent une liste SharePoint avec des enregistrements géocodés, ainsi qu'un fichier .csv avec des enregistrements géocodés.

Ce que je voudrais faire, c'est utiliser l'un de ces éléments comme source de données pour créer une carte qui se met à jour à chaque fois que la liste ou le fichier .csv est mis à jour, et afficher ces enregistrements sur une carte. Idéalement, cela serait fait automatiquement et ne nécessiterait pas que je lance manuellement un flux ou que j'édite une couche d'entités.

J'ai créé une couche d'entités hébergée en utilisant un fichier .csv vierge comme modèle, donc j'ai un emplacement pour que les données mises à jour de la Liste ou du fichier .csv atterrissent dans ArcGIS online. Je n'arrive tout simplement pas à comprendre comment les transférer de la Liste ou du fichier .csv hébergé sur SharePoint vers cette couche d'entités, automatiquement, à chaque fois.

Mon cerveau est complètement épuisé à ce stade. Quelqu'un aurait-il des suggestions ?

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