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'))
Solved! Go to Solution.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!