Sharepoint List over 2000 records

(1) Share

Report

Posted on by jamesalspec

This code for BrowseGallery worked fine until the SharePoint List exceeded 2000 records. Now the gallery shows no records. I have experimented with a few solutions but had no luck. I like the concept of creating a collection based on criteria and displaying the results, but I'm not sure how to implement. Any help would be appreciated. Thanks.

SortByColumns(Filter('Extrusion Replenishment', StartsWith(Item.Value, TextSearchBox1.Text), Text(DateValue(Created), "dd/mm/yyyy") = Text(DateValue(DatePicker1.SelectedDate), "dd/mm/yyyy")), "Created", SortOrder.Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

HI,

So your gallery displays nothing?

Well I am guessing that your Code has Delegation Issues. In your design studio, does it have a yellow underline and say it has delegation issues?

Was this reply helpful? Yes No
IAmIntractable 280 on at

Like (0)

Report
Copy link

Link copied!

The number of rows in the list only affects the number of rows returned based on the search criteria. I have lists with tens of thousands of rows. Note that a 2000 row gallery may be slow to render.

I would assign your items query below to a collection to see if any rows are returned. If none are, then your criteria is wrong. Note also that Starts with is case sensitive so perhaps there is no match.

SortByColumns(Filter('Extrusion Replenishment', StartsWith(Item.Value, TextSearchBox1.Text), Text(DateValue(Created), "dd/mm/yyyy") = Text(DateValue(DatePicker1.SelectedDate), "dd/mm/yyyy")), "Created", SortOrder.Descending)

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi

You can use this amazing formula by Tomasz Poszytek on the OnStart of your app to collect more than 2000 or any number of items (don't forget to replace the list names and other values) -

Set( firstRecord, First('Large List') ); Set( lastRecord, First( Sort( 'Large List', ID, Descending ) ) ); Set( iterationsNo, RoundUp( (lastRecord.ID - firstRecord.ID) / 500, 0 ) ); Collect(iterations, Sequence(iterationsNo,0)); ForAll( iterations, With( { prevThreshold: Value(Value) * 500, nextThreshold: (Value(Value) + 1) * 500 }, If( lastRecord.ID > Value, Collect( LargeListSP, Filter( 'Large List', ID_val > prevThreshold && ID_val <= nextThreshold ) ) ) ) );

Here's the link to his article to understand the code - https://poszytek.eu/en/microsoft-en/office-365-en/powerapps-en/overcome-2000-items-limit-using-power-apps-collect-function/

Hope it helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Hugoxoft 4 on at

Like (0)

Report
Copy link

Link copied!

You must create a pagination, I leave you an example:

Paginación en galeria (elpowerapps.blogspot.com)

Was this reply helpful? Yes No
jamesalspec 42 on at

Like (0)

Report
Copy link

Link copied!

@Hugoxoft @Nandit @IAmIntractable @FLMike

Apologies, I may not have been super clear. It shows any record up to the 2000th. Any record after that is not shown.

FLMike - you are correct. It shows delegation warning.

Was this reply helpful? Yes No