How to combine two array variables into 2D Array

[leighp]

Hello,

I have not found anything similar to this. I am trying to combine two array variables into one 2D array, like the following.

Instead of coming out like this:

Col1      Col 2

X

X

X

               X

               X

               X

I want to combine my columns to come out like this

Col1      Col 2

X           X

X            X

X            X

Is there a way to do this?

[v-yujincui-msft · Accepted solution]

Hi @leighp ,

If the two arrays do not have a one-to-one corresponding unique identifier column but the array lengths are the same. Maybe you could try as follows: 

items('Apply_to_each')?['Col1'] 

variables('vararray2')[variables('varindex')]?['Col2'] 

{ 
  "Col1": @{items('Apply_to_each')?['Col1']}, 
  "Col2": @{variables('vararray2')[variables('varindex')]?['Col2']} 
} 

Result Screenshot: 

Best Regards, 
Charlie Choi