You’re offline. This is a read only version of the page.
414
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!
@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.
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.
@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
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
