Lookup Column to get users in Entra

(0) Share

Report

Posted on by Hilda Steyn

289

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 with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

ankit_singhal 618 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hilda Steyn 289 on at

Like (0)

Report
Copy link

Link copied!

I tried to add a column with a lookup to the user table, but I get gibberish like:

Was this reply helpful? Yes No
Verified answer

ankit_singhal 618 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No