Combining 3 arrays

(0) Share

Report

Posted on by daveedd

Hi all,

I've come towards the end of my flow and the end result is 3 arrays - the Serial, IMEI and IMEI2 numbers of devices.

While there is no common field I know the row order is correct. IE item1 in each array will be referring to the same device.

All I want to do is combine the 3 arrays into a single array as 3 fields in the order they sit in. If I was doing this in Excel I would simply copy and paste the 3 arrays in columns next to each other.

Screenshot 2022-02-28 at 15.03.47.png

I've looked around but I just can't quite get it right. Any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

MJain 2,450 on at

Like (0)

Report

Hi @daveedd ,

You may want to view this :

https://sharepains.com/2021/01/15/add-a-column-to-an-array-power-automate/

Thanks

Was this reply helpful? Yes No
daveedd 12 on at

Like (0)

Report

Hi @ManishJain yeah I looked through that yesterday before posting. I took one of the 3 and tried to put the others with it, only it would add the entire second array to every value in the first.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

The Result:

Best Regards,

bof

Hi @daveedd :
I've made a test for your reference:

Was this reply helpful? Yes No
daveedd 12 on at

Like (0)

Report

@v-bofeng-msft amazing thank you

Was this reply helpful? Yes No