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 :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Lookup Column to get u...
Power Apps - Microsoft Dataverse
Answered

Lookup Column to get users in Entra

(0) ShareShare
ReportReport
Posted on by Hilda Steyn 265
I have a model driven app with tables in Dataverse.
I want to add a lookup column in one table, that will retrieve the employees from Entra.
How is this done? I tried a lookup to the OOB table Users, but that doesn't give me what I need. 
I tried using a lookup to a table called Microsoft Entra ID - that works, but it lists everybody. It would be ideal to be able to either filter to a certain Entra team, or, have a lookup to a team on power platform.
 
 
 
Categories:
Microsoft Dataverse
I have the same question (0)
  • Verified answer
    ankit_singhal Profile Picture
    ankit_singhal 584 Super User 2025 Season 2 on at
    Lookup Column to get users in Entra
    this is not gibberish, those and microsoft users in dataverse. you can change view of your lookup field or apply filter in existing view. You can show only those user who dont contain @microosft.com in email address and some other filters accordingly.
     
    Note: please mark verified, if it is useful for you 
  • Hilda Steyn Profile Picture
    Hilda Steyn 265 on at
    Lookup Column to get users in Entra
    I tried to add a column with a lookup to the user table, but I get gibberish like:
  • Suggested answer
    ankit_singhal Profile Picture
    ankit_singhal 584 Super User 2025 Season 2 on at
    Lookup Column to get users in Entra
    User table contain user who have access on Dataverse. If you want to show users from entra ID then you need to create custom entity and you can use Power automate to fetch data from Entra and store in dataverse. Use graph api to get data from entra in power automate. 
     
    Note: please mark verified, if it is useful for you 

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

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 977 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 426

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 276 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans