web

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

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Delegation Warning

Power Apps - Building Power Apps

Answered

Delegation Warning

Like (0) Share

Report

Report

Posted on 5 Sep 2023 02:19:16 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

All responses Img

All responses (4)

Answers Img

Answers (1)

firda59 372 on 05 Sep 2023 at 03:09:47

Like (0)

Report

Re: Delegation Warning

@v-xiaochen-msft
thankyou!!!
Verified answer

v-xiaochen-msft on 05 Sep 2023 at 02:58:20

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
firda59 372 on 05 Sep 2023 at 02:53:08

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
v-xiaochen-msft on 05 Sep 2023 at 02:34:04

Like (0)

Report

Re: Delegation Warning

Hi @firda59 ,

Please try to use function startswith.

Best Regards,

Wearsky