Fastest way to join single property of object array into a string

[Koenti007]

Hi,

I have an object array eg:

[

{"title": "10","label": "Label10"},
{"title": "11","label": "Label11"}
]

What is the fastest way (less actions the better) to obtain a string variable composed of all Label properties eg 'Label10,Label11'?

Thx!

[Paulie78]

Try this:

[Pstork1 · Accepted solution]

The best I can come up with is 2 actions (assuming you've already done a Parse JSON)

1) A data Select statement to create an Array with only the Label properties in it

2) A Compose that uses three nested functions.  A Join to create a String from the Array, then a Replace to remove the beginning of the record and key, and finally a Replace to remove the trailing record indicator.

Replace(Replace(join(body('Select'),','),'{"label":',''),'}','')

[radityoardi]

Your answer could've been perfect if you click at this button (red circle). It will replace the interface from "key-value" pair to direct value instead. And you don't need the next Compose action.

I have just found out this.

[Paulie78]

@radityoardi that’s what I showed in my answer. But perhaps I didn’t make it clear enough.