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