How to Filter by a Boolean Column in Power Automate

Understanding Boolean Filters

Boolean data types represent two values: true or false. In Power Automate, when you need to filter data rows based on a Boolean condition, it's crucial to use the correct syntax to ensure accurate results. Here’s how you can apply this in different scenarios involving data operations like "List rows" or "Get items".

Configure the Filter Query:

In the "Filter Query" field, you need to input your condition. If you are filtering to find records where a Boolean field is set to true, you would use the following syntax:

YourBooleanFieldName eq true

Example:

Test Result: