Geocode in SharePoint using Microsoft Power Automate

Note:

Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.

You can use Microsoft Power Automate and ArcGIS Connectors for Power Automate to add coordinates to Microsoft SharePoint lists and document libraries that only contain address data. See Data and geocoding for more information about geocoding processes and services.

To map SharePoint lists or document libraries in ArcGIS for SharePoint, the list or library must contain x,y coordinates or Esri JSON geometry. If the SharePoint list or library contains addresses without coordinates or shape data, the data must be geocoded or spatially enabled. You can use the Sharepoint Locate Workflow template from Power Automate to geocode SharePoint lists and libraries. Power Automate can read the address information from the SharePoint list and generate the coordinate location information so it is ready to be mapped.

Tip:
If you do not have a Microsoft Power Automate license or permissions to access premium connectors, try the Geocode SharePoint lists and document libraries workflow.

Prepare a SharePoint list or document library

To ensure that the SharePoint list or document library is ready to be geocoded, complete the following steps:

  1. Open the SharePoint list or library that contains address information.
  2. Add a new Multiple lines of text column titled X.
  3. Add a new Multiple lines of text column titled Y.
  4. For more information about column types, see the Microsoft List and library column types and options article.

Open the Sharepoint Locate Workflow template in Power Automate

To open the Sharepoint Locate Workflow template in Power Automate, complete the following steps:

  1. Click Integrate > Power Automate > Create a flow on the SharePoint menu bar.

    Create a flow option on the Power Automate drop-down menu

  2. In the Create a flow pane, click Show more.

    Show more drop-down menu in the Create a flow pane

  3. At the bottom of the list of templates, click See more templates.

    The Power Automate templates page appears.

  4. Type ArcGIS in the search text box.
  5. Choose the Sharepoint Locate Workflow template from the search results.
    The Sharepoint Locate Workflow template page appears.
  6. Click Try it now.

Use the Sharepoint Locate Workflow template

To fill out the Power Automate template to geocode the SharePoint list or library, complete the following steps:

  1. Sign in to Power Automate using your Microsoft credentials.

    A page listing your Power Automate flow connections appears.

    SharePoint Locate Workflow page showing SharePoint and ArcGIS connections

  2. Confirm that you are signed in to ArcGIS and click Continue.

    The flow template appears containing two actions. You must provide information for each action.

  3. For the Get Items action, do the following:
    1. From the Site Address drop-down menu, choose the SharePoint site containing the SharePoint list or library to geocode.
    2. From the List Name drop-down menu, choose the list to geocode.

    Tip:

    You can click Show advanced options to specify the total number of rows in the list in the Top Count text box.

    The Get Items action is now complete.

  4. For the Find address candidate action, do the following:
    Note:
    The Find address candidate action is automatically enclosed in an Apply to each action. The Find address candidate action is applied to each of the items received by the Get Items action in the previous step.

    Find address candidate and Update item connectors enclosed in Apply to each action

    1. Click Menu options Menu options on the Find address candidate action.

      Confirm that ArcGIS is selected as the connection, and return to the action.

      Tip:

      There may be multiple ArcGIS connections listed. This is a known limitation of Microsoft.

    2. From the Store results drop-down menu, choose Yes.
      Note:

      Yes may already be selected by default.

    3. In the Address text box, specify the column containing the full address to geocode.
    4. In the Country text box, specify the country where the addresses are located.

    The Find address candidate action is now complete.

  5. For the Update item action, do the following:
    Note:

    The Update item action is also enclosed in an Apply to each action.

    1. Ensure that Site Address contains the SharePoint site to geocode.
    2. Ensure that List Name contains the SharePoint list to geocode.
    3. Ensure that Id contains the ID derived from the Get items action.
    4. Click Show advanced options and confirm that the X column that you created in step 2 of the Prepare a SharePoint list or document library section above contains the Longitude (X) dynamic value from ArcGIS and the Y column that you created in step 3 of that workflow contains the Latitude (Y) dynamic value from ArcGIS.

    The Update item action is now complete.

  6. Click Save to save the template.

    Tip:

    You can verify the flow using the Flow checker tool on the Power Automate toolbar.

    Flow checker tool

  7. Click Test to test the flow.

    The test runs, which causes the flow to run and update the specified SharePoint list.

    Note:

    The test may take a few minutes.