Answered

Filter a collection with 5k rows in dropdown based on a text search box

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello there!

I am trying to filter a collection with 5k rows in a dropdown based on a text search box. I have a formula that places all rows into a collection like this;

Concurrent(
 ClearCollect(col1; Filter(EindproductenBevMateriaal; UniekID >= 1 && UniekID <= 2000));
 ClearCollect(col2; Filter(EindproductenBevMateriaal; UniekID >= 2001 && UniekID <= 4000));
 ClearCollect(col3; Filter(EindproductenBevMateriaal; UniekID >= 4001 && UniekID <= 6000));
 ClearCollect(col4; Filter(EindproductenBevMateriaal; UniekID >= 6001 && UniekID <= 8000));
 ClearCollect(col5; Filter(EindproductenBevMateriaal; UniekID >= 8001 && UniekID <= 10000))
);;
ClearCollect(colCombined; col1; col2; col3; col4; col5);;

So I have a dropdown and a text search field.

This is the code I've tried, it displays the Bestands1 like I want to (only 2000 rows), but not when I try to search for it. Is there any way to get rid of this delegation without using StartsWith? Is delegation the issue for it showing no results when filtering by text search box, or is it something else?

If(
 ZoekenNaarOrders.Text = "";
 colCombined.Bestandsnaam1;
 Filter(
 colCombined;
 ZoekenNaarOrders.Text = Bestandsnaam1
 )
)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

You can use Search on the collection colCombined. It is delegation friendly but will only return the 1st 2,000 results (which is fine because you’ll want the user to narrow it down).

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
GarethPrisk 2,828 on at

Like
a
(1)

Report
Copy link

Link copied!
Am I interpreting this correctly?

You have a Drop-down control which you want to filter, based on a separate Label control

The amount of items for the Drop-down control is large (up to 5k records)

Your data source must not support delegation, although you mention trying to keep it - what is your data source?

A few immediate notes:

That is an excessively large amount of values for a Drop-down control

Seems like it would be almost unusable unless filtered down significantly

Any change to the Items property (i.e. change in search) will effectively reset and deselect whatever was chosen; even if not intended

Would a Gallery make more sense?

Combining search and a list is exactly what Combo-boxes are intended for

It there a reason you'd split these up?

Delegation

In most cases, delegable sources handle large(ish) (2k+) volumes of records easily

Is there any others reasons to create the Collection for the app?

Otherwise, you can likely delegate this

Don't have the context for your app or controls, so please don't take this as a design criticism.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there @GarethPrisk

Thank you for your response, the solution from Davey was the one I was looking for. Somehow I didn't think of this easy solution.