How to retrieve Value from Complex JSON Object and Array in Power Automate using Expression?

Sometimes we have a JSON Object in our response and we want to fetch a specific JSON key from the object and store the value to any of the variables. So, how we can achieve this? I have explained detailed steps to get specific key values from a JSON response during this video.

Also, sometimes we have complex JSON structure available in the response and we have an array of a JSON object, and we want to send some simplify JSON structure to our API endpoint, so how we can achieve that? We will use the Select Data operation to map our key with the JSON array’s key values.
Stay tuned throughout the session to check the entire procedure. Also, I explained how to iterate specific JSON objects from a large complex JSON structure in Power Automate.

Chapters:
00:00 Introduction
00:27 Example
01:03 How to get data from JSON Object in Power Automate?
01:27 Retrieve value from Complex JSON Object and Array
02:07 How to identify what's an object and what's an array?
03:11 How to retrieve array from JSON Object in Power Automate?
04:49 Test
05:08 Store JSON's Key-Value in variable
05:54 Iterate JSON Object
06:06 Select Action in Power Automate
06:23 Iterate JSON Object and get Array in Power Automate
07:15 Return JSON Array by modifying Objects in Power Automate
09:38 Test
10:24 Subscribe

#PowerAutomate #PowerPlatform #PowerAddicts #Flow #MicrosoftFlow #MSFlow #Flownut

[jp-i]

Bless you Dhruvin! Even as a newbie citizen developer, I could instinctively tell that your video had the answer that I needed.

At first I thought that I was struggling with your explanation, but then I realised I was struggling with my lack of experience and knowledge. 😂

A little bit of reading around and trial and error and I came back to you, and then the answer was clear. I look forward to exploring more of your videos.

Many thanks!!

[alessandropicardi]

You made my day! I finally understand something more of JSON array and matrix and I can get values in MSflow. Greetings and love from Italy

[titahaver]

This was the best explanation of it all. I really struggle with it all and especially the API and Parse JSON...But now I don't need that anymore thanks to you😄

[renealvarezm]

Thanks for your explanation. The best one I have founded.

[jalajat]

in this type of flows we will get all the columns as output. But how to get particular one column as a output?

[MarcosFJ]

Awesome video!! So many thanks!!! What software do you use to show mouse clicks? It is great for teching! Thanks in advance 🙏🏻

[RahulPatel-yich]

Hi Dhruvin
Thanks for the video.
In a SharePoint List, is it possible to fetch specific item value based on version/versionLable in Power Automate?
Basically, I want to get earlier values of records after user edit records in Power Automate?

[darrenfloyd]

Hi Dhruvin. Great video. Would have a video explaining how to retrieve and store the value from a secondary SharePoint list to use in a Compose function? Specifically I'm trying to subtract the number a field in one list from the number is a filed in a different list? Thanks

[jaredwaterman]

I don't have "get access token from sharepoint" or "get groups" as options to fetch a JSON object. I simply desire to separate out information from a string {first name, last name} and apply only the first name later in the flow using dynamic content from the separation comment. Is their an expression fx formula I should use?

[srinivasnallapati]

Dhruvin, Your explanation was very good. But why don't you explain the task from scratch. you are editing the task which you were already created. If you explain us from start to end that will be very helpful for Beginners.

[Nopealope]

Great video! Thanks for taking the time to make and share it! I have one question I hope you might be able to answer. I am working with a SharePoint Get Items step and have a column with a JSON array example: Name, Date, Message. I want just the first message from the first object in the array. When I try to do the select, it puts it in the Apply To Each loop and I end up with all of the messages from the single array. I just want the first message in the first item in the array. Can you help point me in the right direction?

[jaredwaterman]

Can you clarify what the character brackets indicate? Square bracket = ? and and curly brackets {} = object. Thank you.

[babylyngarcia]

Hi, i have the result of the select step. It has 4 mapping and the last value is expiry date. Now i want to put a condition that if the expiry date equals to xx value of days, it should send email. I am stuck here for 2 weeks already, i cannot find the expiry date as a dynamic content and also dont know what to put in the expression..any insight how to move forward is really a big help..if you can spare a minute

[ResponsibleXI]

Can you tell me what is the intent of your flow? What is it doing?