A dropdown with list of Employee's name with search filter

(0) Share

Report

Posted on by lliu_western

289

Hi Community,

I have a dropdown list that contains all employees' name from D365 Users' list with this following formula:

Office365Users.SearchUser({searchTerm:""}).DisplayName

However, since there is a limit in the drop down and the available employees are way more than that's being displayed. I would like to add a search function into the above formula.

So there will be an input box for users' to start typing names, then the dropdown will filter (and search) in the D365 Users list for that name.

Any help on altering the above formula will be great, thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lliu_western ,

Yes, dropdown / combobox can't handle that many users so assign the same filter to a gallery and make use of that gallery.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi@lliu_western,
Based on the issue that you mentioned, do you want to entry in the TextInput and search/filter in the Dropdown?
Actually, Combo Box is a better choice for the Dropdown can’t search within. I have a test on my side, please take a try as below.
Connect to Office365, add a TextInput and a Combo Box.
Set the Items property of the Combo Box as below
Office365Users.SearchUser({searchTerm:TextInput1.Text})

Best Regards,
Qi

Was this reply helpful? Yes No
lliu_western 289 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. Yes, I have figured it out with this solution as well, using combo box with an input box for filter.

Was this reply helpful? Yes No
Power5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

My drop down populates with values instead of employee names. How can I change that?

Was this reply helpful? Yes No