Answered

Converting randomized number objects into an array

(0) Share

Report

Posted on by KA-08112210-0

I have a data source that I'm bringing into power automate using an HTTP request.

In order to work with the data I need to have all of the properties inside the user_id objects into an array. In reality these user id's are random numbers, so I cant see a way to reference the object field. I can compose for outputs all the way down to the user id, but the user id objects are still present, so its just an array of objects. The properties that I really need to get to are id, display_name, and group_id

Does anyone have any advice for how to put these objects into an array? remember that the object name for user id is different for each user. Heres an image of the data structure.

Categories:

Building flows

All responses (2)

Answers (0)

Sort by

Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

Try using xpath as shown below

Here we have to use 3 different xpath expression to get id, groupid and display_name in 3 different array as shown below

Assume the below compose action has following JSON object

Now use another compose action to use xpath expression to get the id attribute from it in array format as shown below

xpath(xml(outputs('Compose')),'//id/text()')

Simmilarly to get other node values> try these expression for getting group_id and display_name

xpath(xml(outputs('Compose')),'//group_id/text()')

xpath(xml(outputs('Compose')),'//display_name/text()')

Hope it helps !

Mark it as solution if it resolves your query !

Thanks & Regards,

Nived N
KA-08112210-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Nived,

It ended up being a bit more complicated then this. I had to compose with the Root, Compose with XML, Use XPath, then decode from Base64, Clean the Ids, and then re-iterate through the data, but without your answer I could have never figured this out! Xpath is a very useful tool that I wasn't aware of. Much appreciated!