nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SharePoint-Liste mit Power Automate Workflow geokodieren

FrancisHourigan1

Hallo zusammen,

ich probiere gerade einen Workflow aus, bei dem ich den Power Automate ArcGIS Flow Connector verwende, um eine SharePoint-Liste zu geokodieren, die vollständige Adressen enthält. Ich habe nur begrenzte Dokumentation darüber gefunden, wie man dies erreicht (hauptsächlich sind die Schritte in vielen verschiedenen Dokumentationsartikeln verteilt und die Zwischenschritte fehlen). Hat das schon jemand ausprobiert und einen einfachen Workflow gefunden? Außerdem gibt es 600 Datensätze, daher muss ich zur Vermeidung eines Timeouts die iterative Funktion aus diesem Beitrag verwenden: https://community.esri.com/t5/arcgis-for-power-bi-blog/working-with-datasets-in-power-automate/ba-p/1126908. Eine weitere Frage, die ich habe, ist, wie viele Credits von meinem AGOL-Konto dafür verwendet werden und ob es eine Möglichkeit gibt, dies im Voraus zu berechnen oder zu überprüfen?

Finde mehr Beiträge mit dem Tag

Accepted answers

RaajRaaj

Hi @FrancisHourigan1 - We have published a Power Automate template to geocode Sharepoint lists. The template can be accessed/downloaded using the below link. Let me know if you have any questions.

Thanks,

Raaj

https://us.flow.microsoft.com/en-us/galleries/public/templates/9786376914db48f4b0297cd55edd6085/sharepoint-locate-workflow/

All comments

RaajRaaj

Hi @FrancisHourigan1 - We have published a Power Automate template to geocode Sharepoint lists. The template can be accessed/downloaded using the below link. Let me know if you have any questions.

Thanks,

Raaj

https://us.flow.microsoft.com/en-us/galleries/public/templates/9786376914db48f4b0297cd55edd6085/sharepoint-locate-workflow/

RaajRaaj

@FrancisHourigan1

I also wanted to share a simpler Power Automate flow which can geocode a SP list way faster than what I had shared earlier.

Anonymous User

@FrancisHourigan1 The credit cost is the same across the system, so every 1,000 records geocoded will cost 40 credits. Power Automate will use the services you configured in your flow, and will run based on your triggers. For detailed information on premium services and credits, please review the following site.

https://doc.arcgis.com/en/arcgis-online/administer/credits.htm#ESRI_SECTION1_709121D2C7694DCAB9B8592F36F7A5BA

RaajRaaj

Hi @FrancisHourigan1 --

Thanks for reaching out to us. We value your feedback and we will make sure to address your questions/concerns/enhancement requests within the next 1-2 releases. Regarding the enhancement request to provide estimated credits that will be consumed when a flow containing an ArCGIS connector is run by an end user, we have received similar requests from our end users and I can assure you that we will try to address this as soon as possible.

With regards to steps on how to use the "Find Address" ArcGIS Connector for Power Automate, I am attaching the below screenshots showing a flow I have set up to geocode a SP list with 600+ records.

Overall flow:

Each step explained:

Get items from SP list

Initialize variable

"Do until"

I create the SP list with columns "longitude", "latitude" and "Status" (from an Excel table). The flow will populate the "longitude" and "latitude" columns and the "status" column is used to iterate the flow to process more than 150 records (avoid time out issue). The excel table used for creating the SP list has the column "status" populated with the value "Processed" and this will allow the flow to run until it cannot find any records with the status="Processed".

Hope this helps.

Let me know if you have any additional questions.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.