cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Filter in Gallery based on toggle value from SharePoint list

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Filter in Gallery based on toggle value from SharePoint list

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

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Filter in Gallery based on toggle value from SharePoint list

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

View solution in original post

Highlighted
Regular Visitor

Re: Filter in Gallery based on toggle value from SharePoint list

Thanks @FilipeRelvas , this solved my issue.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,959)