Power Automate

Merge/union 2 arrays

(1) Share

Report

Posted on by VM-31030826-0

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,073 on at

Like (0)

Report

Well, please share your flow.

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

Like (0)

Report

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

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

Like (0)

Report

No flow - no help.

Was this reply helpful? Yes No
Suggested answer

takolota1 4,974 Moderator on at

Like (0)

Report

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