How to Connect to Microsoft Dataverse in Power Automate Flow using Service Principal?

Microsoft PowerApps

This article will explain to you the step-by-step process to connect to Microsoft Dataverse in the Power Automate Flow using Service Principal.

Prerequisites

  1. Click on the below article link and create a Microsoft Edge or Google Chrome Profile: Create a Profile in Microsoft Edge and Google Chrome
  2. Click on the below article link to create a Power Apps Trial: Create Microsoft Power Apps 30 days Online Trial Version
  3. Click on the below article link to Register an App in Azure Active Directory: Register an App in Azure Active Directory for Dataverse environment
  4. Click on the below article link to create an Application user in a Dataverse Environment: Create an Application user in the Dataverse Environment

Follow the below steps after the Prerequisites.

Step 1. Click here to Open the Power Apps Maker Portal.

Or

If you are using US GCC Cloud, then follow the below article for the Power Apps Maker Portal URL.

Power Apps US Government service URLs

Power Apps Portal

Step 2. Choose the required Environment.

Required environment

Step 3. Click on Flows and Click on Automated Cloud flow.

Cloud Flow

Step 4. Provide a Flow name and enter text Dataverse in the Choose your flow's trigger.

Trigger

Step 5. Choose When a row is added, modified, or deleted, Dataverse Trigger.

Dataverse Trigger

Step 6. Click on ... in the Trigger and Click on Add new connection.

Add Connections

Step 7. Click on Connect with the service principal.

Service Principal

Step 8. Provide the Connection name, Client ID, Client Secret, and Tenant's data, and Click on Create.

Note. Follow the below article Step 7 to Step 11 to get all the Connection details.

How to Register an App in Azure Active Directory for Dynamics 365 CE Online?

Register

If the Dataverse connection is established successfully, then it will not show any message.

Step 9. Click on ... to see the Dataverse App User connection.

App user

Step 10. Click on More and Click on Connections.

Connections

You can see your Service principal connection here.

Service principal connection

I hope you have successfully connected to the Dataverse Environment in the Power Automate Flow using Service Principal.

Please like and share your valuable feedback on this article.


Similar Articles