JSON decode

[pturner]

Have a way to take a custom connector that produces a JSON response and parse it into individual peices.  As a workaround, provide a function to take a JSON response and extract values.

[archanan]

Hi - can you provide some more details around this ask? An example of what you are trying to accomplish would be helpful.

[Audrie-MSFT]

See question below posted by @archanan

[Bee]

Hi @Audrie-MSFT - maybe @pturner was asking for is similiar to the Split function. The Split function converts a delimited string into a single-column table. Can we have a new function that can convert JSON text/string to multi-column table?

Thanks

[mcolbert]

There is a connector in flow that will parse a JSON object.  If you select the Parse JSON action in Data Operations.

[vangrieg]

I would very much like an ability to parse JSON within PowerApps, too. 

My use case would be to store table-like data in SharePoint lists. 

[alexis]

It would be great to be able to create a Record from a JSON string received from a Flow for example. In fact, the exact opposite of the new JSON() function that creates a JSON string from an object. @Audrie-MSFT maybe something exists already ?

Thanks

[Anonymous]

It would be superb if I could build a collection from JSON formatted text.

Like ClearCollect(colMyCollection, varJSONtxt)

Where varJSONtxt is a string containing JSON formatted text. With this feature, it could be possible to store collections into SharePoint list text column as JSON. And load data back to PowerApps!

[Anonymous]

Is there any update on this?

[jdarling20]

Also curious if there's an update on this. I have a few instances in one of my apps which generates my JSON content in seconds, but spend 20+ minutes update the records in SharePoint. If this was just a JSON string, I could update a single multiline text record in SharePoint in seconds to meet my needs.