News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Combining two or more ...

Power Automate - Building Flows

Answered

Combining two or more different arrays into one

(1) Share

Report

Report

Posted on by SBS

78

Hi,

I would like to combine multiple different arrays into one. I have for example the following two arrays:

["123","456","789","987"]

["John","Patrick","Simon","Bill"]

I would like to have the following:

[

{

"no":"123",

"name":"John"

},

{

"no":"456",

"name":"Patrick"

},

{

"no":"789",

"name":"Simon"

},

{

"no":"987",

"name":"Bill"

}

]

Thanks!

All responses Img

All responses (3)

Answers Img

Answers (2)

nzacharakis 105 on at

Like (0)

Report

Re: Combining two or more different arrays into one

Excellent solution! Very helpful, thank you 😀
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Combining two or more different arrays into one

Hi @SBS ,

Assuming the number of elements in the two arrays is equal, you can refer to the Flow in the attachment to achieve your needs.

You can import attachments to see the details of the Flow configuration.

Please take a try.

Best Regards,

ArrayTest_2020011...
Verified answer

abm abm 32,472 Most Valuable Professional on at

Like (2)

Report

Re: Combining two or more different arrays into one

Hi @SBS

Follow the below steps.

Above expressions are as follows:

(1) For the do until loop expression is

length(variables('Id'))

(2) Append to String variable 2

variables('Id')[variables('index')]

variables('Names')[variables('index')

(3) Finally the condition

length(variables('Id'))

Final flow action outside the do until loop

Here is my final test result

If you have any questions please let me know.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans