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
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
186 | |
53 | |
50 | |
36 | |
34 |
User | Count |
---|---|
270 | |
91 | |
82 | |
76 | |
75 |