Showing results for 
Search instead for 
Did you mean: 

JSON decode

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.

Status: Need Info

See question below posted by @archanan

Power Apps

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

Power Automate
Status changed to: Need Info

See question below posted by @archanan

Frequent Visitor

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?



Advocate V

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

Advocate I

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. 

Frequent Visitor

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 ?



Not applicable

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!

Not applicable

Is there any update on this?

Frequent Visitor

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.