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?
Solved! Go to Solution.
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.
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.
Thank you for pointing out the inconsistency. We've updated the documentation page, it should go live shortly to reflect it.
@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 🙂
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.
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
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
207 | |
188 | |
80 | |
50 | |
38 |
User | Count |
---|---|
305 | |
256 | |
121 | |
73 | |
56 |