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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

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.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,902)