Filter in Gallery based on toggle value from SharePoint list

[jimmydebie]

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

[FilipeRelvas · Accepted 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

[jimmydebie]

Thanks @FilipeRelvas , this solved my issue.