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
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.

Audrie-MSFT
Power Automate
Status changed to: Need Info

See question below posted by @archanan

Bee
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

mcolbert
Advocate V

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

vangrieg
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. 

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

 

Thanks

Anonymous
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!

Anonymous
Not applicable

Is there any update on this?