Delegation Warning using In Function

(0) Share

Report

Posted on by firda59

372

Hi,

I used this formula to get value from my SP List.

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

But I got delegation for 'in' function. I tried to using another formula like this:

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

But it show nothing.

Can anyone help me to make this formula delegable? Thankyou!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @firda59 ,

Firstly the in filter simply is not Delegable, however I suspect your drop-down needs to equal the selected value

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

and then you can use StartsWIth on the other field. Also set the Default of your NoDrawing Text Box to "" (empty string)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

I used in because value in SP list and dropdown are different, I mean:
In SP List it just 'Middle' but in dropdown 'Body Middle Side',
like that,
so I used in function.

I try your formula, and it show nothing:(

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@firda59 ,

It will not if you require 'Middle' to be anywhere in the field - if you require the in filter in both areas, you simply cannot make it Delegable. This code will not solve your Delegation issue (only mask it on some occasions) if StartsWith will work for the Text Box

With( { _Data: Filter( 'WM FOR WELDER REGISTER', StartsWith( 'No Drawing', NoDrawing.Text ) ) }, Filter( _Data, SubAssy.Selected.Value in 'Grup Name Assembly' ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

thankyouuu! it can work now!

Was this reply helpful? Yes No