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

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
msgsupriya 4 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No