How to access more 2000 records

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear all,

May I know that how can I access 2000 records from Share Point list through Power Apps?

I have try to use collection already but it just collect first 2000 records only.

Kindly advice.

Concurrent(
ClearCollect(CollectionA,Filter(varDB,Value(ID)<2000)),
ClearCollect(CollectionB,Filter(varDB,Value(ID) >=2000 And Value(ID)<5000)));
ClearCollect(NameofCollection,CollectionA,CollectionB)

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (22)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

How about you first collect all records in a collection without filtering and then use that collection in your above expression?

There are ways you can change the filter expression to use delegable functions but the above suggested method might be a quicker one.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

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

Like
a
(1)

Report
Copy link

Link copied!
Hi
Although I have try without filter also can not get all records.
As per below :
ClearCollect(NameofCollection,varDB)

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

If

ClearCollect(NameofCollection,varDB)
is still returning delegation warning, then that is odd.

So you can try removing the Concurrent statement from the outside of it and see if it works better like that.

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

Like
a
(1)

Report
Copy link

Link copied!
@poweractivate
I have try to remove the concurrent.
ClearCollect(CollectionA,Filter(varDB,ID<600)); ClearCollect(CollectionB,Filter(varDB,ID >=600 And ID<700)); ClearCollect(NameofCollection,CollectionA,CollectionB);

Besides I also try to reduce the limit and it just show until 588 records only.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Reduce the limit will never work. That limit is how many PowerApps sees - it picks the first 2000 random records from your data source and it will refuse to see any more records even if you get all of them, it does not affect the Filter, it affects the whole thing. Once you hit a delegation warning we recommend you never use the app in production until you can remove the delegation warning.

In your case, can you try to filter on the Data Source instead of a variable? (if applicable)

Other than that, not sure why you get the delegation warning.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous wrote:
Hi
Although I have try without filter also can not get all records.
As per below :

ClearCollect(NameofCollection,varDB)

What is varDB? Is it a Variable?

Can you use the Data Source directly instead of the variable?

Can you also see if this persists after you take out the Collection wrap around it and just use the Data Source directly to test? Such as if you just test by using the data source directly in a Gallery with no filters - does the delegation warning still show anyway even like that and does it still have the same issue with the records?

Also, can you double check that you are using a SharePoint List as the data source in your query here, as opposed to something like a OneDrive File or Excel File as the data source?

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

Like
a
(1)

Report
Copy link

Link copied!

@poweractivate

did you means to use excel as data set,instead of list?
I have change as per you request, but it comes out an error below :

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

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

@Anonymous wrote:
@poweractivate

did you means to use excel as data set,instead of list?
I have change as per you request, but it comes out an error below :

No we meant that if you were using excel as data source, to make sure not to use it.
So if you are using SharePoint list, which would be correct, we are not sure why you still get warning even with no filters.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Can you try the collection process outside of the Concurrent function as suggested by @poweractivate?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No