AAD User Table | Query per Odata or Dataverse Connector PBI

(1) Share

Report

Posted on by P3Sven

119

Hi lovely community,

just wondering why I can't query dataverse table "AAD User".

Have sys admin role and can read all records "directly" via make.powerapps.com, but why not via API?

Is there another way to get all users of AAD User table or other?

I need all users incl. "company name" column? (unfortunately its not included in systemuser table)

BR,

Sven

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @P3Sven ,

The systemuser table is the table in Dataverse with users. I don't know of the AAD User table in Dataverse, the AAD user is is Azure Active Directory and I would expect you should utilize something like Power Automate to pull this information from AAD and augment as needed to the systemusers table in Dataverse.

An example of a flow that is doing something similar: https://2die4it.com/2020/09/02/get-set-manager-of-cds-d365-users-with-power-automate-flow/

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @P3Sven,

The issue with the Odata query you're trying is that your not authenticated. You'll need to pass the auth token somehow but I'm not sure how to with the Odata.Feed function. Even though your a system admin in Dataverse, AAD is another system/platform which required different privileges.

There is another way with the Office 365 User connector which will be simpler. Here's an example

More info: https://docs.microsoft.com/powerapps/maker/canvas-apps/connections/connection-office365-users?WT.mc_id=DX-MVP-5004271

Hope this helps!

Was this reply helpful? Yes No
P3Sven 119 on at

Like (0)

Report

Hi @dpoggemann , Hi @EricRegnier ,

thanks for your replies!
Also have wondered about AAD User Table but yes, I also guess it's another system with other authorization method.

I need to query all users incl. company name. I will create a new company name column in systemuser table and will update it with power automate via Office 365 connector..

Thank you!

BR,
Sven

Was this reply helpful? Yes No
Verified answer

Nhelgren on at

Like (3)

Report

We have just released the new AAD User virtual table. I'd based in Graph and uses OBO auth. With it you are able to retrieve AAD user data through the virtual table. Check out my recent post on it.

New table in Dataverse - AADUser - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
RakeshPower 14 on at

Like (0)

Report

Hi @NHelgren , we have started using AAD User Table in Model Driven APP. However, since our tenant has >100K users, the loading part in drop-down search is slow and very much evident to end user and impacting the user experience.

Is there a way to use some filters/search in this lookup column to avoid delays? are there any known issues in context to number of users in tenant on its performance. Thanks in advance.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (2)

Report

Hi @RakeshPower, you can create custom views on AAD User and bind the lookups in your model driven app to those views. Cheers

Was this reply helpful? Yes No