Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

AAD User Table - Cannot Search

I'm currently developing a model driven app and am relying on the AAD User table in a many-to-many relationship fashion.


The AAD User, when I browse it manually, appears to have the correct entities. However, when I run the model driven app and open up the field for AAD User, search appears to be broken. I've spent almost a week with different search values etc to try to get anything to work, but it always just displays the same list. Even if I search for a user currently being displayed; same list.


Any ideas on how to resolve this? The fact it's so broken is really slowing me down. Advanced lookup as the same results.



@melamri is the best one to answer.



Please refer to my blog:


You can use this workaround before Microsoft's fix, good luck !


Please tick Accept as solution if the answer is useful.

Frequent Visitor

Did Microsoft fix this? I am having tremendous problems using related columns as reference on my view forms. Whenever I add a related column from the AAD user table, all my data disappears.

Have anyone an idea of how to fix this, so I can start looking up e.g. Job Title etc.?

I am not sure sorry, I only needed the users UPN and found alternate methods.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,795)