web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Delegation Warning

Power Apps - Building Power Apps

Answered

Delegation Warning

(0) Share

Report

Report

Posted on by firda59

372

Hi,

I have SP List 'WM For WELDER REGISTER' which has more than 2000 rows.

I used this formula to get data from that SP List.

First(Filter('WM FOR WELDER REGISTER', ('Grup Name Assembly') in ProdDesc.Text, NoDrawing.Text in Title)).'Grup Name Assembly'

But, 'in' function got delegation warning. Does anyone know, what function can I use to replace 'in' function?

Thankyou!

Categories:

Connecting to Data

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

v-xiaochen-msft on at

Like (0)

Report

Re: Delegation Warning

Hi @firda59 ,

Please try to use function startswith.

Best Regards,

Wearsky

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Re: Delegation Warning

Hi @v-xiaochen-msft

like this?
First(Filter('WM FOR WELDER REGISTER', StartsWith(ProdDesc.Text, 'Grup Name Assembly'), NoDrawing.Text in Title)).'Grup Name Assembly'

I still get delegation warning

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Re: Delegation Warning

Hi @firda59 ,

Please try this

First(Filter('WM FOR WELDER REGISTER', StartsWith('Grup Name Assembly',ProdDesc.Text), StartsWith(Title,NoDrawing.Text) )).'Grup Name Assembly'

Btw, the first() function also will cause delegation warning, but it will not have any side effect.

Best Regards,

Wearsky

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Re: Delegation Warning

@v-xiaochen-msft
thankyou!!!

Was this reply helpful? Yes No

Join the conversation