Combine values with common ID into single value

(0) Share

Report

Posted on by robstewartnz

I have the following array:

[

{

"ID": "27",

"Value": "ICT|f7df09b2-e931-4a27-a2cc-975440062d12"

{

"ID": "27",

"Value": "ICT|f7df09b2-e931-4a27-a2cc-975440062d12;Quality and Safety|90ceaeb1-7dfb-466c-a292-532e9725a6eb"

}

]

I need to convert this array into a single object that I can append to another array, in the form of:

{

"ID": "27",

"Value": "ICT|f7df09b2-e931-4a27-a2cc-975440062d12;ICT|f7df09b2-e931-4a27-a2cc-975440062d12;Quality and Safety|90ceaeb1-7dfb-466c-a292-532e9725a6eb"

}

It doesn't matter that this contains a duplicate as Power Automate resolves this in a later step, but I do need to get all the options in a single value.

So far I've been mucking around with union/select/replace to try to achieve it but I'm out of my depth so would appreciate some guidance!

Cheers,

Rob

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Paulie78 8,424 Moderator on at

Like (1)

Report
Copy link

Link copied!
This may work for you (if I understand correctly):

The code on the left side of the filter array is:

length(split(item()['Value'], '|'))

All that is happening is any entry within the array that does not contain 3 values delimited by a pipe symbol in the value property is removed. Which leaves you with one entry in the array:

[ { "ID": "27", "Value": "ICT|f7df09b2-e931-4a27-a2cc-975440062d12;Quality and Safety|90ceaeb1-7dfb-466c-a292-532e9725a6eb" } ]

The the final compose just gets the first entry in the array which is your object.

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No