ArcGIS

ArcGIS connects your automated workflows to resources from your ArcGIS organization. Access geoenrichment, geocoding, and routing services to add demographics and location information to your data. You can also use ArcGIS to create feature layers and fetch data from existing feature layers in your ArcGIS organization.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Esri Power Automate Support
URL https://community.esri.com/t5/arcgis-for-power-bi-questions/bd-p/arcgis-for-power-bi-questions
Email powerautomate@esri.com
Connector Metadata
Publisher Esri Inc.
Website https://www.esri.com/powerbi/
Privacy policy https://www.esri.com/en-us/privacy/privacy-statements/privacy-statement
Categories IT Operations; Business Intelligence

The ArcGIS Connector helps you gain location intelligence by leveraging location based services available within your ArcGIS Online organization to enhance understanding, insight, and support data-driven decision-making. It provides the capabilities to geo-enrich your business data, spatially enable information from external data sources, and access location-based details from hosted feature services.

Prerequisites

  • An ArcGIS account to an ArcGIS Online organization is required to use this connector.

How to get an ArcGIS account

If you don't have an ArcGIS Account, you can create an ArcGIS Account. Public accounts has limits on capabilities. To use most of the actions in this connector, you need an ArcGIS Organizational account.

If you don't have an ArcGIS Online organization, you can sign up for a trial organization first.

If your team / group / organization already has an ArcGIS Online subscription, contact your administrator or IT department to request to be added or invited to the ArcGIS Online organization.

Get started with ArcGIS connector

To use most of the actions, the role that the ArcGIS account belongs to needs certain privilege / permission:

Action Privilege
Geoenrichment Geoenrichment
Find address candidate Geocoding
Geocode addresses Geocoding
Point to point routing Network Analysis
Get geometry from feature layer -
Get data from feature layer -
Create feature layer Publish hosted feature layers

Limitations

  1. Connections will time out after 90 days and must be refreshed manually by initiating a sign-in to ArcGIS.

  2. When using the Geocode addresses or Create feature layer action, for large datasets the input to the action will need to be batched or chunked into multiple individual requests.

    Name Limit
    Geocode addresses 150 rows per request
    Get data from Feature Layer 1000 rows per request without geometry
    Get data from Feature Layer 150 rows per request with geometry
    Geometry lookups 1 geometry per request
    Point to point routing 150 stops per request

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 seconds

Actions

Create a record in a feature layer

This action adds a new record to a feature layer.

Create feature layer

Create a feature layer in ArcGIS using data from an existing source, such as a SharePoint list. A feature layer is a grouping of similar geographic features, for example, buildings, parcels, cities, roads, and earthquake epicenters. Features can be points, lines, or polygons (areas). Feature layers are most appropriate for visualizing data on top of a basemap.

Delete a record from feature layer

This action deletes one or many records from a feature layer using IDs.

Fetch updates, changes, or deletions from feature layer

Fetch the updates, changes, or deletions that were made to your selected feature layer. This action is used in conjunction with the trigger on your feature service.

Find address candidate

Locate a single address using a geocode service resource. This resource provides information about candidates, including the address, location, and match score. The result of this operation is a list of address candidates.

Geocode addresses

Find multiple (batch) addresses, place-names, and businesses and then display that information on a map. This data can be added to an existing dataset or you can create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.

Geoenrichment

Get facts about a location or area. Using the GeoEnrichment service, you can get information about the people, places, and businesses in a specific area or within a certain distance or drive time from a location.

Get data from feature layer

Connect to a feature layer in ArcGIS and pull its data and attributes into your existing dataset or create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.

Get geometry from feature layer

Get geometry or boundary information from a feature layer and export it as Esri JSON or to a shape column in your dataset. This data can be used in all ArcGIS for Microsoft 365 products.

Point to point routing

Create point-to-point routes. Points in a route can visited in the order you specify or in the order that minimizes overall travel time or distance. Routes represent the quickest or shortest path along roads to visit stops or point locations.

Update a record in a feature layer

This action updates an existing record in a feature layer.

Create a record in a feature layer

This action adds a new record to a feature layer.

Parameters

Name Key Required Type Description
Layers in
contentFilter True string

When you sign in using your ArcGIS account, you can search for content in your organization, your organization's groups, or public content.

Feature layer
userLayer True string

Select a feature layer from your ArcGIS content

data
data True dynamic

Returns

Name Path Type Description
Create operation success status
success boolean

Create status

Object ID
objectId number

Object ID of the record created

Global ID
globalId string

Global ID of the record created

Create feature layer

Create a feature layer in ArcGIS using data from an existing source, such as a SharePoint list. A feature layer is a grouping of similar geographic features, for example, buildings, parcels, cities, roads, and earthquake epicenters. Features can be points, lines, or polygons (areas). Feature layers are most appropriate for visualizing data on top of a basemap.

Parameters

Name Key Required Type Description
Title
layerTitle True string

Title of the new feature layer

Location type
locationType string

Type of location information in the columns

body
body True dynamic

Returns

Name Path Type Description
Service item ID
serviceItemId string

Service item ID

Service URL
serviceurl string

Service URL

Service type
type string

Service type created

Location type
locationType string

Location type used to match location

Delete a record from feature layer

This action deletes one or many records from a feature layer using IDs.

Parameters

Name Key Required Type Description
Layers in
contentFilter True string

When you sign in using your ArcGIS account, you can search for content in your organization, your organization's groups, or public content.

Feature layer
userLayer True string

Select a feature layer from your ArcGIS content

Unique ID field
idField True string

Select a unique ID field in the feature layer

Delete records
deletedIds string

A list or single value of IDs used to identify the deleted items. The IDs provided must match the IDs used in the feature layer. Multiple IDs can be added and separated by a comma.

Returns

Name Path Type Description
array of object
Delete status
success boolean

Delete operation success status

Object ID
objectId number

Object ID of the record deleted

Global ID
globalId string

Global ID of the deleted record

Fetch updates, changes, or deletions from feature layer

Fetch the updates, changes, or deletions that were made to your selected feature layer. This action is used in conjunction with the trigger on your feature service.

Parameters

Name Key Required Type Description
Get changes from
changesUrl True string

Select the Changes URL option from the Dynamic content pane.

Feature layer
userLayer True string

Name of the feature layer that was changed, updated, or deleted.

Feature layer ID
layerId True number

Select the Feature layer ID option from the Dynamic content pane.

Returns

The outputs of this operation are dynamic.

Find address candidate

Locate a single address using a geocode service resource. This resource provides information about candidates, including the address, location, and match score. The result of this operation is a list of address candidates.

Parameters

Name Key Required Type Description
Store results?
forStorage True boolean

Specifies whether the results of the operation will be persisted.

Address
address string

Address

Region
region string

Region

City
city string

City

ZIP or postal code
postal string

ZIP or postal code

Country
country string

Select a country

Match type
locationType string

Specifies whether to use rooftop or street entrance location for the geometry output

Spatial reference system
srs string

Select spatial reference system

Returns

Name Path Type Description
Full address
address string

The locations of your data listed either as single line or multi-line results

Country code
countryCode string

The country where the locations are based

City
city string

The city where the locations are based

Longitude (X)
Geometry.x number

Longitude (X)

Latitude (Y)
Geometry.y number

Latitude (Y)

Geocode addresses

Find multiple (batch) addresses, place-names, and businesses and then display that information on a map. This data can be added to an existing dataset or you can create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.

Parameters

Name Key Required Type Description
Addresses
addresses True string

Array of addresses with well formed fields

Returns

Name Path Type Description
Spatial reference ID
spatialReference.wkid number

Well-known ID

locations
locations array of object

Array of geocoded locations

Address
locations.address string

Full address

Address ID
locations.attributes.ResultID number

This value contains the ID of your geocoding request. Use this value for specifying the item to act on in other actions such as matching Ids in a list.

Longitude (X)
locations.location.x number
Latitude (Y)
locations.location.y number

Geoenrichment

Get facts about a location or area. Using the GeoEnrichment service, you can get information about the people, places, and businesses in a specific area or within a certain distance or drive time from a location.

Parameters

Name Key Required Type Description
Study area
studyarea True string

Address or geometry

Country
country True string

Select a country to see available data collections

Data collection
datacollection True string

Select a data collection

Variable
parameter True string

Select a variable from the collection

Buffer type
areatype string

Type of buffer around the location

query
query dynamic
Spatial reference system
srs string

Select spatial reference system

Returns

Name Path Type Description
Value of the variable
value number

Geoenrichment variable value

Name of the variable
parameterName string

The name of the variable that is being analyzed during the geoenrichment process.

Units
units string

Parameter units

Get data from feature layer

Connect to a feature layer in ArcGIS and pull its data and attributes into your existing dataset or create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.

Parameters

Name Key Required Type Description
Layers in
contentFilter True string

When you sign in using your ArcGIS account, you can search for content in your organization, your organization's groups, or public content.

Feature layer
userLayer True string

Select a feature layer from your ArcGIS content

Available fields
field string

Select an attribute from the ArcGIS feature layer

Comparison type
comparison string

Search for values using a comparison operator such as "equal to" or "greater than"

Output format
format True string

Select return format type

Search parameter value
parameter string

Enter a value to search

Starting count
offset number

When batching, this value is the starting point of the query

Where
where string

Input a WHERE clause to filter records in your search

Return geometry
returnGeometry boolean

Return geometry

Returns

The outputs of this operation are dynamic.

Get geometry from feature layer

Get geometry or boundary information from a feature layer and export it as Esri JSON or to a shape column in your dataset. This data can be used in all ArcGIS for Microsoft 365 products.

Parameters

Name Key Required Type Description
Country
searchterm True string

Select a country to see available data collections

Feature layer
layer True string

Select a feature layer

Field
field True string

Select a field

Search parameter
parameter True string

Enter the search parameter

Geometry output format
f string

Geometry output format

Second Field
field2 string

Select a field

Second search parameter
parameter2 string

Enter the second search parameter

Returns

Name Path Type Description
Geometry object
data object

Geometry object as a JSON string

Point to point routing

Create point-to-point routes. Points in a route can visited in the order you specify or in the order that minimizes overall travel time or distance. Routes represent the quickest or shortest path along roads to visit stops or point locations.

Parameters

Name Key Required Type Description
Routing stops
stops True string

Stops as Latitude (Y) and Longitude (X), features, or feature service

Travel mode
travelModeName string

Choose the mode of transportation for the analysis

Find best route
findBestSequence boolean

Specify whether the service should reorder stops to find the optimized route

Preserve first stop
preserveFirstStop boolean

Indicate whether the service should keep the first stop fixed when reordering the stops

Return directions
returnDirections boolean

Specify whether the service should generate driving directions for each route

Returns

Name Path Type Description
Directions
Directions array of object
Direction text
Directions.text string
Name
Name string

Name of the route

Distance in kilometers
Kilometers number

Route distance in kilometers

Distance in miles
Miles number

Route distance in miles

Travel time
TravelTime number

Estimated travel time in minutes

Route geometry
Geometry object

Geometry object of the route

Update a record in a feature layer

This action updates an existing record in a feature layer.

Parameters

Name Key Required Type Description
Layers in
contentFilter True string

When you sign in using your ArcGIS account, you can search for content in your organization, your organization's groups, or public content.

Feature layer
userLayer True string

Select a feature layer from your ArcGIS content

Unique ID field
idField True string

Select a unique ID field in the feature layer

data
data True dynamic

Returns

Name Path Type Description
Update operation success status
success boolean

Update status

Object ID
objectId number

Object ID of the record updated

Global ID
globalId string

Global ID of the updated record

Triggers

When a record is created in a feature layer

This action triggers a flow when a record is created in your feature layer.

When a record is deleted from a feature layer

This action triggers a flow when a record is deleted in a feature layer.

When a record is updated in a feature layer

This action triggers a flow when a record is updated in a feature layer.

When a record is created in a feature layer

This action triggers a flow when a record is created in your feature layer.

Parameters

Name Key Required Type Description
Feature layer
userLayer True string

Feature layers owned by the user that have changes tracking enabled.

Returns

Name Path Type Description
array of object
Feature layer ID
layerId number

The unique layer ID for the feature layer.

Changes URL
changesUrl string

The URL of the feature service where you are listening for changes.

When a record is deleted from a feature layer

This action triggers a flow when a record is deleted in a feature layer.

Parameters

Name Key Required Type Description
Feature layer
userLayer True string

Feature layers owned by the current user. Layers listed here have the "track changes" option enabled.

Returns

Name Path Type Description
array of object
Feature layer ID
layerId number

The unique layer ID for the feature layer.

Changes URL
changesUrl string

The URL of the feature service where you are listening for changes.

When a record is updated in a feature layer

This action triggers a flow when a record is updated in a feature layer.

Parameters

Name Key Required Type Description
Feature layer
userLayer True string

Feature layers owned by the current user. Layers listed here have the "track changes" option enabled.

Returns

Name Path Type Description
array of object
Feature layer ID
layerId number

The unique layer ID for the feature layer.

Changes URL
changesUrl string

The URL of the feature service where you are listening for changes.