web

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

News and Announcements icon

Power Platform CommunityForums Power Apps parsing complex Json

Power Apps

Unanswered

parsing complex Json

(1) Share

Report

Report

Posted on by AChng

38

I have a Json response from Power Automate that looks like this.

{
"body": [
{
"summary": {
"duration": 665,
"length": 5619,
"baseDuration": 657
},
"polyline": "BF3-_mHgs3zbkMqBrOo2DjoBvHx7ByX8CmNlImtC0TyGsBiH_FoD"
},
{
"summary": {
"duration": 1358,
"length": 11563,
"baseDuration": 1224
},
"polyline": "BF_6inH8--zbgGnDrBhHzTxGmIltCpDhOg8B1WwnBsF6T1sFqU_oDuJrwD62CoLwD9BkClYyQsCH8D"
},
{
"summary": {
"duration": 719,
"length": 6421,
"baseDuration": 694
},
"polyline": "BFpj7mH4yuzbI7DxQrCpBkchzCjLrH2BtJmuDpUsnDzF05B_LrC"
}
]
}

I tried converting to string using string() in PowerAutomate before bringing it to PowerApps.

Which got rid of the error but still could not extract the relevant data.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Meekou 200 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
How did you return value from Power Automate?

Based on the error, it seems PowerApps already convert the string to object.

Try to use like

First(api_output.body).summary.length

Pay attention that your body is an array, you need to loop body to get every summary

Best Regards,

Meekou
Tracking the deleted items (powerplatform.com)
PowerApps
PowerAutomate

Was this reply helpful? Yes No
scalca 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

depending on how you get your json string you can do the following
it is always connected to your json structure and you have to specify the untyped object within powerapps in order to use them

in your scenario what you can do is the following

since you'll get an object array you have to loop through them

try with

ForAll(ParseJson(api_output).body,

{summary:

{

duration: Value(ThisRecord.summary.duration),

length: Value(ThisRecord.summary.length),

baseDuration: Value(ThisRecord.summary.baseDuration)

},

polyline: Text(thisRecord.polyline)

}

)

this will return a table with two columns (summary of type Record and Polyline of type Text)

you can store this into a collection or use it directly in a gallery

Was this reply helpful? Yes No

Join the conversation