Answered

Combine elements of an array with a field in common

(0) Share

Report

Posted on by FP-22010922-0

Hello everyone,

I have following array (they are basically elements of a list in share point) in which some elements have the same "Revision":

{

"Revision": 123,

"Comment": first comment

{

"Revision": 123,

"Comment": second comment

{

"Revision": 456,

"Comment": first comment

{

"Revision": 789,

"Comment": first comment

}...

and so on.

Is it possible to combine all the elements having the same "Revision" by merging the comments? The deisred output, considering that two element feature the revision "123" would be:

{

"Revision": 123,

"Comment": first comment second comment

{

"Revision": 456,

"Comment": first comment

{

"Revision": 789,

"Comment": first comment

}

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

lbendlin 8,661 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I am sure there are more elegant ways

1. Select unique Revisions

2. For each revision find and join all comments

3. Stuff the results into the output array

Was this reply helpful? Yes No
FP-22010922-0 6 on at

Like (0)

Report
Copy link

Link copied!

Hello lbendlin,

thank you very much for your answer, however I am not able to reproduce your example, because some parts of the flow are missing in your screenshot (such as "Filter array").

Would you please be so kind to upload the flow?

Thanks you

Was this reply helpful? Yes No
Verified answer

Chriddle 8,685 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
From

union( xpath( xml(json(concat('{"Root":{"Item":', outputs('Compose'), '}}'))), '//Revision/text()' ), json('[]') )

Revision

item()

Comment

join( xpath( xml(json(concat('{"Root":{"Item":', outputs('Compose'), '}}'))), concat('//Item[Revision="', item(), '"]/Comment/text()') ), ' ' )

Was this reply helpful? Yes No
FP-22010922-0 6 on at

Like (0)

Report
Copy link

Link copied!

@Chriddle thank you very much for your proposed solution!!

Was this reply helpful? Yes No