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
Unanswered

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!

Categories:
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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard