Cannot show more than 2000 records/items to combo box

(0) Share

Report

Posted on by johnryanrobles

Cannot show more than 2000 records/items to combo box is this the hard limit in PowerApps?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

KvB1 1,596 on at

Like
a
(0)

Report
Copy link

Link copied!

The hard limit is that PowerApps can only retrieve 2000 records from a datasource in a single query.

You can work around this by using filters or retrieving in batches

Was this reply helpful? Yes No
johnryanrobles 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Kv1,

Filter is not option because the requirement is to retrieve all unique records of specific field let's say comments field which all might not be unique and records might increase from 20k+ above daily. We are using SharePoint as datasource.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like
a
(2)

Report
Copy link

Link copied!

Your datasource is a sharepoint list that might receive more than 20k new entries on a daily basis?

Why would you want to create a combobox with so many items?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnryanrobles,

Do you want to display more than 2000 items within the Combo Box?

I have a test and the situation is confirmed on my side.

Generally, the Combo Box could display more than 2000 items using the Collect() function.

ForAll( Sequence(2001), Collect(colMax, Value) )

I create a collection containing 20001 items using the above formula, and the Combo Box could display all of them:

So as an alternative solution, you could consider using the Collect() function to store all the comments field items in a collection. Then display the collection within the Combo Box.

Hope it could help.

Was this reply helpful? Yes No
johnryanrobles 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried connecting to actual datasource/sharepoint list with more that 2000 records? i tried it on my end and it only displayed up to 2000 only.

Was this reply helpful? Yes No
johnryanrobles 36 on at

Like
a
(0)

Report
Copy link

Link copied!

We are replicating filter option in Smartsheet where it has if one of/is not one of filter criteria wherein when you clicked specific field and is one of/is not one of filter it will display all the unique data of that field.

selected

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnryanrobles,

Since I have known your scenario, so I suggest using the Collect() function to store all the comments field items in a collection. Then display the collection within the Combo Box.

I have mentioned it in my previously reply, please check it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi all,
Is this a question of displaying 2000 records, or reading 2000 records?

My team is trying to read a data table that has timeline (weeks) set in columns, so for one Record the data table show 30 rows, being 30 weeks for one given records.

thank you,
Jorge

Was this reply helpful? Yes No
DA-01102102-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you find a way to map this to data yet? Sequence creates a new collection of numbers (up to 50,000); on its own, it isn't connected to data. Could be interesting.

Was this reply helpful? Yes No