Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Connectors
Unanswered

Accessing Dataverse REST API using HTTP action

(0) ShareShare
ReportReport
Posted on by 81

I need to access a table in Dataverse using the Web APIs (as opposed to using the built-in Dataverse actions). 

 

Specifically, I need to execute this HTTP query:

https://<myorgid>.api.crm.dynamics.com/api/data/v9.2/aadusers(00000000-0000-0000-0000-000000000000)

(using some guid from Active Directory)

 

I am confused about two things:

 

How do I configure the HTTP action to authenticate properly?

How do I configure the Azure App registration such that it can read the table?

 

For the HTTP action, I would like to know how to get the value for "Audience" 

jrossstocholm_0-1699008404935.png

 

For the Azure App Registration I have looked at this tutorial, but I still get a 401-error when sending the request to the Web API.

jrossstocholm_1-1699008701881.png

Finally, I have created an app user with the app registration above and added the security role "System Administrator" to it.

 

If anyone can assist me with this, it would be creatly appreciated 😊.

 

Thanks

/Jesper

  • GdarmonAbra Profile Picture
    77 on at
    Re: Accessing Dataverse REST API using HTTP action

    Hi,

     

    try fist connecting to https://<myorgid>.api.crm.dynamics.com/api/data/v9.2/

     

    audience should be - https://<myorgid>.api.crm.dynamics.com

     

    as documented at Announcing the AAD User Virtual Table &#8211; Find and add any AAD user to your records. | Microsoft... unfortunately, at this time, AAD User is not currently available for Automate. This is planned for a future release.

     

    API information for the AAD User table can be found here.

     

    br,

    Gill

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics