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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation Warning
Power Apps
Answered

Delegation Warning

(1) ShareShare
ReportReport
Posted on by Sajarac 3,295

Hi there,

Currently I have 2 warnings for this:

 

In my first gallery I have a warning for my Column "Title"

SortByColumns(
Filter(
LIPCustomers,
TextSearchBox1.Text in Title || TextSearchBox1.Text in Quote
),
"ID",
If(
SortDescending1,
Descending,
Descending
)
)

 

And In a combobox it says the "search" part of this formula might not work on large data sets. This data source I am pretty sure that the list will never exceed 2000 records. Should I worried about this? if so how can I fix both warnings?

 

Thanks in advance

Categories:
Building Power Apps
I have the same question (0)
  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @sajarac ,

     

    In PowerApps In is not a delegable operator for PowerApps. I noticed you are using In in your filter.

    https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/

    If you want to avoid this move all your data to a collection and perform filter on the collection with IN.


    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

  • cchannon Profile Picture
    cchannon 4,702 Moderator on at

    @KrishnaV is absolutely right, but I will elaborate a bit on his point just to explain some of the nuance here.

     

    1. Delegation of query is a topic actively worked on by the product group, so over time more and more support is being added, so do not despair: some day soon this might not be an issue any more.
    2. You mentioned that you are sure the record counts will never exceed 2k for this table. If you are CERTAIN about that, then it is possible to override the return row limit for non-delegable queries (default 500) to bump them up to 2k. This would get you around the problem, but be CAREFUL: the limit is defaulted to a low number because it could possibly cause a performance issue and could be a big problem down the line if you go higher than the limit you set, so TEST TEST TEST!
      1. To override this, open your app to edit and navigate to Settings --> Advanced Settings --> Data row limit for non-delegable queries. Set this value to 2000 and it will still give you the warning, but the query will be safe for up to 2k rows.

    cchannon_0-1594058862759.png

     

     

  • Sajarac Profile Picture
    Sajarac 3,295 on at

    Thank you both @cchannon , @KrishnaV ,

     

    I am sure for the second gallery that the rows never will exceed.

     

    But for the first gallery, any workaround to fix the issue in the meantime, because that gallery will pass sooner 2000 records.

     

    thank you kindly

  • Verified answer
    Drrickryp Profile Picture
    Drrickryp Super User 2024 Season 1 on at

    @sajarac 

    That depends on how large your first table is (or can be expected to grow to).  However, if you can use StartsWith in your filter you will not have a problem with delegation no matter how large your Customers list becomes. 

     

    Filter(
 Customers,
 StartsWith(
 Title,
 SearchInput.Text
 ) || StartsWith(
 Quote,
 SearchInput.Text
 )
)

     

    StartsWith() is a delegatable function in SharePoint so the filter is done at the server level. It will also be quite fast.  If you absolutely require a search within the field and your list will become greater than 5k, consider using a different connector such as SQL or CDS.  SharePoint is free but gimping the functions available to PowerApps is the price you pay. 

  • Sajarac Profile Picture
    Sajarac 3,295 on at

    Thank you.

     

    My current formula is:

    SortByColumns(Filter(LIPCustomers,TextSearchBox1.Text in Title || TextSearchBox1.Text in Quote),"ID", if(SortDescending1,Descending,Descending))

     

    And yours is:

     

    Filter( Customers, StartsWith( Title, SearchInput.Text ) || StartsWith( Quote, SearchInput.Text ) )

     

     

    but I am getting an empty gallery.

     

    Any idea?

     

    thank you kindly

  • Verified answer
    Drrickryp Profile Picture
    Drrickryp Super User 2024 Season 1 on at

    @sajarac 

    To test whether the Filter is working, copy it into the Items property of the gallery.  Also, check the Text property of the TextInput box and make sure it is "".   I like to build a formula for a gallery piece by piece so that I can check if it is working.  For example, 

    I would to start by clearing the Items property of the gallery and put in just Customers and see if it fills up.  Then build the formula by wrapping Customers with Filter( Customers, StartsWith(Title, SearchInput.Text )).  If that works, then add the OR part to get 

    Filter( Customers, StartsWith( Title, SearchInput.Text ) || StartsWith( Quote, SearchInput.Text ) ) .  Finally when that works, wrap the Filter with the SortbyColumns().

  • Sajarac Profile Picture
    Sajarac 3,295 on at

    Thank you, thank you, thank you.

     

    Delegation is "GONE WITH THE WIND"

     

    and sort by columns works also.

     

    thanks a million!!

     

    🙂

     

  • Drrickryp Profile Picture
    Drrickryp Super User 2024 Season 1 on at

    smiling.gif

     

  • Sajarac Profile Picture
    Sajarac 3,295 on at

    Hold on, before we do the happy dancing with your creature, I would like to ask you this:

     

    SortByColumns(Filter(LIPCustomers, StartsWith(Title, TextSearchBox1.Text) || StartsWith(Quote, TextSearchBox1.Text)),"ID",If(
    SortDescending1,
    Descending,
    Descending
    )
    )

     

    I am getting invalid argument type (number) expecting a text value instead.

     

    I have tried (value(quote.text). 

     

    But is complaining

  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @sajarac ,

     

    try this:

    SortByColumns(
Filter(LIPCustomers, 
(StartsWith(Title, TextSearchBox1.Text) || StartsWith(Quote, Value(TextSearchBox1.Text))
),"ID",
If(
SortDescending1,
Descending,
Descending
)
)


    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans