Hi,
I’m building an app for my department,
one of the screens contains a Gallery where i have applied multiple search/filters to preview it.
Right now, I’m receiving a Delegation Warning (which according to my understanding will lead that records above 2000 will not be shown in the app).
My data source is a SharePoint list and the fields I’m filtering are as following:
Operator = lookup from another SharePoint list in the same site
Station = lookup from another SharePoint list in the same site
Flight = short text field
Date = date
The formula I’m using for the gallery
Search(
Filter(
'Delay Report', IsBlank(Operator_Select.SelectedItems.Value) || IsEmpty(Operator_Select.SelectedItems) || Operator.Value = Operator_Select.Selected.Value,
IsBlank(Station_Select.SelectedItems.Value) || IsEmpty(Station_Select.SelectedItems) || Station.Value = Station_Select.Selected.Value,
'Event Date' >= Date_Filter_From.SelectedDate && 'Event Date' <= Date_Filter_to.SelectedDate
),
Flight_Filter.Text,"FlightNo")
my questions are
1) is there is a workaround for my case to avoid the delegation issue.
2) if there is no workaround, will date beyond 2000 records not even appear in the gallery if I filtered according to its criteria, (exmaple, if i have 4000 records, and due to the delegation issue i'm viewing 500 and up to 2000 only "Without Filtering the records, BUT what is if i have filtered the records with criteria for one records between 3000 to 4000 ... will it even appear.
Thanks for your help
