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)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 993 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

1 people found this reply helpful.

Was this reply helpful? Yes No