Create Power Automate workflow

This feature allows you to automate the creation of Power Automate workflow that will send the data from Dataverse to CluedIn via ingestion endpoint.

Prerequisites

You’ll need to provide the Dataverse connection ID. To generate the the Dataverse connection ID:

  1. In Power Apps, on the left navigation pane, select Connections.

  2. Select New connection.

  3. In the list that appears, find and select Microsoft Dataverse.

  4. Select Create.

    Create Dataverse Connection Id

  5. Open the Dataverse connection that you’ve just created, and then copy the connection ID in the URL field.

    Create Dataverse Connection Id

To automate the workflow creation

  1. In CluedIn, on the navigation pane, go to Administration > Settings, and then find the PowerApps section.

  2. In Create workflow to Ingest Data to CluedIn, turn on the toggle.

  3. In Dataverse Connection Id, enter the Dataverse connection ID. This connection ID will allow you to access the Power Apps table in the Power Automate workflow.

    Create Power Automate Workflow

Ingestion endpoint

As part of workflow automation, the ingestion endpoint will be created as well. From our sample above, you can expect two ingestion endpoints to be created, one for each of the cluedin_dog and crc12_customer tables.

Power Automate Workflow Ingestion Endpoint

Workflow

The creation of workflow will depend on the values of Sync Entity Types and Sync Dataverse Tables. Once the execution of the job is done, from the sample values above, you can expect two workflows to be created, one for each of the cluedin_dog and crc12_customer tables.

Power Automate Workflows

You can expect to see a notification when the creation is successful.

Power Automate Workflow Notification

The content of the workflow will be composed of a Dataverse event named When a row is added, modified or delete (but mainly focused on Added and Modified) and an HTTP event that pushes the data into CluedIn ingestion endpoint. On the following screenshot, the token has been edited to show the full content of HTTP event.

Power Automate Workflow Content

Auto mapping and procesing

As we already know the structure of the table/vocabulary that we are working on, the system will automate the data mapping and processing. By navigating to the data set page, you can notice that the Map, Prepare, and Process tabs are now available as we already automated the creation of the data mapping into our vocabularies.

Auto Mapping

On the Map tab, you can find the the full view of all columns mapped to our vocabulary, including edges (relationships) and origin entity code (keys), if there are any.

Auto Mapping

On the Preview tab, you can find the data received from Dataverse.

Ingestion Endpoint Preview

Once the data is received, you can expect to see it processed because we have also enabled the Auto submission property of the ingestion endpoint.

Auto Processing