Power Apps

ParseJSON refusing to parse JSON...

(0) Share

Report

Posted on by Lee-Martin

581

I am using a Power Automate flow to extract data. Returning a JSON string to my Canvas App.

I am using List Rows Dataverse action (this is a business requirement)

I put the columns I want into a Select

I put the Select into Compose

I am putting Compose into Respond to a Power App or Flow

as an aside I've also removed the square brackets around the JSON with an expression in a string variable and submitted the String to the Respond (I have also tried it with the square brackets)

What I can see is that escape characters are being put in for the " so I get /" instead of " - Canvas Apps is not allowing me to replace these escape characters and gives me an error any time I try.

I distinctly remember being able to Parse JSON directly from Power Automate previously, so I'm sure it must be done?

Has something changed since the last time I did this?

Thanks

Lee

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

hey

your topic would be a better fit in the powerautomate section of this foru to be found here:

Microsoft Power Platform Community Forum Thread

if my answer helped, please mark it as verified,

cheers

Was this reply helpful? Yes No
Suggested answer

Mark Nanneman 991 Super User 2025 Season 2 on at

Like (0)

Report

Hello Lee,

The trick is to wrap your JSON Array string in a ParseJSON() and then a Table() function.

Example:
Table(ParseJSON(varJsonArrayString))

Then in your gallery you'd reference properties like "ThisItem.Value.{propertyName}"

Here's one I did:

Use "Table(ParseJSON(<your variable containing json string>))"

Reference properties in individual items of your parsed JSON array with ThisItem.Value.<propertyName>

All this said... why aren't you connecting to your Dataverse table directly in PowerApps? Why are you using a flow to select and return the data? It's a lot more work.

Was this reply helpful? Yes No