Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Filter combobox in the search event

Posted on 22 Nov 2024 06:08:08 by
Hi All 
 
I have a list of establishments that contain 350 000 rows. The list is stored on a power bi dataset.
 
in my case i want the possibility to select an establishment over the 350 000 rows. 
I've created a combobox based on the establishment list and i've activated the search possibility on that combobox. 
 
It work but it's very slow because he's trying to get over 350 000 rows. 
 
i've activated the search option on the combobox properties.
Now i'm trying to filter the combobox with a TOP50 of establishment that match with the text that the user is writting on the combobox search box. 
 
In the combobox properties, there's "On Select" and "On Change" properties but it's not the event i'm looking for. 
 
I would like to execute a TOP 50 filter request during the search moment. For exemple, when the user is writting text on the search box of the combobox, i want to request the dataset with a top 50 of the establishment that match with the text.
 
Is it possible to do that ? 
 
Many thanks for your help. 
 
best regards
 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,081

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard