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
)
)
With(
{
_Asc,
Sort(
'Virtual Personnel Portal Ticket',
ID
),
_Desc,
Sort(
'Virtual Personnel Portal Ticket',
ID,
SortOrder.Descending
)
},
ClearCollect(
CollectionName
_Asc,
Filter(
_Desc,
!(ID in _Asc.ID)
)
)
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.