Unanswered

How to iterate over GUIDs and access id and name in Apply to each

(1) Share

Report

Posted on by CU25060522-1

Hi Community,

I know this error is usually about needing an array in Apply to each, but in my case, my data is a dynamic object, not an array.

Here’s an example of my data:

{
"animals": {
"429defc8-5b05-4c3e-920d-0bb911a61345": {
"id": "429defc8-5b05-4c3e-920d-0bb911a61345",
"name": "camel"
},
"429defc8-5b05-4c3e-920d-0bb911a613451": {
"id": "429defc8-5b05-4c3e-920d-0bb911a613451",
"name": "elephant"
}
}
}

How can I iterate over the GUID keys (like 429defc8-5b05-4c3e-920d-0bb911a61345) and access both id and name for each animal in an Apply to each or Select action?

I want to know the correct expression to use for this scenario where my object keys are dynamic GUIDs, NOT a simple array.

I already know about the array error, but my case is different due to the dynamic object structure.

What expression should I use to get this working?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You can use xpath to do this:

Select From:

xpath(

xml(outputs('Compose')),

'//animals/*'

)

Select Map:

json( item() )[ first( xpath( xml(item()), '/*/id/text()' ) ) ]

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Select From:

xpath(

xml(outputs('Compose')),

'//animals/*/id/text()'

)

Select Map:

outputs('Compose').animals[item()]

Was this reply helpful? Yes No
Parthiban759 56 on at

Like (0)

Report
Copy link

Link copied!
if you also need the GUID keys (not just values):

If you need both the keys and values, use:

json(string(outputs('AnimalsRaw')?['animals']))

And loop over:

union( createArray(), outputs('ComposeWithAnimalsObject') )

Then inside the loop, use:

item()?['Key']

item()?['Value']?['id']

item()?['Value']?['name']

Was this reply helpful? Yes No