Unanswered

Overcoming 2000 limit for a combo box

(0) Share

Report

Posted on by 1234790

Hey everyone,

I have an App were the user searches a combo box for a model number which then displays the specifications of that model number to allow for a cross reference. I am going to have over 2000 model numbers to search through and since the model number is the only search parameter I can't use ClearCollect or Filters to overcome the 2000 limit. Is there another way around this

for a combo box?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

narayan225 2,547 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@1234790

I suggest you create a collection for the combo box. Because there is a limit on 2000 rows per query, you can use multiple queries to retrieve data.
There is one more way by using Power Automate. Matthew Devany has a very detailed blog about it.
https://www.matthewdevaney.com/create-power-apps-collections-over-2000-rows-with-these-4-tricks/

Cheers!

Was this reply helpful? Yes No
1234790 6 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for the reply, the blog has some interesting methods. What is the process for creating the collection for the combo box?

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@1234790

It doesn't have a specific process. You can filter your DataSource or add the whole data source into a collection.
ClearCollect(combo,Filter('Logbook Submissions','Action Taken'.Value = "Satisfactory"))
Here I am collecting my DataSource for rows that have Satisfactory choice selected in one of the columns.

I have set the Items property of the combo box to the above collection.

Cheers!

Was this reply helpful? Yes No