Field name error in Filter Query

[PaulRobbo1]

Hi. I have a Recurring Flow in Power Automate that runs each morning at 6am. It is based on a calculated date field 7 days from the created date of the list item. I have tried to add a filter query so that only items past 7 days old will be returned but I get the following error message and the run fails: 

This is the field name

this is what it looks like in the list:

and this is what it looks like in the settings:

This is what I put in the filter:

This is the run fail:

If I leave the filter Query out it runs ok but I then have a condition that doesn't appear to work properly. I want it to send an email depending on if a person has been assigned to the query or not and if the status still shows as 'New'

The 'If No' runs ok but the 'If Yes' doesn't work at all. Is 'Null' an acceptable term in this condition? 

Thanks for any help

[niklasjegg]

Hello @PaulRobbo1  im not sure but i think you can´t use calculated fields here.

Maybe you would be better off to Calculate your Date column again from the Created date in the Filter query. 

[PaulRobbo1]

Thanks for the reply and yes you are correct, calculated fields can't be used. I have found an alternative option using a Filter Array and that appears to work.

My issue now is the flow runs and succeeds but this condition always fails even if the Status is Completed, it still sends an email.

Any idea what i'm doing wrong?

[niklasjegg]

@PaulRobbo1  is your Status column a Choice Column?

[PaulRobbo1]

Yes it is, New, In Progress or Completed.

[niklasjegg · Accepted solution]

@PaulRobbo1  then please do not use the "Status" but rather use the "Status Value" expression. 

[PaulRobbo1]

Great, thank you that worked. Can I ask one other thing please?

I have a Condition that asks for a forensic discipline value containing a number of options, again from a drop down. It appears that the flow bypasses these, there are 4, and goes straight to the last option, can you see an issue with what I have in the condition? Does 'Contain' work or should it be equal to?

[niklasjegg]

is your condition inside the Apply to each loop or outside?

Contain should do it yeah

[PaulRobbo1]

Yes inside.