Hi @Sage22,
Do you want to display more than 2000 records in the Gallery?
Could you please share a bit more about the scenario, what is your data source, SP list?
Firstly, as @CNT mentioned, you could increase the limit to 2000 in the settings.
Or you could try to transfer the entire list into the collection and display the collection in the Gallery.
delegate functions for SharePoint list
| Item |
Number |
Text |
Boolean |
DateTime |
Complex [1] |
| Filter |
Yes |
Yes |
Yes |
No [4] |
Yes |
| Sort |
Yes |
Yes |
Yes |
Yes |
No |
| SortByColumns |
Yes |
Yes |
Yes |
Yes |
No |
| Lookup |
Yes |
Yes |
Yes |
No |
Yes |
| = |
Yes |
Yes |
Yes |
No [4] |
Yes |
| <, <=,<>, >, >= |
Yes [2] |
No |
No |
No |
Yes |
| StartsWith |
- |
Yes |
- |
- |
Yes |
| IsBlank |
- |
No [3] |
- |
- |
No |
In collection, there's no delegation limit.
However, when you save data in collection, you also need to use delegate function.
You need to save data to collection per 2000 records. (ID column is not delegate for "<",">")
So usually we need another number field with unique value to save data to multiple collections. You could create a collection to add a column to save the id value with text format:
ClearCollect(Temcol,AddColumns(DataSource,"numberfield",ID))
For example:
ClearCollect(collection1,Filter(list,numberfield<=2000));
ClearCollect(collection2,Filter(list,numberfield>2000,numberfield<=4000));
ClearCollect(collection3,Filter(list,numberfield>4000,numberfield<=6000));
ClearCollect(collection4,Filter(list,numberfield>6000,numberfield<=8000));
.....
Or you could use the Filter() to filter Title column and ID column as below:
Filter(DataSource,StartsWith(Title,SearchText1.Text),ID=Value(SearchText2.Text)))​
