web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Selecting nested json ...

Power Automate

Unanswered

Selecting nested json parse data

(0) Share

Report

Report

Posted on by jakemorris

Hello,

I am trying to select the "site" > "name" in the Parse JSON below, having a spent a good couple of hours. Can somebody point me in the right direct or show me what I am doing wrong please!

I have tried the scheme as both an object or a array. I just want to pull out the site name so I can use it for a filter later on.

I have tried outputs('Parse_JSON')?['body']?['name'] it shows shows no errors but shows a blank screen, however ('Parse_JSON')?['body'] pulls in the entire body no problems, I just cant manage to drill down into 'site'.

I am using the auditor connectors if this makes any differences

any help would be great,

thanks .

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @jakemorris ,

as per I can see, you should use the following expression:

outputs('Parse_JSON')['body']['audit_data']['site']['name']

It weird that you cannot grab this value as an output from the Parse JSON action.

Anyhow, could you please share the JSON?

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No

Join the conversation