Answered

Group/join/merge content from one array based on unique key in a new array

(0) Share

Report

Posted on by CH-22072116-0

Hi Forum,

I have been reading a lot and found several similar post but with multiple arrays. In my case I'm looking for a Power Automate flow that have only one array that I want to clean and group based on a unique id.

My array: (every time 2 periods per unique id)

[
{
"id": "770",
"period": "2023-05",
"count": "12"
},
{
"id": "770",
"period": "2023-06",
"count": "13"
},
{
"id": "2027",
"period": "2023-05",
"count": "64"
},
{
"id": "2027",
"period": "2023-06",
"count": "72"
}
]

My expected result:

[
{
"id": "770",
"2023-05": "12",
"2023-06": "13"
},
{
"id": "2027",
"2023-05": "64",
"2023-06": "72"
}
]

Thank you very much in advance for the help

Cheers

Chris

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

lbendlin 8,716 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Your expected result is not in a good format. Would be better like

[ { "id": "770", "items":[{"period": "2023-05","count": "12"}, {"period": "2023-06","count": "13")] }, { "id": "2027", "items":[{"period": "2023-05","count": "64"}, {"period": "2023-06","count": "72"}] } ]

Would that be acceptable?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChrisBI ,

I made a sample for you.

"@{items('Apply_to_each_2')?['period']}":"@{items('Apply_to_each_2')?['count']}",

"{@{variables('var2')}"id":@{items('Apply_to_each')}}"

json(slice(outputs('Compose'),1,add(length(outputs('Compose')),-1) ))

Best Regards,

Wearsky

Was this reply helpful? Yes No
CH-22072116-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi lbendlin,
Thank you soo much for your feedback, unfortunately I need one level... can't work with embedded arrays.
The solution from v-xiaochen-msft works fine !

Thanks

Was this reply helpful? Yes No
CH-22072116-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Wearsky,

Amazing solution! I was going in the right direction, until For Each 2 I did exactly what you did. Then I started struggling... you really helped a lot and pointed me in the right direction. That JSON(SLICE I would never have found out about it...

Thank you soo much for helping me out so quickly.

Have a nice weekend
Chris

Was this reply helpful? Yes No