web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Delegation Warning

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:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @firda59 ,

Please try to use function startswith.

Best Regards,

Wearsky
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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 at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft
thankyou!!!

Join the conversation