cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MartinSun2000
Helper II
Helper II

Delegation on SP list

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). 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

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,

screen2.PNG

and in the example it actually uses Searchtextbox with "In" for reference. 

products-apple.png

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 "Screen1.jpgchoice" 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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,278)