How to – use HTTP Action to call DataVerse / Dynamics 365 Web API in Power Automate

Let us take a simple example, to see the steps involved.

Here we will be manually triggering a flow, getting the token, and calling the WhoAmI request in Microsoft Dataverse / Dynamics 365.

This is how our final Flow looks like.

Inside the first HTTP action, we are calling OAuth 2.0 token endpoint v1. We have MyCrmApp registered in Azure AD and have generated the client secret for it.

Also we have created an Application User using the above application details and have given the appropriate security role.

Below is how our HTTP request looks like.

Next, we have added the Compose action to get the token from the output of the HTTP request.

Inputs (Expression) = outputs(‘HTTP’).body.access_token

Next, we have added the HTTP action again to calls the WhoAmI request using the above token.

On triggering our Flow succeeds as shown below.

The output of the first HTTP request.

Compose step has the access token

And the final step has the result of the HTTP Get request to WhoAmI

The helpful post –

https://carinaclaesson.com/2019/11/24/using-power-automate-to-trigger-on-create-or-update-in-the-cds-and-make-http-requests-with-oauth-2-0-authentication/

https://sharepointmadeeasy.blogspot.com/2018/02/microsoft-flow-http-rest-api-invalid.html

Hope it helps..

Check other posts on Power Automate –

Flow Error – It hasn’t been triggered successfully in the last 28 days (Power Automate / Dataverse)

by Nishant Rana

Use Filter Array action to remove values from an array variable – Power Automate

by Nishant Rana

Fix the trigger – Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types ‘Edm.Guid’ and ‘Edm.String’ for operator kind ‘Equal’ (Power Automate / Dataverse)

by Nishant Rana

Versioning and Drafts for Solution-based Cloud Flows – Power Automate

by Nishant Rana

What will happen on changing the password of the user account used as the Owner of Cloud Flow and for Connection – Power Automate

by Nishant Rana

Using Union function to remove duplicates – Power Automate / Dataverse

by Nishant Rana

Fixed- The XRM workflow table row could not be found error (Power Automate)

by Nishant Rana

The ‘operationOptions’ property is not allowed on the trigger when the workflow contains actions of type ‘OpenApiConnection- Power Automate

by Nishant Rana

Force Sync users from Azure AD Security Group / Microsoft 365 Group to Dataverse environment – Power Automate

by Nishant Rana

Fixed – Invalid type. Expected Integer but got Number (Power Automate)

by Nishant Rana

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology ! View all posts by Nishant Rana