Microsoft Power Automate Collectors

Overview

DataBlend supports users wishing to create flows within Microsoft Power Automate. Power Automate is a unique connector in that the connection is established within Power Automate, and not our “standard” connectors that authenticate directly inside of the DataBlend application. In order to establish the connection within Power Automate, users must first establish a connection and then build an Instant Cloud Flow.

1. Navigate to the Microsoft Power Automate webpage. Power Automate | Microsoft Power Platform

2. Log into Microsoft Power Automate with your Microsoft login information.

3. Navigate to the left side panel and select Data

4. Once in the Data section on the left side panel, select Custom connectors.

5. A DataBlend Connector will be shared with clients wishing to connect to DataBlend via Power Automate.

6. Select the plus button on the DataBlend connection under Actions to create a connection.

7. A window will open presenting users the ability to log into DataBlend.

8. Once a user is signed in, the window will close, and the user will be taken to the Connections page within Power Automate.

9. Here users can ensure that a connection has been made.

Creating an Instant Cloud Flow

1. On the left side panel, select My flows

2. Select the + New flow button

3. Once clicked a drop-down menu will be presented. Select Instant cloud flow under the Build your own from blank section.

4. A window will open asking users to enter a Flow name and asking users to select a trigger under Choose how to trigger a flow. Enter a flow name and select Manually trigger a flow. Then, click the Create button.

5. Users will then be taken to the Create your flow page.

6. Click the + New step button under the Manually trigger a flow step.

Group Search

1. The Choose an operation step will be added. Within the search bar, enter DataBlend and select Group Search under the Actions section.

2. When the Group Search action is selected the step will be added to the flow. Within the Group Search step enter the following configuration and click the Save button.

3. Click the Test icon in the upper right corner. Select Manually under the Test Flow and click Test.

4. Under the Run flow section, ensure that users are signed in to DataBlend. Then click Continue.

5. Under the Run flow section, the user will see the name of the created flow. Click Run flow.

6. Under the next Run flow section, click on the Flow Runs Page link.

7. Users will then be taken to the Run history for the created flow. Click on the most recent test.

8. Users will be taken back to the flow steps. Click Group Search. Scroll down to the Outputs section within Group Search and then select Show raw outputs. Users will then see the groups in which they are Admins or Members. From here users copy the id associated with the group they wish to collect data from

9. Click the Edit icon in the upper right corner. Users will be taken back to the flow page.

Workflows Search

1. Select + New Step. Within the search bar, enter DataBlend and select Workflows Search under the Action section. Within the Workflow Search step enter the following configuration and click the Save button.

3. Click save and then click the Test icon in the right upper corner.

4. Select Manually under the Test Flow and click Test.

5. Under the Run flow section, ensure that users are signed in to DataBlend. Then click Continue.

6. Under the Run flow section, the user will see the name of the created flow. Click Run flow.

7. Under the next Run flow section, click on the Flow Runs Page link.

8. Users will then be taken to the Run history for the created flow. Click on the most recent test.

9. Users will be taken back to the flow steps. Click Workflows Search. Scroll down to the Outputs section within Workflows Search and then select Show raw outputs. Users will then see the groups in which they are Admins or Members. From here users copy the id associated with the group they wish to collect data from.

10. Click Workflow Search. Scroll down to the Outputs section within Group Search and then select Show raw outputs. Users will then see the workflows present in their DataBlend group. From here users copy the id associated with the Workflow they wish to collect data from. (This id can also be collected by going to the desired Workflow within DataBlend and copying the id from the url).

Execute Workflow

1. Click the Edit icon in the upper right corner. Users will be taken back to the flow page.

2. Select + New Step. Within the search bar, enter DataBlend and select Execute Workflow under the Action section. Within the Execute Workflow step enter copied Workflow id.

3. Click save.

Workflows Execution Search

1. Select + New Step. Within the search bar, enter DataBlend and select Workflows Execution Search under the Action section. Within the Workflow Execution Search step enter the following configuration and click the Save button.

2. Click save and then click the Test icon in the right upper corner.

3. Select Manually under the Test Flow and click Test.

Get Query Execution By ID

1. Select + New Step. Within the search bar, enter DataBlend and select Get Query Execution By Id under the Action section. Within the Get Query Execution By Id step enter copied Query Execution id.

2. Click save.

3. Click save and then click the Test icon in the right upper corner.

4. Select Manually under the Test Flow and click Test.

Compose

1. Select + New Step. Within the search bar, enter compose.

2. Using the expression section enter the following:

    

   base64ToString(outputs('Get_Query_Execution_By_Id')?['body']['$content'])

3. Click save.

4. Click save and then click the Test icon in the right upper corner.

5. Select Manually under the Test Flow and click Test.

6. Navigating to the raw output section within the compose set will display users the desired data.