web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : a0+cfy6KvVKvNCmaWl2B6F
Power Automate - Using Connectors
Unanswered

Accessing Dataverse REST API using HTTP action

Like (0) ShareShare
ReportReport
Posted on 3 Nov 2023 10:54:58 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

I have the same question (0)
  • GdarmonAbra Profile Picture
    77 on 05 Nov 2023 at 08:26:24
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics