cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Commander
Kudo Commander

Filter delegable predicates for SharePoint

I have SharePoint list with column "Example Number" that contains numeric values 0 - 20

In my PA I've made following function: 
Filter('Delegation List', Example_x0020_Number>6)

 

To my surprise it returns all record (observed on Data Table control) - in opposition to documentation  which says that SharePoint supports delegation only for "=" in Filter function). 

I've checked other predicates: <, <=, =, <>, >, >= 

All were delegated. For test purposes I've checked Not() function - it returned me number of results according to delegation cap (3).

 

Have something been changed in SharePoint delegation in PA or I'm doing something wrong?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: Filter delegable predicates for SharePoint

Good point; the relational operators are used more frequently in numeric columns, but may also be used in others. Dates have a known bug that even equality comparison doesn't work properly in SharePoint.

We're redesigning that page to move it closer to the actual connectors, and will have additional information there. Meanwhile, I'll propose a change to the current page to the documentation team with this additional information.

View solution in original post

5 REPLIES 5
Highlighted
Super User
Super User

Re: Filter delegable predicates for SharePoint

Hi Mike,

Well done for testing this instead of relying on the documentation! I tested this and got the same result, equally to my surprise.

This is great news because in cases where we need to work with more than 2000 records, we can use the < and > predicates against the id column to build a local collection.

As a side note, I tried the < and > predicates against a date field but unfortunately, I still got a delegation warning. So it seems this is only valid for numeric fields.

Power Apps
Power Apps

Re: Filter delegable predicates for SharePoint

Thank you for pointing out the inconsistency. We've updated the documentation page, it should go live shortly to reflect it.

Highlighted
Kudo Commander
Kudo Commander

Re: Filter delegable predicates for SharePoint

@timl: unfortunately it;s not working for ID column as well. I think it's because delegation does not support type convertion which means that ID column is text type (even thou it contains only numeric values).

@CarlosFigueira: Changes has been propagated but it's still not consistent. Only numeric column type supports all predicates. Text and Date type support only =. Bool and User fields are not supported at all. @timl can you confirm that please? Together maybe we can propose how documentation should sound to not be missleading 🙂

Highlighted
Power Apps
Power Apps

Re: Filter delegable predicates for SharePoint

Good point; the relational operators are used more frequently in numeric columns, but may also be used in others. Dates have a known bug that even equality comparison doesn't work properly in SharePoint.

We're redesigning that page to move it closer to the actual connectors, and will have additional information there. Meanwhile, I'll propose a change to the current page to the documentation team with this additional information.

View solution in original post

Highlighted
Super User
Super User

Re: Filter delegable predicates for SharePoint

Thanks @Mike_Guzowski for confirming that this doesn't work with ID columns., which is a shame. I can confirm that Bool and user fields don't work for me either.
@CarlosFigueira Thanks for highlighting the issue with datas and the equality operator, and also for updating the documentation so quickly.
In terms of wording, how about placing a number '3' footnote against the word 'yes' in the SharePoint field and beneath the table, adding the words:
3 For numeric fields only

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,813)