Announcements
I want to applied multiple filters in my flow, there all "Or". Then I got this error:
Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.
@Yi66 Currently Excel connector does not support multiple conditions in filter query. use filter array after List row present in a table and use multiple conditions.
Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.
@Hardesh /Gopenly.in
Hello @Yi66 ,
unfortunately is not possible to put multiple conditions in the Filter Query.
You should use, after the "Filter rows present in a table", the "Filter Array" action, like what's mentioned in the following post:
https://powerusers.microsoft.com/t5/Building-Flows/Filter-Query-with-multiple-filters-for-Flow/td-p/696775
If I have answered your question, please mark your post as Solved.If you like my response, please give it a Thumbs Up.
BR,
Marco
How do you do multiple "OR" condition in filter array ? I want to do more filter on the Director, when Director = A, or Director = B, etc
Here is only one example:
@equals('Director', 'ALL')
Here a simple example:
@or(equals(item()?['project phase'], ''),equals(item()?['project phase'], 'closed'))
Can I do this way :
@Anonymous(equals('Director', 'ALL')， equals('Director', 'Asset Protection')，equals('Director', 'Building Services')，equals('Director', 'HD Supply')，equals('Director', 'Merch Services')，equals('Director', 'Not Known')，equals('Director', 'Tool Rental')). If not, what is wrong with my syntax ?
be aware, you’ve to put it in the filter array in advanced mode
I got a error :
Hi @Yi66 ,
I suggest you change the column name 'Director' in the formula to item()?['Director'].
I have made a test for your reference:
1.
2.
3.
Best Regards,
Levi
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 791
Valantis 568
Haque 535
