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

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

[@awesomopoulos]

Thank you for the informative video. Just started using Power Automate and your videos were very helpful to familiarize myself with different methods of parsing JSON (watched your other video too where you just select and create csv table) and the syntax and commands to use. I was playing with the Parse JSON action today at work and couldn't get it to work. Now realize my sample schema was incorrect. Look forward to applying this knowledge. Thanks again.

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

[@rafaelchavesquaresma8652]

Congrats for this great class! Thank u very 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.

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

[@mogoodi1]

Thanks, very instructive and concise!

[@kazazaj]

THANK YOU! Great video, super helpful.

[@donnamareepakinga1269]

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

[@joelatino3748]

This is a great video, thanks so much

[@dreambymana4981]

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

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

[@mikepowers4767]

Brilliant! Thank you.

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

[@MsJanaka2010]

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

[@antonioskokiantonis7051]

Great!

[@AlexBohlen]

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

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

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

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

[@rishiagrawal9613]

Thanks!

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

[@LapaConsult_Ex_Macraris]

Thank you! Great insight

[@cBadArsBiker1579]

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

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

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

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

[@jaggyjut]

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

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

[@gerfer6261]

👍👍👍👍

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

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