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.
Hi @MRNBagtas ,
That didn't work.
Initially the delegation error was in TextInput1.Text,"SPOC".
With "in" the delegation error is on the "in" word.
Hi, @Anonymous !
I actually did the same scenario you have, but instead of an SP list, I used collection.
It worked fine for me using your PowerApps code without any delegation error.
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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!