Introduction to Parse JSON in Power Apps | ParseJSON Arrays as Table; Return Array from flow

This PowerApps video is an Introduction to the NEW ParseJSON Power Fx function in Power Apps.
Use the ParseJSON function to parse data in JSON format.
JSON stands for JavaScript Object Notation. JSON is a text format for storing and transporting data.

JSON Payload and Power Apps can now work better together with the introduction of the new Parse JSON function. ParseJSON will parse a valid JSON string and convert it into an Untyped Object.
Use the dot operator and the Index function to navigate an Untyped Object. Use the Table function to convert JSON arrays into Tables. Use the Value, Text, and Boolean functions to restore the type of primitive data. Convert Untyped strings into typed objects.
Untyped object can hold any data structure complex or simple. Fields in untyped object can be accessed using the dot notation however the existence of fields is verified at runtime.

You will learn all about the ParseJSON function, Parse JSON payloads (simple and complex) in PowerApps, how to return data from flow to Power Apps in the form of a string Array using Standard Connector, how to retrieve JSON Array data and showcase in Galleries or load into collections, etc.

ParseJSON syntax:
ParseJSON( JSON String )
JSON String is the JSON structure in the form of string.

Helpful Links 🔗:
Power Apps Dynamic Surveys

#PowerApps #ParseJSON #JSON #PowerPlatform

Table of Contents:
00:00 - Introduction to ParseJSON in Power Apps
00:48 - What is JSON and ParseJSON function in PowerApps
01:51 - How to use ParseJSON in Power Apps to parse JSON string data
04:45 - Parse JSON array data in Power Apps
06:17 - Parse JSON Array of Objects in PowerApps
07:26 - Parse JSON data and display in PowerApps Gallery
09:34 - Parse and Filter JSON Arrays in Power Apps
10:24 - Load Parsed JSON Data in Collection or Variable (Strongly Typed)
11:42 - Return array of data from Power Automate flow to Power App using Standard connector
14:56 - Parse and Load JSON array data in string format in Power App (Dynamic Surveys use case)
16:52 - Subscribe to Reza Dorrani channel

🤝 Let’s connect on social:

[AnilKumar-frjo]

I become your fan of study styles & explanation of critical topics in a very simple way. Big thank to you Reza... keep sharing more good videos... :)

[MorsugioJr]

I work with power platform dev for almost 10 years already and I must say... if the presenter have indian accent, he is a good teacher... great video m8 !

[Ethan-ddln]

You know YouTube is paying well now that Reza is rocking Balmain now!! Love to see it!

[MikeHatheway]

This is amazing Reza. Great examples with the group memembers and surveys! I can think of so many uses for this.

[fadiahdab]

finally, I can use it in standard connectors, thank you the presented scenarios have covered everything

[Paul___L]

Thank you, very helpful content I was struggling with the ms guide alone.

I'll feel a lot more confident about the data security when I know its only accesssible via a flow, but coming back as an array saves a huge amount of work and keeps if flexible for changes.

[Mal]

I've been SO waiting for this functionality. Thanyou you Reza for all your videos.

[frenamakenson]

Hi Reza,

I’m pretty Shure that was one of the thing that you request to Microsoft 🎉
This is one of the most important feature for power apps….

So many project was waiting for this feature

Thx for your Demo man, you’re the master !

[noorsyyed]

thanks for the detailed walk through of ParseJson function, this is going to be very useful function

[Plymor]

Nice! I spent so much time translating JSON outputs produced by power automate flows to regex to feet it to MatchAll function in the past. Now it will be much easier!

[ayushchaudhary]

This is working very smoothly. Thanks for sharing this. keep sharing more good videos.

[bobbyanderson]

Thank you so much Reza, I've been struggling with receiving JSON response from Flow and converting it to a collection. For some reason, the Response action in Flow wasn't sending the data.

This was a very helpful workaround.

[stuandrews]

Awesome Reza, this has so many use cases, I'm glad MS have spent sometime making this Power FX formula!

[girlontheswing]

Thank you sharing your amazing knowledge on PowerApps.

[maricarmenjimenez]

AMAZING video. Thank you for your time and help 🙏

[harry]

This is exceptional. Very nicely explained. Thank you very much for creating this video.

[TheShalabh]

Very well described in concise and real time scenarios. Thanks.

[ThePayanazo]

As always, high quality content. Thanks Reza keep it up.

[damiandelgado]

Thanks so so so much. You're my hero

[oluwatobiyusuf]

Awesome video Reza. Thanks for the amazing use case