You’re offline. This is a read only version of the page.
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!
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
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
You can use the StartsWith function, however there is no easy way to get around delegation for the 'in' operator:
Share
Report
All responses (
Answers (
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
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
