Filter Array to find Single Data Attribute from Array Variable

(0) Share

Report

Posted on by pp365

439 Season of Giving Solutions 2025

Hi everyone,

This is probably quite an easy one to resolve but I'm wasting quite a lot of time trying to understand where the issue is and would really appreciate some help.

I have set up an Array variable, 'varArray'. Inside this is a set of records, each with two attributes, Attribute1 and Attribute2.

I have a String variable, 'varString1'. Inside this is a string which will match the Attribute2 value of one record in varArray.

I have set up an Apply to Each using the value of varArray.

Inside the Apply to Each I have set a Filter Array action to try to 'filter' varArray, when 'Attribute2' contains 'varString1'. I am not sure this is the correct implementation to achieve what I need and need some help understanding if there are any pre-actions required, and/or how to correctly complete the fields in the Filter Array.

I want to then set another variable which contains the output of the filter query (returning Attribute1) and need to understand what expression to use for this.

I have had a series of errors, or, the filter query will return a null output even though there is definitely a match between Attribute2 and varString1, and tried to correct various aspects of the filter query but I'm not sure where the problem lies so any assistance would be much appreciated. Many thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@pp365 This YT Tutorial might help you better understand how to use the Filter Array action: Are you using the Microsoft Power Automate Filter Array Action wrong

I cover how to cross-reference one array with another in the first section of the tutorial.

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
pp365 439 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion , thanks for getting back to me.

I appreciate the response but to be honest I didn't find the video useful. I wanted to feedback in case it's helpful for any future videos you might produce. The pace of delivery was too fast, the explanations weren't clear and I found the 'AI voice' to be somewhat off-putting. For good Power Platform videos, have a look at Shane Young, Reza Dorani, etc, as they have mastered the format of these.

In the end my issue was just a misunderstanding of the use of the Array. The solution was to use the Parse JSON action after the array to get the array field that I needed.

I really appreciate your response though and hope the feedback may be helpful.

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

Like (0)

Report
Copy link

Link copied!

@pp365 Thanks for your feedback. I'm sorry to hear that the video didn't meet your expectations. It's actually not an AI voice but my own. I try my best to make my content as accessible and useful as possible, so I appreciate your honesty regarding how it came across to you.

It's important to me that my content is helpful and engaging for everyone, and feedback like yours is crucial in guiding those improvements. Thanks again for your input, and I hope my future videos will be more aligned with what you're looking for.

Have a wonderful day.

Was this reply helpful? Yes No