AADUser Lookup

(0) Share

Report

Posted on by TonyHoll

I am using AADUser table as a Lookup column in another table but experiencing problems.

- The primary name in AADUser is not unique

- The records in AADUser include records for disabled accounts

Any suggestions as to how I can achieve an accurate user lookup? Many thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (2)

v-jefferni on at

Like (0)

Report
Copy link

Link copied!

Hi @TonyHoll ,

The below two columns in AAD User table should be useful for you to get an enabled unique user:

Best regards,

Was this reply helpful? Yes No
rfainter123 76 on at

Like (0)

Report
Copy link

Link copied!
You will want to change the lookup view to filter out the disabled accounts.
Go to make.powerapps.com and select the correct environment
Select Tables, then find AAD User
Select Views, then locate the AAD User Lookup View

Next, change the filter by clicking Edit filters in the right pane:

Add a row to your filter and make it look like this:

Then Save and publish the view. Now only enabled accounts will show in the lookup

Was this reply helpful? Yes No
TonyHoll 19 on at

Like (0)

Report
Copy link

Link copied!

Hi rfainter123
Thank you for your reply. I understood that the filter would not work as AADUser is a virtual table. In my tests, after publishing the lookup view with the filter, I still see both enabled and not enabled. My test is sing the lookup in a Table, Edit row. Is this a vild test. Be very grateful if you would confirm. Thanks

Was this reply helpful? Yes No
rfainter123 76 on at

Like (0)

Report
Copy link

Link copied!
Hi TonyHoll,
Your test does seem valid and just to be sure, I recreated it. Here I created the lookup on the User table, and filtered the lookup view of AAD Users to show only those whose first name is Yosef. As you can see, the lookup is only showing two records:
To troubleshoot, did you:
Publish the lookup view?
Select the lookup view in the related table's form?

Was this reply helpful? Yes No
TonyHoll 19 on at

Like (0)

Report
Copy link

Link copied!

Thanks for staying with me on this one rfainter123. I am new to Power Apps / Dataverse. I have published the lookup and other views with the filter set. My test though was as follows...
Tables >> select table >> Open >> in 'columns and data' search in the lookup column. This is where I see both enabled/not enabled. Is this test valid and which view will be used for the lookup. Really appreciate your ongoing help.

Was this reply helpful? Yes No
Verified answer

rfainter123 76 on at

Like (0)

Report
Copy link

Link copied!

Of course, happy to help! If I'm understanding correctly, you are viewing that lookup here:
If that's the case, then yes, you will not see the filtered lookup view, as those are configurable for forms in the UI. If you're trying to filter for users, then you would do that in the form editor. So from this page, select the main form that goes with the related table you're working with. In the form editor, add the lookup column into the form, then select the lookup view you modified. Save and publish and you should be good to go!

If you're working with a different use case, kindly provide some more details so I better understand.

Was this reply helpful? Yes No
Verified answer

TonyHoll 19 on at

Like (0)

Report
Copy link

Link copied!

Hi rfainter123
Thank you so much for your clear explanation and for staying with me on this. I now understand that the Table, Edit option does not use the lookup view and that this has to be achieved through a Form. So grateful for your patience. Best regards.

Was this reply helpful? Yes No
rfainter123 76 on at

Like (0)

Report
Copy link

Link copied!

@TonyHoll you bet! Good luck 😀

Was this reply helpful? Yes No