Multiple filter query condition

[Prathameshpatka]

Hi,

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 !

[Mira_Ghaly · Accepted solution]

@Prathameshpatka

Can u try removing the brackets () between the OR conditions

[Prathameshpatka]

@Mira_Ghaly 

Tried without brackets but still considers only first two conditions :

[Mira_Ghaly]

@Prathameshpatka 

Can you share how var_sub90days looks like?

Is this an ODATA filter for Sharepoint List Items?

[Prathameshpatka]

@Mira_Ghaly 

The flow looks like below :

The expression has a formula : 

formatDateTime(addDays(utcNow(),90), 'yyyy-MM-dd')

Yes it is a ODATA filter. I am trying to send an email when the expiry date is 30, 60 or 90 days from today. The filter is set on a Sharepoint list and is a scheduled workflow.

[Mira_Ghaly]

@Prathameshpatka 

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

[Prathameshpatka]

@Mira_Ghaly 

Should converting the time zone resolve the issue with filter query not picking up the 3rd condition ?

[Mira_Ghaly]

@Prathameshpatka 

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

[Prathameshpatka]

@Mira_Ghaly 

The flow history looks fine it is just that it picks up only two conditions which is frustrating !

[Mira_Ghaly]

@Prathameshpatka

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?