Announcements
I am encountering the 2000 recod limit probelm again eventhough the function I called is all delegable function (Filter, In...)
See attached. The filtered list does not return the recentely added record. The number of record just exceeded 2000 (which is the limit I set for this App) recently (see screen2).
I was trying to find a reference for this, but as I remember 'in' is not a delegable function for SharePoint like it is for something like SQL. 'in' is essentially a test of contains and SahrePoint doesn't handle that server side. It handles that client side, so its not delegable. Do a simple test and switch out 'in' for a StartsWith() test and you'll find that the delegation warning goes away.
Although in the reference guide (https://docs.microsoft.com/zh-tw/powerapps/maker/canvas-apps/delegation-overview） it says "In" combined with the Filter function is delegable,
and in the example it actually uses Searchtextbox with "In" for reference.
But anyway, after I swith out "In" with "StartsWith", the blue dots under "In" goes away, but then I got another blue dots warning under the ".value" of a certain "choice" variable (see attached picture). Is .value also not delegable?
The page where it says in is delegable is the page that covers all the data sources like SharePoint, SQL, etc. In is delegable for SQL, but not for SharePoint. I tried to find something in the documentation that points that out, but couldn't find it. But I can guarantee its true. Using in with a SharePoint data source will trigger the delegation warning because SharePoint can't handle a contains filter as a delegable filter.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 356 Most Valuable Professional
11manish 225 Super User 2026 Season 2
Mohsin Ali 211
