delegation function

(0) Share

Report

Posted on by firda59

372

Hi,

I have this formula:
Filter('WM FOR WELDER REGISTER', 'Grup Name Assembly' in SubAssy.Selected.Value, NoDrawing.Text in 'No Drawing')

I used 'in' function because the value in NoDrawing.Text is 1-0951, but in 'No Drawing' is 1-0951-1 or 1-0951-2. So, I used that function, but I got delegation. Is there any alternative function to replace 'in' in that formula?

Notes. I used sharepoint list, I'm afraid if data more than 2000 will make error/ powerapps cant grab all my data.

Thankyou!

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
You can use the StartsWith function, however there is no easy way to get around delegation for the 'in' operator:

Filter( 'WM FOR WELDER REGISTER', StartsWith('Grup Name Assembly', SubAssy.Selected.Value), StartsWith('No Drawing', NoDrawing.Text) )

Matt Devaney did a great post recently around using Power Automate to get around the delegation, so you can also look at that here if you want a more complicated solution:

https://www.matthewdevaney.com/power-apps-search-a-sharepoint-list-no-delegation-warning/

Cheers,

Sancho
firda59 372 on at

Like
a
(1)

Report
Copy link

Link copied!

@iAm_ManCat

I got this error:
Part of this formula cannot be evaluated remotely. The 'StartsWith' function cannot be delegated if a field name appears in the second argument.

Is there any other way? Thankyou
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @firda59

I used the structure of your original code, which was checking the in function the other way, this resulted in an error.

I have corrected my original answer to swap the two parameters around.

You can also look at the function reference for the StartsWith function if you want to try and understand more