Unanswered

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)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

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

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,436 Super User 2025 Season 2 on at

Like (2)

Report
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

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

Was this reply helpful? Yes No