How to parse complex JSON in power automate

In this video we use a complex JSON file and parse it using power automate flow. In the end we convert extracted JSON elements into a CSV file and store it to SharePoint online.
Link to the JSON content:
- 0:00 Introduction and problem definition
- 1:30 Analyzing the JSON content
- 1:59 Developing the Power Automate Flow
- 5:55 Extracting the array from the JSON file
- 7:57 Converting JSON schema to match the csv fields
- 11:20 Converting JSON to csv
- 17:35 Saving the csv extract to SharePoint library
- 19:10 Conclusion

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

Contact me

[AlirezaAliabadi]

Please let me know if you want to see the same thing done using visual actions (using Parse JSON).

[ARealityStorm]

I have been struggling with a JSON payload all day until you showed variables('object').element in this and it's genuinely saved me SUCH a headache. Thank you so much. Really valuable lessons in the rest of the video too. Very grateful.

[edmusters]

Hey my friend, this is the SECOND time coming across this video to help me parse the JSON nonsense that a SharePoint REST API returns. Mission accomplished. :) THANK YOU!

[juliantagell]

Thanks Alireza, this is a great help. Very much looking forward to seeing how you'd do it including the parse json step (I think I have some idea... but am open to being surprised). You covered the process very well. Someone else had shown me how to do it with an apply to each but I will give your go a try (certainly seems faster!). Cheers.

[vishaljhaveri]

Best video on JSON Parsing in Power Automate! Thank you Alireza Aliabadi.

[anthonyfawkes]

Absolute legend - thank you so much for this video it has helped me solve a problem that I've had for over a month. THANK YOU!

[Bzlatar]

Truly the best tutorials i have found only for Power Automate. Thank you so much!

[TheAsterii]

As always, very nice video presentation. Looking forward to part II :)

[paulmatkin]

Great job explaining this. I'm taking my first steps in power automate and I was able to follow using my own project and get it to work!

[arshad]

No Ali Reza this video not only deserve like, but you also need a thumbs up. What i have learned from your video in 20 minutes, i havent learned it in over an year. You have explained it like a real teacher. Thank you so much for sharing your expert knowledge.

[dxkeeling]

Alireza, Thank you for the work you are doing. It has been very helpful as I begin to learn power automate. It would be nice to see how you visual actions -parse json or csv file in a future video.

[jamesdiekman]

Awesome Alireza - very well explained as usual. I recently took Alireza’a expressions course on Udemy and it’s seriously improved my understanding and use of expressions on Power Automate. Highly recommended 👍

[shasikumar]

It's complex, but you made it soo simple... Thank you...!!

[mSxVIFYIH]

A special approach for a specific problem.
Congrats for the video!
The man has a name and the name is Alireza!

[javiervelazquez]

Hey, just wanted to thank you for this video, very well explained. Thumbs up and subscribed!

[nocodeyuan]

Great video, exactly what I’m looking for

[liam]

Thank you. Very useful. I had a complex JSON object I finally got to something sensible. One question is nested arrays and filters.

I have a tasks object, for each task it has an array of objects. I ended up with loads of filters in a loop through tasks and then created a manual JSON object. Basically I need to transpose name to the root object with its value.

Here's an example;

[
{
"TaskID":123,
"TaskName":"A Name",
"Fields":[
{
"name":"Address",
"value":"street address"
},
{
"name":"Phone",
"value":"123456789"
}
]
}
]

[JY-niid]

Thank you so much for the sharing! Love it!

[deepakatri]

thank you for this video, helped a lot

[andydevman]

Great tutorials Alireza, Shukri شَكَرَ !!!