CODEWITHSUNDEEP
sharepointoffice365powerappspowerapps-canvaspowerapps-formula
Meet Bhatt
Meet Bhatt

Reputation: 11

How to parse JSON in PowerApps?

I have stored JSON data in SharePoint online list multi line and text column. I need to update that column in Power Apps form.

Can anyone help me for how to parse / stringfy the JSON data in Power Apps without using Flow?

Thanks & Regards, Meet

Upvotes: 0

Views: 13727

Answers (5)

Ganesh Sanap - MVP
Ganesh Sanap - MVP

Reputation: 2238

Power Apps now supports experimental ParseJSON function which might be helpful to you.

Check below links for detailed information:

  1. Power Fx: Introducing ParseJSON
  2. ParseJSON function in Power Apps (experimental)

Upvotes: 0

Sigar Dave
Sigar Dave

Reputation: 2654

Today Microsoft has provided the function to parse the JSON inside the powerapps itself. It is an experimental feature for now. You can learn more from here: https://powerapps.microsoft.com/en-us/blog/power-fx-introducing-parsejson/

Upvotes: 0

Helpful User
Helpful User

Reputation: 1

You can actually use MatchAll() to do much of the parsing. Issue is getting the correct RegEx string (in PowerApps format) to do so.

Upvotes: 0

AnkUser
AnkUser

Reputation: 5531

unfortunately you will have to use Power Automte/flow for converting string to Json. Out of box canvas App does not have any method to convert string to json. The closet you can get is JSON function.

Here is nice article of Power Apps (canvas App) with power automate to convert string to JSON

Upvotes: 0

Piotr Sulowski
Piotr Sulowski

Reputation: 161

You can use Power Automate to parse JSON string to Object. Action is named "Parse JSON".

Serializing from Object to string is possible using JSON function in PowerApps: https://learn.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-json

Upvotes: 1

Related Questions