Skip to main content
Power Automate
    • Connectors
    • Templates
    • Take a guided tour
    • Digital process automation
    • Robotic process automation
    • Business process automation
    • Process advisor
    • AI Builder
  • Pricing
  • Partners
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Business process and workflow automation topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Using Connectors
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • Process Advisor
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Connector Development
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Galleries
    • Community Connections & How-To Videos
    • Webinars and Video Gallery
    • Power Automate Cookbook
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Galleries
    • Webinars and Video Gallery
    • How to retrieve Value from Complex JSON Object and...

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

    11-02-2020 05:05 AM

    Dhruvin
    Helper III
    1089 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Dhruvin
    Dhruvin Helper III
    Helper III
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

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

    ‎11-02-2020 05:05 AM

    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

    watch?v=sqx8in2PJlA

    Labels:
    • Labels:
    • Tutorials
    Message 1 of 1
    1,089 Views
    0 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing

    • © 2023 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices