Power Automate

Merge/union 2 arrays

(1) Share

Report

Posted on by VM-31030826-0 Microsoft Employee

I am working on a power automate flow and I have 2 Array variables/Compose

Array 1 =

[

{

user: userA,

var111: 20

{

user: userB,

var111: 30

]

Array 2 =

[

{

user: userA,

var222: 30

{

user: userC,

var222: 30

]

output array should be InnerJoin/union on common key "user" and also fill gaps , combine all users and make count=0 if not available in other array (check UserB in below array)

Output Array =

[

{

user: userA,

var111: 20

var222: 30,

{

user: userB,

var111: 30,

var222: 0

{

user: userC,

var111: 0,

var222: 30

]

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Well, please share your flow.

Was this reply helpful? Yes No
VM-31030826-0 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have 2 basic variable of type array defined with the value specified above (Array1, Array2)

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

No flow - no help.

Was this reply helpful? Yes No
Suggested answer

takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you want to merge json arrays efficiently you will either need...
(Non-premium) XML: https://tachytelic.net/2022/07/power-automate-merge-array/

(Premium) Azure Functions: https://medium.com/@takolota/power-automate-upsert-json-array-dfa937d800be

Was this reply helpful? Yes No