Filter Combobox lookup

[jesslynh]

I have two tables.  One is a custom table that has a Username lookup to the AADUser table in Dataverse.

In the gallery that I'm showing to the users, I'd like them to be able to search for a user's item, but only for users that already have records in the list. I don't want to include every user in the AAD User table.

I cannot seem to get a formula that filters my combobox.

Note the combobox is not multi-select. Any and all help appreciated.

[dpoggemann · Accepted solution]

Hi @jesslynh 

I just did a test on this and setup the 'AAD User' column on my Device Orders table.  I then populated the rows so I had duplicate AAD User values in multiple rows to verify I can get the unique list.

I then created a Power App that has a Button that will do the following:

ClearCollect(users,Distinct('Device Orders','AAD User'.'Display Name'))

and I then had a drop down box that displays the following:

users.Result

This worked for me to display the unique list of the AAD Users from the Device Orders table.