Filter Query not working as expected with multiple AND conditions

Like (0) Share

Report

Posted on 19 Jul 2021 20:34:56 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'

I have the same question (0)

All responses (2)

Answers (1)

Community Power Pla... on 20 Jul 2021 at 15:14:05

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!

Was this reply helpful? Yes No
Verified answer

tom_riha 10,149 Most Valuable Professional on 19 Jul 2021 at 21:18:17

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.

Was this reply helpful? Yes No