Answered

Filter an Array with Multiple Condition that are Dynamic Values

(0) Share

Report

Posted on by Trent92

Good afternoon all,

I am trying to build a flow that pulls the flattened organisation structure from a PowerBI report and I want to find the first row that a person (from a dynamic value) appears in as that can then be used in further PowerBI queries. I have extracted the data from the BI dataset and have it in an array, but I'm having trouble then filtering it out to get the first time that the person appears. The filter array function lets you have multiple conditions, and dynamic values, but seemingly not both at the same time.

Any help would be appreciated.

With my filter function being:

@Anonymous(

contains('ManagerHierarchy[Level 1]', items('Apply_to_each')?['Title']),

contains('ManagerHierarchy[Level 2]', items('Apply_to_each')?['Title']),

contains('ManagerHierarchy[Level 3]', items('Apply_to_each')?['Title']),

contains('ManagerHierarchy[Level 4]', items('Apply_to_each')?['Title']),

contains('ManagerHierarchy[Level 5]', items('Apply_to_each')?['Title']),

contains('ManagerHierarchy[Level 6]', items('Apply_to_each')?['Title']),

contains('ManagerHierarchy[Level 7]', items('Apply_to_each')?['Title']),

contains('ManagerHierarchy[Level 8]', items('Apply_to_each')?['Title'])

)

All I receive is a blank array despite being able to search for the two Managers names in the inputs section.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Ellis Karim 11,994 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Trent92 ,

Looking at your sample data:

Can you try the following format in your filter query:

contains(item()?['ManagerHierarchy[Level 1]'], items('Apply_to_each')?['Title']), contains(item()?['ManagerHierarchy[Level 2]'], items('Apply_to_each')?['Title']), ...

See:

Item() and Items(Apply to each) Functions Explained with Examples

How to Query JSON Data Using JSON Notation with Power Automate❔❔❓

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Trent92 13 on at

Like (0)

Report
Copy link

Link copied!

That has resulted in an error:

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,994 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Trent92 ,

OK, I see what is happening here. For the contains() function to work your data must include all the ManagerHierarchy levels, they cannot be empty or missing. And this is what is causing the error.

The following format would likely work:

[ { "ManagerHierarchy[Level1]": "Demo123", "ManagerHierarchy[Level2]": "#", "ManagerHierarchy[Level3]": "#", "ManagerHierarchy[Level4]": "#" }, { "ManagerHierarchy[Level1]": "Demo 32", "ManagerHierarchy[Level2]": "SDS2", "ManagerHierarchy[Level3]": "#", "ManagerHierarchy[Level4]": "#" }, { "ManagerHierarchy[Level1]": "Demo 1", "ManagerHierarchy[Level2]": "SDS2", "ManagerHierarchy[Level3]": "demo 4", "ManagerHierarchy[Level4]": "demo 5" } ] ]

Or do you have a way concatenate all the Manager Hierarchy into a single strings?

[ { "ManagerHierarchy[Level1]": "Demo123", "ManagerHierarchy[Level2]": "ABC", "ManagerHierarchy[Level3]": "12345", "ManagerHierarchy[Level4]": "zxcxc" }, { "ManagerHierarchy[Level1]": "Demo123" } ] to [ { "ManagerHierarchy": "Demo123, ABC, 12345, zxcxc"}, { "ManagerHierarchy": "Demo123"} ]

That way you may be able to use a single contains action: contains( item()?['ManagerHierarchy]), items('Apply_to_each')?['Title'])

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
Trent92 13 on at

Like (0)

Report
Copy link

Link copied!

I concatenated the array and it now filters properly.

Thank you for the help!

Was this reply helpful? Yes No