Filter Array with Multiple Conditions is one of the most useful techniques for automating tasks in Power Automate. Whether you’re sorting tasks, filtering emails, or processing form responses, understanding how to apply multiple logical conditions (like AND, OR, or both) is crucial.
In this effortless guide for beginners, we’ll explore 3 powerful ways to filter arrays in Power Automate using multiple conditions:
- Two AND conditions
- Two OR conditions
- Combined AND + OR conditions
Let’s get started!
🧪 What Is a Filter Array?
In Power Automate, the Filter Array action allows you to filter the items in a list (array) based on specific conditions. This is often used when working with dynamic content such as emails, SharePoint lists, or Excel rows.
By using a Filter Array with Multiple Conditions, you can narrow your results using logic such as:
- Only return rows where status = “Approved” AND amount > 100
- Or fetch data where city = “London” OR city = “New York”
📘 Sample Data
For this tutorial, we’ll use the following array of users:
[
{ "name": "Alice", "city": "New York", "amount": 150 },
{ "name": "Bob", "city": "Los Angeles", "amount": 90 },
{ "name": "Charlie", "city": "New York", "amount": 200 },
{ "name": "Diana", "city": "Chicago", "amount": 50 }
]
We’ll filter this array using three different combinations of logic.
🔧 How to Set Up the Filter Array in Power Automate
- Create a new instant cloud flow in Power Automate.
- Add a step: Initialize Variable
- Name:
Users - Type: Array
- Value: Paste the sample JSON above
- Name:
- Add the Filter Array action
- From:
variables('Users') - Use Advanced Mode to enter expressions
- From:
✅ 1. Filter Array with Two AND Conditions
Filter users who:
- Live in New York
- AND have an amount > 100
➤ Expression:
and(
equals(item()?['city'], 'New York'),
greater(item()?['amount'], 100)
)
- Click in the Filter Query textbox, then click the fx icon and paste the expression above into the textarea in the popup.
- then click on Add button
🎯 Expected Output:
[
{ "name": "Alice", "city": "New York", "amount": 150 },
{ "name": "Charlie", "city": "New York", "amount": 200 }
]
This is a classic use case of Filter Array with Multiple Conditions using logical AND.
✅ 2. Filter Array with Two OR Conditions
Filter users who:
- Live in Chicago
- OR have an amount < 100
➤ Expression:
or(
equals(item()?['city'], 'Chicago'),
less(item()?['amount'], 100)
)
🎯 Expected Output:
[
{ "name": "Bob", "city": "Los Angeles", "amount": 90 },
{ "name": "Diana", "city": "Chicago", "amount": 50 }
]
This example shows how to use Filter Array with Multiple Conditions when either of the conditions should be true.
✅ 3. Filter Array with AND + OR Combined
Filter users who:
- (Live in New York AND amount > 100)
- OR (Live in Los Angeles AND amount < 100)
➤ Expression:
or(
and(
equals(item()?['city'], 'New York'),
greater(item()?['amount'], 100)
),
and(
equals(item()?['city'], 'Los Angeles'),
less(item()?['amount'], 100)
)
)
🎯 Expected Output:
[
{ "name": "Alice", "city": "New York", "amount": 150 },
{ "name": "Bob", "city": "Los Angeles", "amount": 90 },{ "name": "Charlie", "city": "New York", "amount": 200 }
]
This is a more advanced but incredibly useful way to apply multiple condition types in one filter.
🧠Pro Tips for Beginners
- Use the Advanced Mode of Filter Array to write complex logic.
- Test your expressions with the Compose action to preview filtered results.
- Add a Compose action. In the Inputs field, insert the Body output from the Filter array step by clicking the lightning bolt icon. Then click Test to run the flow.
- After the flow runs, click on Compose and view the results in the OUTPUTS section on the left side.
- Always start with simple conditions, then build on them.
🎯 Final Thoughts
Learning how to use a Filter Array with Multiple Conditions can make your flows smarter and more dynamic. Whether you’re filtering SharePoint lists, emails, or Excel data, applying logic like AND, OR, and combinations of both is a fundamental skill.
Keep this guide handy as a quick reference. Once you master this, you’ll be well on your way to becoming a Power Automate pro.