Filter Query not working as expected with multiple AND conditions

(0) Share

Report

Posted on by Community Power Pla...

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'

All responses (2)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Re: Filter Query not working as expected with multiple AND conditions

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

tom_riha 10,127 Most Valuable Professional on at

Like (1)

Report

Re: Filter Query not working as expected with multiple AND conditions

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.