Answered

Multiple filter in ODATA in List rows present in a table Others

(1) Share

Report

Posted on by Yi66

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.

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Hello @Yi66 ,
Here a simple example:

@or(equals(item()?['project phase'], ''),equals(item()?['project phase'], 'closed'))

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

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

be aware, you’ve to put it in the filter array in advanced mode

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

I got a error :
Flow save failed with code 'WorkflowRunActionInputsInvalidProperty' and message 'The 'inputs' of workflow run action 'Filter_array' of type 'Query' is not valid. Property 'where' must be a template language expression.'.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No