Unanswered

Filter in clearcollect

(0) Share

Report

Posted on by Vaibhav_k

Dear community,

I am using below expression to get the values from sharepoint list. However, is it possible to get more than 500 records?

ClearCollect(

colGalData,

Filter(

ClaimsForms ,

ApprovalResponse = "Pending - Process"

)

);

Also for below formula, i get warning as

Launch(ThisItem.'Link to item', "", LaunchTarget.New)

To use the 'target' argument (LaunchTarget) in the Launch function the second parameter must be a record.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Pstork1 69,203 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The default data row limit is 500. If you increase that in your settings you can get more. The maximum is 2,000. Once you get that high you need to retrieve them using a delegable filter in batches of no more than 2,000. For example you could use a StartsWith filter of the Title based on each letter of the alphabet using ClearCollect first and then Collect after.

Was this reply helpful? Yes No
Vaibhav_k on at

Like (0)

Report
Copy link

Link copied!

Thanks @Pstork1, do you mean increasing limit to 2000 only will be enough?

Was this reply helpful? Yes No
Pstork1 69,203 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I mean that 2,000 is the highest you can increase the limit. Power Apps will never return more than 2,000 records in any single call. for example, if there are 750 records that meet your filter requirements then setting the data row limit to 800 would return all 750 records. Leaving it at 500 will only return 500 of the 750.

Was this reply helpful? Yes No
Vaibhav_k on at

Like (0)

Report
Copy link

Link copied!

Okay @Pstork1. I have more than 5000 items in the list and if I make the limit to 2000, the filter will only get 2000 items and remaining items won't be fetched after 2000. Is there any example by which I can understand to handle this scenario? Do I need to archive the items?

Was this reply helpful? Yes No
Vaibhav_k on at

Like (0)

Report
Copy link

Link copied!

Could this be the solution. As i want to implement this in production, we dont have UAT

ClearCollect( colGalData, Filter( ClaimsForms, StartsWith(ApprovalResponse, "Pending - Process") ) );

Was this reply helpful? Yes No
Pstork1 69,203 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Read about the concept of delegation here: Understand delegation in a canvas app - Power Apps | Microsoft Learn When you use delegable functions in a filter it delegates the application of the filter to the backend data source. So if you have 5,000 records total but the filter you are applying is delegable and selects less than 2,000 records you'll get all the matching records. If the function is non-delegable you'll get the matching records from the first 2,000 records. The key to working with large data sources is to NOT load them into local collections. Instead you should use delegable functions to make an appropriate subset of the records available to the user at any particular time for them to interact with.

Can I ask why you want to load the records into a local collection using ClearCollect?

Was this reply helpful? Yes No