Power Platform Community Forum Thread Details

Extract value from JSON Array without using Apply To Each

Hello everyone,

I have a JSON that has the following format:

{
 "value": [
 {
 "title": "Title 1",
 "ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3",
 },
 {
 "title": "Title 2",
 "ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-1",
 },
 {
 "title": "Title 3",
 "ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-2",
 }
 ]
}

I used Data Operations - Select to extract the ID fields and now I have the following format:

[
 {
 "ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3"
 },
 {
 "ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-1"
 },
 {
 "ID": "9ee4ee0d-388a-4c87-8ff0-b2584eac42e3-2"
 }
]

I want to extract the values of all the IDs and return them as a string.

I have already managed to do so, using 'Variables-Initialize Variable', 'Aply To Each' and 'Variables-Append to string Variable'. I am looking for a solution where I don't have to use the 'Apply To Each' ,as this operation takes a fews seconds to complete and the latency increases with increasing number of items (in the case above only 3). Does anyone know how to return all the IDs as a string without the use of Apply To Each?

Any kind of help or input is appreciated. Thank you in advance!

Quick Links

Leaderboard > Power Automate