Gallery shows only 2000 rows

(0) Share

Report

Posted on by msgsupriya

Hi,

I have an excel file (one drive) with more than 4000 rows.

I increased the Row limit from 500 to 2000. Does not show all the records

I also tried the below on App > OnStart

Concurrent(ClearCollect(CollectionA,Filter(CategoryTable,Id<2000)),
ClearCollect(CollectionB,Filter(CategoryTable,Id >=2000 And Id<4000)),
ClearCollect(CollectionC,Filter(CategoryTable,Id >=4000 And Id<6000)));ClearCollect(TestCollection,CollectionA,CollectionB,CollectionC)

When I view the Gallery, refering to the 'TestCollection' it still doesnt show all the records. Limts the rows to 500 only.

Please suggest if I am doing something wrong

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @msgsupriya ,

Please have a read of the "big collection" item in this blog of mine on Delegation.

Happy to elaborate further when you have done this.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
msgsupriya 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thanks for this
I tried the code snippet - If you have between 2,000 and 4,000 records, replacing 'MyList' with the Excel table, still no luck.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@msgsupriya ,

'I can assure you it works as I use it myself, however with 6,000 rows, you need the "big collection". I am not completely sure on Excel as I use SharePoint and I know there may be issues getting more than 2,000 rows from Excel - this is a good reference article.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @msgsupriya ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.