Filter array "Or" not returning any value

[JohnB2]

Hi,

So I've scoured the forums and couldn't get an answer to my issue.

I have a simple flow set up to filter out specific values in a sharepoint list. The problem is, it is returning no data from the filter array when I use the 'Or' function. It will return data no problem when just searching for one particular value, but I need to search multiple columns.

I created a new flow from scratch, thinking it might be a glitch, and still the same

I cant for the life of me figure out what is wrong with the formula I am using. 

The data I am searching in the Sharepoint list is from a choice column.

The column names in the Sharepoint list have spaces. So, ive tried putting in and leaving out spaces.

I've double checked the correct column names from within the list settings.

@OR(equals(item()?['Coolantcheck'], 'Fail'),equals(item()?['Checkfuellevel'], 'Fail'))

   

[Expiscornovus · Accepted solution]

Hi @JohnB2,

I see you are using Choice columns.

Can you try this instead:

@OR(equals(item()?['Coolantcheck/Value'], 'Fail'),equals(item()?['Checkfuellevel/Value'], 'Fail'))

[JohnB2]

Thank you for that, it worked perfectly. I was thinking I was missing something simple.