I'm creating a canvas app, the source is a SharePoint list.
On one of the screens I created, there's a Card with source a yes/no column.
Card : Fully approved_DataCard1
Default = ThisItem.'Fully approved'
Toggle: FullyApprovedToggle
On one of my screens, I added a Gallery, source is the same SP list. Here I want to display only those items that aren't fully approved yet, so where I assume FullyApprovedToggle.Value = False.
When adding the fields in the Gallery, I add the field Fully Approved, which is added as ThisItem.'Fully approved'
I want to create a filter on Gallery Items level, the closest I get is:
Filter('TA Shipment REQ2', !'Fully approved')
Which works but gives me an alert:
Delegation warning. This part "Filter" of this formula might not work correctly on large data sets.
Can I improve my filter so I don't get this warning anymore?
All help would be appreciated!
Jimmy
Solved! Go to Solution.
Hi @jimmydebie ,
Please use Filter('TA Shipment REQ2', 'Fully approved' = false) instead. OData doesn't recognize '!' within the filter which as a result turns the query into non delegable. The warning should disappear by doing that 🙂
Please remember to mark the answer as a verified solution if the reported behavior is resolved!
Best regards,
Filipe Relvas
Hi @jimmydebie ,
Please use Filter('TA Shipment REQ2', 'Fully approved' = false) instead. OData doesn't recognize '!' within the filter which as a result turns the query into non delegable. The warning should disappear by doing that 🙂
Please remember to mark the answer as a verified solution if the reported behavior is resolved!
Best regards,
Filipe Relvas
User | Count |
---|---|
184 | |
122 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
130 | |
85 | |
78 |