Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Filter will not filtering properly with Sharepoint list boolean value

Hi, I have something of an odd situation. I'm trying to setup my BrowserGallerie's Data Filter so that it is delegated. I have a Yes/No (boolean value) item in a sharepoint list (Task Completed) that I am trying to filter on. However, when using the only delegation method, according to this list:, I have available to me (=) it isn't working.


For example. I have a view where I want to see recently completed tasks so for the filter part I am trying to use Filter('Task List', Task_x0020_Completed = true) however it does not show tasks that are completed but rather only those that are not completed. It seems to only provide results that are false rather than true and I can't seem to figure out why. Does anyone have any idea why this is happening?

Frequent Visitor

I have the same issue with true/false and 1/0 and the filter not working or working accordingly.  While using a collection does work, I don't consider this as a solution so much as a workaround to the real issue.  This definitely still needs to be fixed.  I can't believe it's more than a year after the issue was first reported and it remains an issue.

Frequent Visitor


I'm facing the same issue. When using Filter(SP list, field=true), and SP column is yes/no, the filter does not work.

Using field=0 or 1 does not work too.

Using a 1/0 works in my case too. Otherwise I'd be stuck. I hope there is a fix coming that enables filter to work with columns containing boolean values.

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,371)