Unanswered

Trying to get data beyond 2000 rows in combo box

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am driving the canvas app with a data source (sharepoint List) which consists of more than 3000 records. I am trying to search based on the ID column inside the App. I had changed the limit to 2000 on the app setting. Still, I am not able to all the records it's fine on display it restricts to 2000 rows but while searching some data which is beyond 2000 rows it should display me right it's not working. Please help me out with any solution

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Gochix 1,935 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

you could collect in app collection with all 3000 rows and then use combobox items as your new collection?

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

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

Like (0)

Report
Copy link

Link copied!

Thanks for your response @Gochix
The records can go beyond 10000 in that case will the collection work? else what would be work around on that case

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,
To answer on your question - Yes that’s fine to have 10k records in App collection. You just would need to apply a filter to collect these records.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

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

Like (0)

Report
Copy link

Link copied!

@Gochix
Thanks for your response can yo guide me out with some example syntax

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report
Copy link

Link copied!
As example On app Start:
ClearCollect( YourNewCollection, Filter( DataSourceInSharePoint, ID <= 2000 ), Filter( DataSourceInSharePoint, ID > 2000 && ID <= 4000 ), Filter( DataSourceInSharePoint, ID > 4000 && ID <= 6000 ), Filter( DataSourceInSharePoint, ID > 6000 && ID <= 8000 ), Filter( DataSourceInSharePoint, ID > 8000 && ID <= 10000 ) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

You could use a textinput control and a dropdown control

The dropdown would have the formula Filter(splist, StartsWith(yourcolumn, Textinput1.Text)) and it would work with hundreds of thousands records.

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Could you please provide more detail on what you're trying to do? You want a combo box to have a filtered set of records that comes from a sharepoint list? What is the filter? Can you give an example?

I'd be very cautious about trying to load a collection with 10,000 rows, as has been suggested, as that will be slow, and the app will need to be updated once there are 10,001 rows.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Gochix

Don't get caught on that trip in your formula....it is not delegable and will not load more than 2000 records into your collection! The reason is, ID comparisons other that equal are non-delegable. So, the first filter in your formula will pull up to 2000 records, but the additional ones will pull nothing.

The trick to make that work is to mimic the ID column into another number column. This would have to be done using PowerAutomate to generate the value on each new record.

@Anonymous However, as @Mike2500 points out, you should consider designing differently as you will be severely killing the performance of your app. @Drrickryp offers a good solution to work around that.

Just saw the post and adding my $0.02

Was this reply helpful? Yes No