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:
dotnetking.com/files/Xero_dumm...
- 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
sslwsh008.securedata.net/dotn...
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb

[@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 :)

[@lymitutit3046]

Hello , I've watched some of your vides. They are very clear and understandable, but for my intermediate level in Power Automate , Array. I'm struggling with a simple selecting ( filtering out) some values from an array variable. I'm not very familiar witht he indexs in Arrays. If you have any idea how to do it, it would be very helpful for me.
Thank you for your understanding.

[@AlirezaAliabadi]

@@lymitutit3046 Message me on LinkedIn and I will give you some advice on working with arrays :)

[@pauljoneseyboy9615]

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

[@Dinkleberg106]

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

[@arshad801]

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

[@juliantagell1891]

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

[@eladiobardelli3001]

Gracias Alireza que gran video, saludos desde Chile.

[@ThomasBrunkard]

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

[@wairya]

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

[@AlexBohlen]

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

[@donnamareepakinga1269]

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

[@rafaelchavesquaresma8652]

Congrats for this great class! Thank u very much!

[@mogoodi1]

Thanks, very instructive and concise!

[@kazazaj]

THANK YOU! Great video, super helpful.

[@mikepowers4767]

Brilliant! Thank you.

[@LapaConsult_Ex_Macraris]

Thank you! Great insight

[@joelatino3748]

This is a great video, thanks so much

[@antonioskokiantonis7051]

Great!

[@rishiagrawal9613]

Thanks!

[@mehdielghozail9633]

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.

[@gerfer6261]

👍👍👍👍

[@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

[@juliancrentz4485]

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

[@manipathak7721]

Hey ali, i have a problem statement. Can you please guide me on that? "' I have input json having different schema which can change based on client, and we need to convert incoming json to different json format which will be standard and fixed. Can we have a azure AI solutiin to generate the code in c# or any other language?

[@dreambymana4981]

Can you upload videos where you can parse e-mail body which is in table format and upload the data to excel please.

[@MsJanaka2010]

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

[@cBadArsBiker1579]

the parse json variables are all string, not integer. How do you get the integer values from the JSON Array?

[@shobhanamuralidharan7819]

How can we convert the date field? I have a field Date and when I add the row with this data, it updates with a whole number.

[@bharanbopanna9910]

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

[@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

[@jaggyjut]

What if we want to create a json with nested array from excel

[@rare3197]

Thank you for excellent video. Is there anyway to get the json object from weblink instead of pasting the actual json object into value field?

[@alanmonaghan9194]

Yes please. Me too.

[@ousselg1509]

If you don't want to use apply to each how would you do it? I really dislike apply to each as it ruins the flow sometimes and takes ages to complete complex flows. Can you maybe do a video about selecting complex array object (like attachment name when using get emails for example). The only way I know how to do it is either apply to each or using first expression but sometimes you don't want just the first but want all names and then separate them. I hope you can make something akin to this

[@StephenPryke]

With the Sascha Baron Cohen example at the beginning, how would you get the children? These seem to be objects within the json each surrounded by {}

[@AlirezaAliabadi]

You follow the same rule with expressions. Object.property.property and same way goes on to any level while with Parse JSON parsing a multi level object is quite a challenge.

[@pradeepjamkhandi143]

Very nice explaination,
I have question though,
if I have the value lets say 'Aliabadi', then I want to know whther it is a Last name or First Name? from the current JSON list. can you please help with that.

[@aaaaa601]

👏👏👏👍👍👍🙋‍♂️🙋‍♂️🙋‍♂️🙋‍♂️

[@robertopolo3073]

Hello I hope you are well. I require your help in a challenge that is costing me more than I thought. I am doing 3 HTTP queries that return a JSON as a response with the same structure for all 3 queries. The challenge I have is that I need the 3 queries to be a single one and then send them to Powerapps and I have not managed to get a single JSON that I can send to the application and store it in a collection. I don't know how to join all those queries in a single JSON. Could someone give me a hand?

That each query is performed within a Do until, that is, each query must be stored in a variable or something to get all the queries at the end of the "Do until" loop.

I apologize for my english.

[@vmanikandhar8295]

Such a pathetic Powerapps. Parsing JSON is basic operation we need in today's world.