Using Parse JSON to process complex objects in Power Automate to Excel

Parsing a complex JSON object is always a challenge. In this video you will learn hoe to effectively use Parse JSON action for complex objects in Power Automate Flow. Then we move the records to an Excel file.
Link to the JSON content:

- 0:00 Introduction and problem definition
- 2:18 What "Parse JSON" can do
- 8:20 Parse JSON limitations
- 10:06 Simplifying complex JSON using "Parse JSON"
- 13:39 How to use Parse JSON for complex JSON processing
- 25:43 Conclusion

To enroll in my Udemy courses see below link for discount vouchers

Contact me

[AlirezaAliabadi]

Although "Parse JSON" is not made to process complex JSON objects, we can always break the complex object into simple ones and use it effectively. This video shows you how :)

[pauljoneseyboy]

I have looked at dozens of videos on this subject but only grasped it from this one! Thanks so much man

[Dinkleberg]

Just wanted you to know that you absolutely made the day of an absolute stranger almost 3 years later <3

[arshad]

What an amazing way of explaining this feature. I have been using logic apps and flow for over an year but by far the best video..thank you so much

[juliantagell]

Great one Alireza, such a clear explanation... Happy to show you how I ended up doing it, in the end. Slightly differently to yourself

[eladiobardelli]

Gracias Alireza que gran video, saludos desde Chile.

[wairya]

Thankyou so much Alireza for explaining in depth the drawback as well as the process

[ThomasBrunkard]

The first three minutes of this video saved me tonight! Thank you so much!

[AlexBohlen]

Thank you big time for this video! Very clear and super helpful! (now i feel much smarter :) )

[donnamareepakinga]

This is amazing! Thank you so much for this video, it was excellent.

[kazazaj]

THANK YOU! Great video, super helpful.

[rafaelchavesquaresma]

Congrats for this great class! Thank u very much!

[mogoodi]

Thanks, very instructive and concise!

[joelatino]

This is a great video, thanks so much

[mehdielghozail]

Thank you for this video !
I'm wondering if it's possible to populate images (from an image column type in SharePoint list) in word with power automate.

[juliancrentz]

Hi Alireza, thank you for this insightful tutorial, I tried this 'trick‘ you mentioned with simplifiying the json, so far Azure accepts the simplified schema, but when I actually run it with sample payload it takes the whole payload and uses that while parsing. It just skips the simplified one I provide. That‘s so weird, I need to escape json arrays, but this doesnt work somehow

[EugeneNaumenko_Music]

Thanks for the video. I did it in the same way but Add a row activity displays error that result is object but required array

[TomaszMalkiewicz]

Thanks for very informative video. I have one issue that I am trying to resolve. I am getting my json data from http response. The api I am connecting to sends response back paginated. I know how many objects are in total as well as I know the page size. I can actually include it in a url parameter items per page. Would you have a solution on how to iterate through all pages and produce one json with all items in it? Need it for my powerBi project. Thank you in advance

[MsJanaka]

Thank you and can I know how to select value from payments array as well.

[bharanbopanna]

Thank you for making this process easy to understand.
The JSON file that I'm working with has lines, and when I copy this to Power Automate the program turns unresponsive. Is there a way around this?