cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnB2
Helper I
Helper I

Filter array "Or" not returning any value

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'))

 

 

JohnB2_0-1663680634293.png   JohnB2_1-1663680663355.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

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'))

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

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'))

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


JohnB2
Helper I
Helper I

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,001)