How to Filter SharePoint Yes/No Columns in Power Automate with OData Filter Queries 理由

I was asked how to filter a “Yes/No” column in SharePoint using the “Get items” action in Power Automate, so here are my notes.

Objective

This is about how to filter a SharePoint list in Power Automate when it contains a “Yes/No” (Boolean) column like in the image below.

Since the “Yes/No” column seems to behave like a Boolean, you might try to filter using true or false. However, this doesn’t work as expected.

For example, if you try to filter the SharePoint list above using false,

it looks like the filter is working properly,

but if you filter with true,

you get the same results.

If you want to filter a “Yes/No” column in a SharePoint list, use the integer values 0 or 1 in your filter query.

For example, if you want to list only the rows where the “Yes/No” column is “Yes,” write your filter query using 1 as shown below:

This will filter only the rows where the Yes/No column is “Yes”:

Similarly, if you filter with 0, you’ll get only the rows where the value is “No”:

If you want to filter for anything except “Yes,” you can use “ne 1” in your filter formula, as shown in the image below:

This will filter out all rows except those with “Yes”:

For more details about writing filter queries, check out this article: