web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Merge two Arrays with ...

Power Automate

Answered

Merge two Arrays with common ID

(0) Share

Report

Report

Posted on by svivek

65

Hi,

I saw one you tube video to merge two arrays with common ID and created following flow. However Ia m getting error. Pls advcie where am I going wrong or if there is any easier method available to get the same result it will be very much appreciated.

You Tube: https://www.youtube.com/watch?v=QSF6dNkSKSA&list=LL&index=3

I need to merge following arrays:

Array 1:

[

{

"Parameter": "2A",

"No Match Array 1": "40"

}

]

Array 2:

[

{

"Parameter": "2A",

"No Match Array 2": "80"

}

]

I require final array as

[

{

"Parameter": "2A",

"No Match Array 1": "40"

"No Match Array 2": "80"

}

]

For this I created following flow. Here both arrays are coming from select operation:

However I am getting following error . Pls advice where am I going wrong.

Categories:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @svivek ,

I have made a simple test for your reference.

Here is my Flow.

item()?['Parameter']
items('Apply_to_each')?['Parameter']
items('Apply_to_each')?['No Match Array 1']
first(body('Filter_array'))?['No Match Array 2']
{ "Parameter": @{items('Apply_to_each')?['Parameter']}, "No Match Array 1": @{items('Apply_to_each')?['No Match Array 1']}, "No Match Array 2": @{first(body('Filter_array'))?['No Match Array 2']} }

Result Screenshot:

Best Regards,
Charlie Choi

Join the conversation