I am using a SharePoint list as a datasource that is likely to grow to over 10,000 items.
The following filter has no delegation warnings. Does this mean that all the relevant data will be returned? What if the dataset exceeds the data row limit set in Power Apps?
Capex Number is unique. If I was searching a capex number that was the 10,000th item in SharePoint would it still be returned?
Is it necessary to batch load my data into a local collection?
Sort(
Filter(
'TheSPL',
'CapexNumber ' = Value(txtSearchBox.Text) Or IsBlank(txtSearchBox.Text),
'Status'.Value = locSelectedFilter Or locSelectedFilter = "All"
),
Created,
Descending
)
