Advanced Filter syntax

(0) Share

Report

Posted on by UI-23111237-0

I am working on a Power Automate flow where I need to filter rows based on whether the values in a specific column match any value in a predefined array. Here's an example of what I am trying to achieve:

Column_Name: This column contains values like Value A, Value C, Value B, etc.
Array to Match: ["Value A", "Value B"]

I want to filter rows where Column_Name matches any value in the array ["Value A", "Value B"].

I tried using the eq operator, but I’m not sure how to make it work for multiple values in an array. Is there a way to use an OData filter query or an expression to achieve this in Power Automate?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,527 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Rows of what? Where does the data originate? Did you load it into an array?

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi,

If you are planning to do via Odata filter query, contains approach is not supported for array as you require. But there is another way you can try around using or approach, this will create or conditions dynamically based on array elements.

Assume you have a column name as FailedStation, I need to filter whether the column contains FS1 or FS2 in Sharepoint list. Refer how to do it as shown below:

1. Use select action to convert the array values to filter query syntax as shown below.

Expression -

concat('FailedStation eq ','''',item(),'''')

2. Use join function to join all the elements of select action using or delimiter as shown below

Expression- join(body('Select'),' or ')

3. Use the compose action's output in filter query field in get items action (if you are using sharepoint)

So when you run - you will see the result like this

So you can understand that how the array values can be converted to filter query.

Hope it helps !

Thanks & Regards,

Nived N

Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
Expiscornovus 33,374 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
With the same approach Nived shared you could also use a substringof function to check multi-valued choice type of fields.

1. The append to array variable action

substringof('@{item()}',Column_Name)

2. The OData filter

join(variables('ODataQuery'), ' or ')

Test result



Was this reply helpful? Yes No