cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
DavesTechTips

Parse JSON in PowerApps

Submitted by Super User on โ€Ž09-11-2019 07:52 PM

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: Under Review
See more ideas labeled with:
45 Comments (45 New)
Comments
paulewert
Frequent Visitor
โ€Ž09-04-2020 10:30 AM

Quite frustrating that we can not get an object back from a Flow's "Respond to a PowerApp or flow." Instead, must use a Premium Response action. Such basic functionality and it has been restricted to Premium users.

johnsonse
Frequent Visitor
โ€Ž12-06-2020 08:00 AM

This is truly needed ! 

NewBee117
Advocate V
Advocate V
โ€Ž01-08-2021 12:27 PM

Yes, please.

annazurawska
Regular Visitor
โ€Ž01-22-2021 03:36 AM

That would be perfect!

camer314
Helper I
Helper I
โ€Ž01-22-2021 11:02 PM

More generally why can we not have weakly typed JSON support, like every single JavaScript application that has ever been written. Why do we need to bind to a schema?

 

I believe PowerApps is written in React TS, it would be almost no effort to allow a JSON string to be deserialized into a object that is weakly typed (e.g using 'any') and then leave it up to the developer to deconstruct the object by property reference (with appropriate conversions).