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
Dual Super User

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
Dual Super User

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
Dual Super User

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,545)