Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Users Table Vs Microsoft Entra ID Table

(0) ShareShare
ReportReport
Posted on by 930 Super User 2025 Season 1

Hello everyone,

The Users table in Dataverse only syncs licensed users. Working with Users table lookups does not show all available users of the company.

We have a table with a lot of Users/Lookup fields, and the only workaround we found is to replace all Users lookups with MS Entra ID Lookups.

Is there a simple way to sync all non-licensed users in the Users table? If not,

Are there any limitations with the Entra ID table? I know that two years ago, the AAD User was not available for Power Automate and threw errors when trying to update a lookup field in a custom table.

After testing, it's not the case anymore.

 

Do you know of other limitations that I should consider before recreating all lookups? FYI, I have more than 20 Users fields in my table.

 

 

 

abouchaalaBAIT_0-1716363461067.png

Announcing the AAD User Virtual Table – Find and add any AAD user to your records. | Microsoft Power Apps

Categories:
  • mjburley Profile Picture
    370 on at
    Re: Users Table Vs Microsoft Entra ID Table

    I assigned every user in the tenancy the license:

    Microsoft Power Automate Free

     

    which is an odd license as it does not do much (Approvals I think is about all), except it adds them to DataVerse.

     

    This is how I get all tenancy users into the DataVerse support app.

  • Shashank Bhide Profile Picture
    936 Super User 2025 Season 1 on at
    Re: Users Table Vs Microsoft Entra ID Table

    You can use the below graph endpoint. 

     

    https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http

     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics