cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ed_C
Helper I
Helper I

Delegation Problem of Filter function on canvas app and SharePoint data source

Hi All
Why my filter code occur delegation warning on OR(||) and in 

 

Ed_C_0-1612926780752.png

But I searched the delegation ok for SharePoint list. How to fix it?

Please help

 

5 REPLIES 5
Pstork1
Dual Super User III
Dual Super User III

1) In is not a delegable operator in SharePoint.  It will work in some data sources, but not in SharePoint.

2) '||' or is not delegable when one of the clauses isn't delegable.  See #1

 

The best alternative here is to break the filter down into two nested filters.  The inner filter should include all the delegable functions and the outer the non-delegable.  You'll still get a delegation warning, but if the inner filter gets the list down below the data row limit the function will work.



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

Which data source is delegatable?
I just in building new app state with some sample data, so I thing I can change the data source type from SharePoint list to a delegable data source.

I found that the table of the delegation of each delegable data source, it seem no one is perfectly match.
So any idea of nested filter for me to make a multi filtering.
The fields need to filter in SharePoint is:
Priority Choice [Low, Normal, High]
Status Choice [New, In process, Completed]
ID Number [1 - infinity)
Date from to 
Thanks

Pstork1
Dual Super User III
Dual Super User III

SharePoint is a delegable data source.  But there are limits on which functions are or are not delegable.  Which functions you can use is different for each data source. Premium data sources like SQL and CDS provide more delegation, but they also require a premium license.



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

A lot of that depends on your data, and how big its going to get. Also, what exactly is the logic you are using?



-------------------------------------------------------------------------
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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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