Collect more tha 2000 excel data

(0) Share

Report

Posted on by firda59

372

Hello, everyone!

I used this formula to grab my excel data, my excel has 10000 rows.

ClearCollect(DataProdOrder, Filter(Perform, Value(No)<=2000), Filter(Perform, Value(No)> 2000 && Value(No)<=4000), Filter(Perform, Value(No)> 4000 && Value(No)<=6000), Filter(Perform, Value(No)> 6000 && Value(No)<=7000))

But, the data are shown just 2000 data, how to fix it?

Thank you in advance.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

satishdongare 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @firda59
There is limitations to fetch the records from the excel or any database , at a time you can only fetch 2000 records.
so you can try this one
Collect(ds1,datasource); //Collects the first 2000 items
Collect(ds2,FirstN(Sort(datasource,Descending),100)); //Collects the rest of the items
Collect(dsfinal,ds1,ds2) //Combines the two datasources

Hope it will helps you
Thanks !
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@firda59,

2000 is the maximum and Excel does not support any delegable functions. There are workarounds to get up to 4000 rows however:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Collections-maxes-out-at-2000-when-populating-with-SharePoint/td-p/179419

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

hello @satishdongare
still cant work, the list just shown 2000 rows
satishdongare 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@firda59 Does your Excel file Contains any column like Id on that basis we can fetch the records ,
If you have column like Id or any other column on the basis of column we can fetch the records
Ex.
ClearCollect(colExcelData ,Filter(‘Name of Table’,ID<=2000),
Filter(‘Employee’, ID<=4000 And ID>=2001),Filter(‘Employee’, ID<=6000 And ID>=4001 ),Filter(‘Employee’,ID<=8000 And ID>=6001 ),Filter(‘Employee’,ID<=10000 And ID>=8001 ))