Answered

Value from Parse JSON action without specifying schema?

(0) Share

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:

Building flows

I have the same question (0)

All responses (2)

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