Filter Query not working as expected with multiple AND conditions

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

The filter query in this flow doesn't appear to be working as expected. I know for certain that the items it emails out afterwards have the first two toggles set to false. Is there something in the syntax that I'm missing? Or possibly in the date/time comparisons? This is my first dive into Power Automate, and its with someone elses flow. So any insight is greatly appreciated.

This is an example of what it looks like after running, and getting items where Confirmed = false.

Thank_x0020_You_x0020_Sent eq 'false' and Confirmed eq 'true' and EventDate lt '2021-07-20T00:00:00.0000000' and EventDate ge '2021-07-19'

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello @Anonymous ,

if the first two columns are Yes/No columns then you should compare them with 0 (for false) and 1 (for true) in the condition.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I don't know how that slipped past me. Thank you!

Was this reply helpful? Yes No