Unanswered

Merge two array into one array

(0) Share

Report

Posted on by NeohLooi

I have the flow which getting two set of data from two table and I want to merge two into a single array. Both of them have one common primary key which is Item Type.

For left hand side, I get all row which Item Type equal to Book, it will return all Book data, same goes to right hand side.

I want combine both array into single array for each row return from both table, I tried union but it seem not working in my case.
Any solution on my problem here? Any help will be great.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report

@NeohLooi I found a similar thread here :

https://powerusers.microsoft.com/t5/General-Power-Automate/Append-to-Array-Variable-action-is-not-working/td-p/331436

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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

Like (0)

Report

See https://powerusers.microsoft.com/t5/Building-Flows/Merging-arrays/td-p/386279

Was this reply helpful? Yes No
NeohLooi 73 on at

Like (0)

Report

After I tried on the solution....it seem like just assign the value to array variable...I tried the output is not merge....
Or it have different way to do it in my current scenario?

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

Are you looking to merge columns from 2 tables or to just append one table to another?

Was this reply helpful? Yes No
kgreen8790 189 on at

Like (2)

Report

I had a similar issue and had to use "select" connector for each table to map keys then I could union the outputs from the "select" connectors in "compose" connector.

Was this reply helpful? Yes No
AlexandrePicque 74 on at

Like (1)

Report

Hi,

I had two tables to join in one of my flows too and I used the "union" function to join my two tables.
I don't know if this is what you were looking for.

2023-04-19_16h51_...

Was this reply helpful? Yes No