cancel
Showing results for 
Search instead for 
Did you mean: 

Parse JSON in PowerApps

Hi everyone,

 

The new JSON function in PowerApps is great and we have been using it extensively. Another great addition would be to parse JSON directly in PowerApps. If PowerApps receives a stringified JSON string, it should be able to easily Parse this and use this data in the app, to write it into a collection, variable or whatever.

 

We have been using the HTTP response in flow to return dynamic data to PowerApps, but seeing that this is now longer included in the Office 365 entitlement and that normal Respond To PowerApps Flow action not supporting Arrays or JSON, this request is quite urgent.

 

Please let us know if you have any questions or suggestions.

 

Kind regards

 

Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1

Status: New
Comments

Yes ! X 10

Level 10

Thanks @FredericForest  Smiley Happy

Tell your friends Smiley Wink

PowerApps Staff

Adding @GregLi for visibility

Level 8

Excellent suggestion @Dawidvh 

 

Let's even push this to a perfect scenario... be able to use that JSON to construct a dynamic collection ;-)

Level 8

@Dawidvh  and @ZePowerDiver this would be perfect, create JSON from a collection  and then create the collection from JSON text. Was trying to implement using a JSON string to save that values from a form that are unstructure from row to row instead of adding a bunch of unused columns. Problem is getting the JSON back, then setting the control's default for editing.

 

Vote X100

omh
Level: Powered On

It would be an important improvement to add this possibility in PowerApps directly.

Level: Powered On

This would essentially allow users to "save" collections to be used in a another session. Im surprise it's not available now!