cancel
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

Comments
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?

 

Thanks

Advocate IV

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. 

Regular 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 ?

 

Thanks

Advocate IV

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!

Regular Visitor

Is there any update on this?