Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Delegation Warning

Posted on by 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!

  • firda59 Profile Picture
    firda59 372 on at
    Re: Delegation Warning

    @v-xiaochen-msft 

    thankyou!!!

  • Verified answer
    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 Profile Picture
    firda59 372 on at
    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

  • Re: Delegation Warning

    Hi @firda59 ,

     

    Please try to use function startswith.

     

    Best Regards,

    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard