web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Value from Parse JSON ...

Power Automate

Answered

Value from Parse JSON action without specifying schema?

(0) Share

Report

Report

Posted on by TB-13091842-0

140

Hi,

I need to pull a single value from a JSON-formatted string in a flow, passed in from Power Apps. Parse JSON requires the schema. But the schema is different in different strings, depending on the further action I want to do in the flow. It Is there a way to pull a single value out, without specifying the JSON schema, similar to the JSON_VALUE() function in SQL Server?

Thanks!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @TedBabcock,

If the parse JSON schema is not always the same, but the value you want to extract within a same deep structure, you could use expression to get it instead of Parse JSON, for example:

{

"customerName":

{

"firstName": "Sophia",

"surName": "Owen"

}

}

I want to get the surName, the expression could be:

json('{"customerName": {"firstName": "Sophia","surName": "Owen"}}')['customerName']['surName']

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
TB-13091842-0 140 on at

Like (0)

Report
Copy link

Link copied!

Thank you, @v-litu-msft ! I'm not very experienced in Power Automate, but I was sure there had to be a solution. 🙂

Was this reply helpful? Yes No

Join the conversation