Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Outlook
    • Planner
    • Power Apps
    • SharePoint
    • Teams
  • Triggers
  • Ready to use solutions
    • Approval Process Solution
    • Task Delegation App
    • The Ultimate Power Automate expressions cheat sheet
    • Power Automate HTTP requests to SharePoint cheat sheet
    • Power Automate HTTP requests to Graph API cheat sheet
  • ABOUT ME
  • Get help with your flow
  • POWER PLATFORM SERVICES
Menu

Power Automate filter based on Yes/No (boolean) column

Posted on August 26, 2020January 6, 2022 by Tom

Does your Power Automate flow need to filter only flagged documents using Yes/No (boolean) column and ignore the rest?

Did you try all possible combinations in the filter query …column eq true, …column eq ‘true’, …equals(column, ‘true’)… but none of them works?


While SharePoint is displaying the values as ‘Yes’ or ‘No’ to the users, and as ‘true’ or ‘false’ on the background, to make a working filter on Yes/No (boolean) column in Power Automate you have to use numbers, Yes = 1, No = 0.

That means you must define the filter in the following format.

YesNo_column eq/ne 1
or
YesNo_column eq/ne 0
power automate filter yes/no boolean

Before I found this solution I had a lot of flows where the filtering was done after the Get items action. But moving the filter into the Get items action itself instead of using IF condition did simplify the flow, made it much faster and also much easier to debug when needed.

If also your flows have conditions like the one below, you too should consider optimizing them.


🚀 Master Power Automate

Join 2,100+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

8 thoughts on “Power Automate filter based on Yes/No (boolean) column”

  1. Matteo says:
    January 5, 2021 at 3:07 pm

    The solution i was looking for => Good article!

    Reply
  2. Carolyn says:
    October 8, 2021 at 5:16 pm

    Thank you! This was a surprise and I struggled to get my filter to work until reading this.

    Reply
  3. ganesh hon says:
    March 9, 2023 at 11:47 pm

    i have multiple columns of YES NO in same SharePoint lint that case filter query is not working.
    l am sending survey in YES / No option through Microsoft form, i am able to create item but when i used YES / No condition for email sending is not working.

    Reply
    1. Tom says:
      March 19, 2023 at 3:33 pm

      Hello ganesh,
      if it’s coming from MS Forms it comes as a text, not as a boolean – you should filter it using the text value.

      Reply
  4. Diego Gomez says:
    April 4, 2024 at 5:34 pm

    You are a genius!! Thanks!!!

    Reply
    1. Felipe de Abajo Aragón says:
      August 20, 2024 at 4:43 pm

      🙌🙌

      Reply
  5. Isaiah John says:
    September 10, 2024 at 4:10 pm

    I figured out how to do this for a SharePoint file.
    For your “Select” action, you need to put the fx fuction to convert the boolean data type to an integer.
    Format: int(item()[‘{IsFolder}’])
    This will convert it so “0” is false and “1” is true.
    Then, for the “Filter Array” action you must convert both values into an integer using the int() function.
    From: @{int(item().IsFolder)}
    Comparison: IS LESS THAN
    Value: @{int(1)}
    By checking if it is less than the integer “1”, you are checking if it is false.

    Reply
  6. Niklas Bendelius says:
    December 3, 2024 at 1:31 pm

    This. Thought I had gotten mad.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

🚀 Master Power Automate

Join 2,100+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

Still exchanging emails to get things approved?

Get the Approval Process solution and the Task Delegation App to skip the hard part and deploy an automated, fully functional approval solution on a SharePoint list in minutes! And then the next one, and the next one...

Approval Template Preview ✨ Learn more ✨

Turn ideas into flows with ease!

Grab the complete Power Automate Cheat Sheet Bundle—everything you need to master expressions, SharePoint HTTP calls, and Graph API in Power Automate.

Cheat Sheet Bundle Preview ✨ Get the Cheat Sheets

Didn't find what you were looking for?
Need to adjust a solution to fit your needs?
Or would you just like to get an assistance from somebody with thousands of hours of experience with Power Automate?

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2025 Let's POWER Automate | Theme by SuperbThemes