Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

AD Users Missing from Users Table When Creating Lookup Field

I'm building a model app. I created a field called Manager that is a lookup to the Users table. However, not all of my users in AD are in the Users table.


What is the best way to create a lookup field so users can select from the entire Azure AD of users?

Responsive Resident
Responsive Resident

Hi @chiguypaul ,


You need to assign a temporary Dynamics CRM license to users in Office 365 admin portal and than once users are synchronized in dynamics CRM in User entity than you can remove license to users. I don't think without assigning proper license you would be able to achieve using standard feature.  


Let me know if it works for you.  

There has to be a better way. In SharePoint you can have a person lookup field that leverages the AD directory. There must be something like that in Power Apps. BTW...I'm not using CRM. I'm building a model app on Dataverse.

Responsive Resident
Responsive Resident

Hi @chiguypaul ,


I dont think there is direct way to have a kind of person lookup field as sharepoint in Dataverse. Here is supported types of fields you can create.


As per my opinion , you would need to do some customization to achieve that. You can create a custom entity and create its lookup field on user entity. By using powerAutomate you can add/update records depending on your requirements. 


Hope this helps.




(Please like/resolve if it helps you)


When I open the Users table in my environment I see a number of people in our Azure AD that have never used a model app, canvas app or Dynamics. Does not make sense to me how some users are in the list while others aren't. 

Helper I
Helper I

I am having the same issue. Did you find a work around @chiguypaul 

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,861)