I have resolved quite a few delegation errors but this one I can't seem to figure out.
The items property in my gallery is:
Search( Filter('Exception Tracker',SPOC = Me), TextInput1.Text,"SPOC")
Me is set on OnStart of the app as
SPOC is a text comun in my SP list.
Any help will be appreciated.
I've just noticed that your delegation warning was underlining TextInput1.Text,"SPOC". In that case it refers to "Search" function (not Filter one) - which can not be delegated to Sharepoint list.
If your Filter is selective enough to never returns more then 2000 records - then you can save it temporarily to collection and search over it using Search.
Hi @Mickyw ,
Thank you for that explanation. But I never faced this issue in my previous apps. While I used the same format
for e.g. This one from one of the other apps works just fine.
SortByColumns( Search( Filter( 'Incident Tracker', Vertical = UsrVertical, Action_x0020_Plan_x0020_Status = "Incident Logged" ), TextInput1.Text, "Impacted_x0020_Client" ), "Incident_x0020_Id", Descending )
I started my current app with a replication of the same code, just changing the variable names but landed in error. SInce then I have been stripping down the code, removed sort, but no luck.
This is where I am in my current app. Delegation error still on search on the OHR field.
ortByColumns( Search( Filter('Exception Tracker',SPOC=Me), TextInput1.Text,"OHR"), "Date_x0020_of_x0020_Movement",Descending)
Any other ideas? My record count is expected to be more than 2000.
I agree this is mysterious how delegation warning is calculated. I have a impression it it sometimes false-positive.
For example this gives me delegation warning (SP list has only single text column)
Collect( testcol1; Search( Filter( delegation_test; Title = "2019-01-01" ); "2019"; "Title" ))
while this does not (find the difference 😉 😞
Collect( testcol1; Search( Filter( delegation_test; Title = "2019-01-01" ).Title; "2019"; "Title" ))
In such and simillar cases it should help if you collect data from Filter into temporary collection and then search it in second call.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications