I'm running into the 2000 record limit issue with my gallery. I'm trying to follow Raza’s method with the pagination, but my formula only pulls 2000 records, and my current source has 2002 items. I have pasted my "OnStart" formula, GalleryHidden, and Gallery2 Formula. Thanks!
OnStart Screen Formula
Set(popUpVis, true);
Set(varSortColumn, "ID");
Set(varSortDirection, SortOrder.Descending);
Set(varDelegationLimit, 500);
// Clear and collect data directly from your data source
ClearCollect(
CollectionName,
'Virtual Personnel Portal Ticket'
);
GalleryHidden Formula
Filter(
CollectionName,
// Section filtering
If(
Gallery1.Selected.Value = "All",
true,
'FSS Section' = Gallery1.Selected.Value
) &&
// Ticket status filtering
(
IsBlank(ComboBox1.SelectedItems) ||
'Ticket Status' in ComboBox1.SelectedItems
) &&
// Additional section filtering
(
IsBlank(ComboBox1_1.SelectedItems) ||
'FSS Section' = ComboBox1_1.Selected.Value
) &&
// Technician filtering
(
IsBlank(ComboBox1_3.SelectedItems) ||
Technician = ComboBox1_3.Selected.Value
) &&
// Text search filtering
(
IsBlank(IDFilter_1.Text) ||
StartsWith(Text(ThisRecord.ID), IDFilter_1.Text) || // Correctly converting ID
StartsWith('Last Name', IDFilter_1.Text) ||
StartsWith(Technician, IDFilter_1.Text) ||
StartsWith(Issue_Text, IDFilter_1.Text) ||
StartsWith('Customer Comment', IDFilter_1.Text)
)
)
Gallery2 Formula
If(
iconNext.DisplayMode = DisplayMode.Disabled,
// Handling last set of records
LastN(
FirstN(
GalTicketHidden.AllItems,
drpPaginationSize.Selected.Value * varPageNumber
),
drpPaginationSize.Selected.Value - (drpPaginationSize.Selected.Value * varPageNumber - CountRows(GalTicketHidden.AllItems))
),
LastN(
FirstN(
GalTicketHidden.AllItems,
drpPaginationSize.Selected.Value * varPageNumber
),
drpPaginationSize.Selected.Value
)
)
