Filter array using OR expression

(1) Share

Report

Posted on by sausage_dog

Hi there,

I am using a filter array like below (the filter condition on the left hand side is an integerr value)

this is the left hand side's expression -

item()?['Streets']?[0]?['Id']

I want to filter the array to where this value is 1 or 3. So I have tried the below in the right hand side but the flow fails

or(1,3)

It givess the fail reason as

The execution of template action 'Filter_array_4' failed: The evaluation of 'query' action 'where' expression '@equals(item()?['Streets']?[0]?['Id'], or(1, 3))' failed: 'The template language function 'or' expects all of its parameters to be booleans. Found invalid parameter types: 'Integer'.'.

Any ideas what i might be doing wrong here?

thank you

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

@sausage_dog Although it may look like the Filter Array action can only take a single condition—it can take multiple conditions when using the Advanced Editing Mode.

Refer to this section of this YT tutorial linked below for how to add multiple conditions to a Filter Array action.

To learn more about how to use the Filter Array action, please refer to this YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
sausage_dog 63 on at

Like (1)

Report
Copy link

Link copied!

Thank you - i will check this out...

but in advanced mode... what would my condition be here for 1 OR 3 as an integer?

thank you

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

@sausage_dog As you'll see in the tutorial use the basic editor to get the expressions you need. Start with replacing the value entered into the second value field with an integer of 1. You'll need use an expression and wrap the number in the int() function.

Switch to the Advanced Mode to get the expression. Use a text editor to compose your expression as the advanced editor is really buggy.

I cover step by step how to compose the expression in the tutorial.

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
You have to do 2 comparisons:

@Or( equals( item()?['Streets']?[0]?['Id'], 1 ), equals( item()?['Streets']?[0]?['Id'], 3 ) )

You also could do just this:

createArray(1,3) contains item()?['Streets']?[0]?['Id']

Was this reply helpful? Yes No