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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need Help with Power A...
Power Apps
Unanswered

Need Help with Power Apps Search and Filter Delegation Warning

(0) ShareShare
ReportReport
Posted on by 4

I'm new to using Power Apps. I've successfully built a search and filter feature, and it's delivering the expected results. However, the challenge is that I'm receiving a delegation warning from the system. I'm not entirely sure if I've made a mistake in my approach or if there's a way to manage or resolve this warning without compromising the functionality of my app.

Any quick tips or advice on resolving this warning or whether it can be safely ignored would be greatly appreciated.

Thank you for your help!

Powerapp.png

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Sawanya_W ,

     

    If your data will not exceed 2,000 records, just open the setting and set delegation to 2000.

    vxiaochenmsft_0-1698046099929.png

     

    Best Regards,

    Wearsky

  • Sawanya_W Profile Picture
    4 on at

    I already changed data row limit from 500 to 2000 but warning still display.

  • AndrewR1 Profile Picture
    1,572 Moderator on at

    Hi @Sawanya_W delegation warnings mean that once the row limit for your application has been hit this will no longer pull from the data source the Data row limit can be found in the settings of the canvas app: 

     

    AndrewR1_0-1698046134422.png

     

    This can be set to a maximum of 2000 Items so if your application will never exceeds this item limit then you will be fine but if the application will exceed 2000 items (Assuming you have this Data row limit set to 2000) then this will then cause you issues with not collecting the 2001 etc item in your list. 

     

    I would recommend always setting this to 1 when editing as then you will clearly see when a delegation issue will arise in the future! 

     

    Starts with is a None delegable Function unfortunately! So you will always get this waring when using this in your filter when your using a nondelegable data source like SharePoint. You could try moving to a delegable Data source which would be Dataverse or try a batch loading process using Power Automate to pass your data to the Canvas App in to a collection. 

     

    For more info on Delegation: 

    https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview 

     

    Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

    If the content was useful in other ways, please consider giving it Thumbs Up. 👍

    Thanks
    Andrew

  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Sawanya_W ,

     

    The delegation warning will not disappear even if you set it to 2000. 

    But if the table length is within 2000, it will not affect your application.

    Hope it makes sense.

     

    Best Regards,

    Wearsky

  • AndrewR1 Profile Picture
    1,572 Moderator on at

    @Sawanya_W not me 🙂 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard