Filtering Searchable items in a combobox

(0) Share

Report

Posted on by MJ84

263

Hi all,

I have the below in a combobox Items property to pull user data from AD I am then using the distinct function to remove duplicate displaynames and filtering on the company name to only include certain companies......... This works fine with the Filter but as soon as I add the distinct function it breaks.... Any pointers would be welcome!

Filter(Distinct(Office365Users.SearchUser({searchTerm:ComboBox1.SearchText}),DisplayName),"Company1" in CompanyName Or "Company2" in CompanyName)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

MJ84 263 on at

Like
a
(0)

Report
Copy link

Link copied!

just realised my error should be
Distinct(Filter(Office365Users.SearchUser({searchTerm:ComboBox1.SearchText}),"company1" in CompanyName Or "company2" in CompanyName),DisplayName)
Verified answer

LimeLeaf 278 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MJ84,

ya this i exactly what i was thinking about.
Don't filter the distinct selection - use distinct on the filtered result.

Does it work?
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

When you use Distinct it created a table with single column with "Result" as header. In that table you are searching for company. Which is not available. So i think @MJ84 's code will work for you