Replicate features, attributes and attachments from one hosted line feature layer to another in ArcGIS Enterprise using Microsoft Power Automate

Summary

In ArcGIS Enterprise, Microsoft Power Automate can be used to automatically replicate edits made to a hosted Line feature layer including new records, and file attachments to a second hosted Line feature layer. This automation eliminates the need for manual duplication and ensures both layers remain in sync in real time. 

Procedure

Pre-requisites:

• An externally accessible ArcGIS Enterprise environment
• Microsoft Power Automate with a premium license

Create an automated cloud flow using the ArcGIS Enterprise connector:

1. Open Microsoft Power Automate and click My Flows.
2. In the My flows page, click New flow. Under Build your own from blank, select Automated cloud flow. 
3. In the Build an automated cloud flow window specify the Flow name. 
4. In Build an automated cloud flow, under Choose your flow trigger, type ArcGIS Enterprise connector, and within that select the When a record is created in a feature layer action to add it to the flow.

Add a condition to the connector:

1. Once added, click the When a record is created in a feature layer panel to open its pane. 
2. In the When a record is created in a feature layer pane, on the Parameters tab, under Feature layer, click the drop-down menu and select the primary layer in which the edits will be performed. In this example, line_1 is selected.

3. Click New Step button to open the Add an action pane. 
4. In the Add an action pane, in the search bar, type ArcGIS Enterprise connector and select the action of Fetch updates, changes, or deletions from feature layer.
5. Click the Fetch updates, changes, or deletions from feature layer pane, on the Parameters tab, configure the parameters:
   1. Under the Feature layer, select the same hosted layer as selected in Step 2 from the drop-down menu.  
   2. In Get Changes from parameter, click on the dynamic content and select the Changes URL from the When a record is created in a feature layer trigger option.
   3. Under Advanced parameters, keep Features created, Features updated, Features deleted and Return attachments as True.

6. Below Fetch updates, changes, or deletions from feature layer, click the next step button to open the action page and search for Initialize variable and add it to the flow. Click the Initialize variable action to open its Parameters tab and configure the below parameters:
   1. Under Name, add any unique name for the variable to initialize. In this example, testlineobjectid is added.
   2. Under Type, click on the drop-down menu and select Integer.

7. Below Initialize variable panel, click the next step button to open the action page and search for Compose. In the Parameters tab, configure the below parameters:
   • In the Inputs parameter, click on the Dynamic Content and select Geometry. available under Fetch updates, changes, or deletions from feature layer action.

8. Below Compose, click the next step button to open the action page and search for Create a record in a feature layer and add it to the flow. In its Parameters tab, configure the below parameters:
   1. Under the Layers in parameter, My Content is automatically selected.
   2. Under Feature layer, click the drop-down menu and select the layer where you want to replicate the edits. In this example, line_2 is selected.
   3. In the Geometry, click on Dynamic Content and under Compose action, and select Outputs.
   4. In the Advanced properties, the “field name” of the layer 2 will be there, click on the Dynamic Content and search for the field name that has similar properties to this field from the original layer, i.e., layer 1. This will be available for selection under the Fetch updates, changes, or deletions from feature layer action. This is used to map the attribute values from the fields in layer 1 to layer 2.

9. Below Create a record in a feature layer panel, click the next step button to open the action page and search for Compose. In the Parameters tab, configure the below parameters:
   • In the Inputs parameter, click on the Dynamic Content and select Object ID. available under Create a record in a feature layer action. This Object ID details will be used to store the attachments in the layer 2.

10. Below the Compose 1 panel, click the next step button to open the action page and search for Set variable. In the Parameters tab, configure the below parameters:
    1. In the Name parameter, click the drop-down menu and select the name you selected as a unique identifier in the Initialize variable panel. In this example, we selected testlineobjectid.
    2. In the Value parameter, click on the Dynamic Content and select the Outputs option available under the Compose 1 action.

11. Below the Set variable panel, click the next step button to open the action page and search for “ArcGIS Enterprise connector” and select the Get attachment from URL action. In the Parameters tab, configure the below parameters
    • In the Attachment Url parameter, click on the dynamic content and select the Attachment Url option available under the Under Fetch updates, changes, or deletions from feature layer action.

12. Below the Get attachment from Url panel, click the next step button to open the action page and search for “ArcGIS Enterprise connector” and select the Add attachment action. In the Parameters tab, configure the below parameters:
    1. Under Layers in, My Content is automatically selected.
    2. Under Feature layer, click the drop-down menu and select the layer where you want to replicate the attachments. In this example, “line_2” is selected.
    3. In the Record ID parameter, from the dynamic content, select the testlineobjectid option available under the Set variable parameter.
    4. In the Attachment name, click on the Dynamic Content and select the Attachment name option available under the Fetch updates, changes, or deletions from feature layer action.
    5. In the File content, click on the Dynamic Content and select the Attachment content option available under the Get attachment from URL action.

13. Save and run the flow to automate replication of the feature geometries, attributes and attachments from one hosted line layer to another hosted line layer.