How do I ensure the that filter query pickups all the 3 conditions mentioned as I have done a test and it picks up only the first two !
Solved! Go to Solution.
The flow looks like below :
The expression has a formula :
Your flow and expression looks just fine! the only thing i do suspect here is using utcNow(), I suggest converting the UTCnow() to your local timezone, Using convertFromUtc
It might fix the issue or not .. It is the only thing i believe can be the cause of the issue
Did you check flow history for your run to see how this variable look? so you can understand why it is not picking
It looks fine and also it does make sense it is working for first 2 and not the third, if u moved the last condition to the beginning does it pick it up?