Hi,
I'm building an application where the user has to select our company's business partner. I get the partner list from an API call, but the collection where I save it is extremely large.
So when I have a searchable combobox where the user can search for the business partner, it sometimes freezes the application, because the list is so long.
Is it possible to make the combobox wait for the user to input the first (or first few) letters, before actually searching?
Thanks
Solved! Go to Solution.
If(Len(ComboBox1.SearchText) > 2,Filter(<Filter Query arguments>))
If(Len(ComboBox1.SearchText) > 2,Filter('PartnerList I',StartsWith(PartnerName, ComboBox1.SearchText)))
Hi @jernejp
If(Len(TextInput1.Text) > 2,Filter(<<FIlter Query Arguments>>))
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @yashag2255
So if I understand correctly, I'd then have a text input and a combo box, and would use the text input to filter the combo box?
Can it all be done within the combobox? So that the combobox is empty untill user writes 2 characters, then the filtering query is executed?
Thanks
If(Len(ComboBox1.SearchText) > 2,Filter(<Filter Query arguments>))
Hi @yashag2255, thanks for your answer.
How would I add a StartsWith function here? So if in my PartnerList I have a number of comapnies, and the user inputs "pa", it would search for all partners that begin with PA?
If(Len(ComboBox1.SearchText) > 2,Filter('PartnerList I',StartsWith(PartnerName, ComboBox1.SearchText)))
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
181 | |
52 | |
41 | |
38 | |
33 |
User | Count |
---|---|
245 | |
80 | |
71 | |
69 | |
66 |