Microsoft Power Automate Integration

Last Updated On

Availability: since Release 2.8.0

Microsoft Power Automate is a service that helps you create automated workflows across different applications, including Microsoft Dynamics, SharePoint, Office365, OneDrive, Atlassian Jira, and thoursands of other applications and services. You can use the BiG EVAL Connector for Power Automate to trigger automated workflows depending on your data validation outcome or events.

Examples are:

  • Creating Outlook or Asana tasks for data stewards to fix erroneous data.
  • Feeding data quality information to an AI model.
  • Posting a message to Microsoft Teams or Slack.
  • Writing data quality information to a Google Sheet, an Excel file or even a relational database.
  • Creating a ticket in Atlassian Jira.
  • Enriching CRM contacts with data quality seals.

Connecting Power Automate to BiG EVAL

Prerequisites

  • Expose the REST API of BiG EVAL to the public internet by following our guidelines to ensure the most secure implementation.
  • Setup a Microsoft Power Automate Account.

Step 1 – Setup an API Client

Add an API Client dedicated to Microsoft Power Automate to your BiG EVAL and give it the needed permissions.

  1. Open System -> Usermanagement in BiG EVAL.
  2. Activate the Register “API Clients”.
  3. Add a new API Client using the following settings:
    • Name: any name you want (e.g. Power Automate Client).
    • OAuth2 Flow: authorization_code
    • Access Token Lifetime: 30 days (or any other value)
    • Client Redirect URI’s: Add the following two URL’s (one line for each)
      • https://global.consent.azure-apim.net/redirect
      • https://global-test.consent.azure-apim.net/redirect
  4. Make note of the Client ID and Client Secret

Step 2 – Setup a Connection in Power Automate

The next step is to setup the connection to your BiG EVAL instance within Microsoft Power Automate.

  1. Goto Microsoft Power Automate on https://powerautomate.microsoft.com and login with your login credentials.
  2. Open Data -> Connections in the main navigation.
  3. Add a new Connection by clicking on + New Connection.
  4. Search for “BiG EVAL” and click on it. A dialog for configuring the connection appears.
  5. Enter the URL of your BiG EVAL instance. e.g. https://bigeval.mycompany.com
    Important: Do not add the trailing slash / at the end of the URL.
  6. Enter the Client ID and Client Secret of your API Client configured in Step 1.
  7. Click on “Create”.
  8. A Popup opens that asks for your consent abou that connection. You need to approve the access to BiG EVAL resources by clicking on “Yes, Allow”.

Building the first Power Automate Flow

This is how to create your first Power Automate Flow that starts automatically if a specific event happens within BiG EVAL. Then, this example flow sends an email to a recipient you specify.

  1. Goto Microsoft Power Automate on https://powerautomate.microsoft.com and login with your login credentials.
  2. Create a new flow by clicking on + Create in the main navigation on the left side.
  3. Select “Automated Cloud Flow”. The wizard for creating a new flow opens.
  4. Enter a name and a description for the flow.
  5. Click on “Skip”. We use the designer to add the trigger instead of the wizard.
  6. Search for “BiG EVAL” and click the BiG EVAL connector.
  7. Choose “Watch Alert” as the trigger of the flow.
  8. Because we already set up the connection in Power Automate in Step 2 of the previous chapter, the BiG EVAL connection automatically uses this connection.
  9. Select the alert template that best fits the event trigger you intend to use. e.g. testsuite-failed if you want to start the flow when a testsuite fails.
  10. Click on + New step to add the action that you intend to run when a testsuite fails (in this example).
  11. Search for “Mail”; click on it and add the “Send an email notification (V3)” action.
  12. Enter your email-address in the “To” field.
  13. Enter “Testsuite failed ” into the subject field and search for “Suite Name” in the “dynamic content” popup on the right side; click on “Suite Name”.
    The dynamic content comes from the trigger respectively the event that triggered your flow.
  14. Enter any text into the body of your email and maybe add some information from the “dynamic content” popup.
  15. Click “Save” below your email-action.

Microsoft Power Automate saves your flow and automatically creates an integration within BiG EVAL (Menu System -> Integrations).

Review that integration and refine the filter to ensure that the flow gets fired only when the right events happen. In our example we have to choose the suite that must fail to trigger the flow. You can also remove that filter to trigger the flow if any of your suites fails.

Finally you may run a suite that fails and watch how the flow in Power Automate gets triggered. You will receive the email set up within that flow into your inbox.

Experiment with other actions available in Power Automate to possibly create a new ticket in Jira or posting a message to Microsoft Teams or Slack. Everything is possible.

Also experiment with the dynamic content.

Table of Contents