web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Merge multiple arrays ...

Power Automate

Unanswered

Merge multiple arrays into an array

(0) Share

Report

Report

Posted on by lzh_0319

4

Dear readers,

I met a problem with the above problem. My initialize array is :

[

{

"Description": [

"Half day training - Microsoft Office",

" 'Fish out of Water: Finding Your Brand",

" Half day training - Microsoft Office"

],

"Quantity": [

"1",

"1",

"3"

],

"UnitAmount": [

"500",

"25",

"500"

]

}

]

For the above, having three arrays (Description, Quantity & UnitAmount). How to merge the three array into an array (Array Name: InputArray)

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @lzh_0319 ,

Please try this expression:

[ { "Description": "@{replace(replace(replace(replace(split(triggerBody()?['text_2'],','),'\',''),'"',''),'[',''),']','')}", "Quantity": "@{replace(replace(replace(replace(split(triggerBody()?['text_4'],','),'\',''),'"',''),'[',''),']','')}", "UnitAmount": "@{replace(replace(replace(replace(split(triggerBody()?['text_5'],','),'\',''),'"',''),'[',''),']','')}" } ]

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
lzh_0319 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft ,
Thank you for your reply. I think is my explanation has something wrong. My preferred output is:
"value": [
{
"Description": "Half day training - Microsoft Office"
"Quantity": 1
"UnitAmount": 500
}

{
"Description": 'Fish out of Water: Finding Your Brand\"
"Quantity": 1
"UnitAmount": 25
}

{
"Description": Half day training - Microsoft Office
"Quantity": 3
"UnitAmount": 1500
}
Best Regards
LZH

Was this reply helpful? Yes No

Join the conversation