CODEWITHSUNDEEP
powerappspower-automate
Beau Van Der Meer
Beau Van Der Meer

Reputation: 15

Convert JSON (Object) to Array - Power automate

In a power automate flow that I'm currently creating, I need to read the body of a specific email, previously I used the Get Emails V3 and that works great but the Get Emails widget only takes 25 emails at most. So right now I'm using a workaround with Send an HTTP Request, but the outputs of that are in JSON and for the flow to work I need an array.

enter image description here

What can I do to save the JSON objects into a array?

What can I do to save the JSON objects into a array? this is the flow that I'm using

enter image description here

or is there a way to convert the JSON into HTML?

Thanks in advance!

Upvotes: 0

Views: 8967

Answers (1)

Skin
Skin

Reputation: 11197

You need to specify this as your expression into the loop ...

body('Send_an_HTTP_request')?['value']

That should give you what you want.

Upvotes: 0

Related Questions