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.
Solved! Go to 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.
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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
33 | |
23 | |
22 | |
10 | |
9 |