Datos de SharePoint geocodificados mostrados dinámicamente en el mapa de ArcGIS online

Question

Hola,

Tengo algunos flujos en ejecución que me proporcionan una lista de SharePoint con registros geocodificados y un archivo .csv con registros geocodificados.

Lo que me gustaría hacer es usar uno de esos como fuente de datos para crear un mapa que se actualice cada vez que la lista o el archivo .csv se actualicen, y mostrar esos registros en un mapa. Idealmente, esto se haría automáticamente y no requeriría que ejecute manualmente un flujo o edite una capa de entidades.

He creado una capa de entidades alojada usando un .csv en blanco como plantilla, así que tengo un lugar para que los datos actualizados de la Lista o del .csv se carguen en ArcGIS online. Simplemente no puedo averiguar cómo llevarlo desde la Lista o el .csv alojado en SharePoint a esa capa de entidades, automáticamente, cada vez.

Mi cerebro está agotado en este punto. ¿Alguien tiene alguna sugerencia?

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