web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Delegation Warning

(0) ShareShare
ReportReport
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!

I have the same question (0)
  • v-xiaochen-msft Profile Picture
    on at
    Re: Delegation Warning

    Hi @firda59 ,

     

    Please try to use function startswith.

     

    Best Regards,

    Wearsky

  • firda59 Profile Picture
    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

  • Verified answer
    v-xiaochen-msft Profile Picture
    on at
    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
    372 on at
    Re: Delegation Warning

    @v-xiaochen-msft 

    thankyou!!!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 624 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 384 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 246

Last 30 days Overall leaderboard