AAD User Table - Cannot Search

[GaryBelcourt]

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.

[RameshMukka]

@melamri is the best one to answer.

[melamri]

Hi, 

Please refer to my blog: https://xrmtricks.com/2022/06/23/model-driven-apps-virtual-tables-how-to-resolve-the-aad-users-looku...

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

Please tick Accept as solution if the answer is useful.

https://xrmtricks.com/

[CDFS]

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.?

[BAJ]

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