Loop through an array by a value in another array to create a different array

(0) Share

Report

Posted on by Cgangweg01

727 Super User 2025 Season 2

Hello -

I've tried different 'apply to each' scenarios without luck for the following.

I want to loop through array 1 by zone using value zone number in array 2 and create array 3.

Array 1

[
{
"Zone": "1",
"LookUpStr": "25"
},
{
"Zone": "2",
"LookUpStr": "35"
},
{
"Zone": "3",
"LookUpStr": "80"
},
{
"Zone": "4",
"LookUpStr": "45"
},
{
"Zone": "5",
"LookUpStr": "157"
}

]

Array 2

[
{
"Zone Number": 2
},
{
"Zone Number": 3
},
{
"Zone Number": 4
}
]

Array 3 created by flow

[

{
"LookUpStr": "35",

"LookUpStr": "80",

"LookUpStr": "45"
}

]

Appreciate any suggestion.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Cgangweg01

Try this approach without using loop :)

1. use 2 initialize variables to initialize array 1 and array 2 as shown below

2. use compose action to format the Array 2 as shown below

3. Use filter array to get required values

Expression:

xpath(xml(outputs('Format_Array2')),concat('//Zone_x0020_Number/text()=','''',item()?['Zone'],''''))

4. use select action to select LookUpStr property from output of filter array

see the output of select action

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (0)

Report

Thank you! @Nived_Nambiar

That worked! I was even able to use the output in an apply to each to make an API call per LookUpStr number. Awesome! Now I need to figure out how to compile each API call result into a single array for further filtering.

Also wondering ... could you explain what the xpath expression is actually doing?

xpath(xml(outputs('Format_Array2')),concat('//Zone_x0020_Number/text()=','''',item()?['Zone'],''''))

Thanks Again!

Was this reply helpful? Yes No