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:

Business Process Flows

All responses (3)

Answers (0)

Expiscornovus 30,706 on at

Like (1)

Report
Advanced Filter syntax

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


Suggested answer

Nived_Nambiar 16,591 on at

Like (1)

Report

Advanced Filter syntax

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 !
lbendlin 7,847 on at

Like (0)

Report

Advanced Filter syntax

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