web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Extracting Specific Fi...
Power Apps
Answered

Extracting Specific Fields (Email, Phone) from JSON API Response in Canvas App via Power Automate

(2) ShareShare
ReportReport
Posted on by 78
Hi Everyone,

I have a Canvas App with three input fields: First Name, Last Name, and Organization Name. I’m passing these values as parameters to a Power Automate flow, which then calls an API to fetch the respective person’s details.

 

The flow returns the JSON response from the API, and I’m displaying the output in a Label in the app.

 

Now, my requirement is to extract specific fields like Email, Phone, etc., from the returned JSON and display them in their respective Labels or Text controls in the app.

 

Could someone guide me on how I can achieve this?

 

Image of My Flow & Canvas App

 

I have the same question (0)
  • Suggested answer
    stampcoin Profile Picture
    5,058 Super User 2025 Season 2 on at
    I suggest that reduce the JSON object only the columns you need in powerautomte,
    and after that use Data operation Create HTML table, then back to power app.
  • Suggested answer
    Daniel Bocklandt Profile Picture
    5,099 Super User 2025 Season 2 on at
     
    take a look at this link: Power Apps and ParseJSON - Forward Forever

    They'll explain how to use ParseJSON, the function that you need in this case. 

    If this solved your problem, please mark it as Solved to help others find the solution faster.
    If you found it helpful, consider giving it a Like to support each other in this community!

    Thanks, and happy building!

  • SR-02111122-0 Profile Picture
    78 on at
    Hi ,
     
    I was going through the link and refereeing the steps mention in it. SO on Click of Submit Button i am Displaying the my whole JSON output in Label_JSON_Response and using that label_JSON_Response I tried to access name field in JSON and show the Name in Label_first_name still its not working.
     
    Formula on Submit Button OnSelect Property is 
    // Call the API and get response as raw JSON
    Set(responseRaw, APIResponse.Run(
        DataCardValue7.Value,
        DataCardValue8.Value,
        DataCardValue9.Value
    ));
     
    // Parse the response string into JSON
    Set(parsedResponse, ParseJSON(responseRaw.result));
     
  • Suggested answer
    Daniel Bocklandt Profile Picture
    5,099 Super User 2025 Season 2 on at
    Hey Can you try this:
     
    To test put this in a button: 
    Set(varParsedJSON,Table(ParseJSON(Label_JSON_Response.Text)))
    And put in the label
    First(varParsedJSON).first_name

    If this solved your problem, please mark it as Solved to help others find the solution faster.
    If you found it helpful, consider giving it a Like to support each other in this community!

    Thanks, and happy building!

  • SR-02111122-0 Profile Picture
    78 on at
     
    didn't Work
  • Daniel Bocklandt Profile Picture
    5,099 Super User 2025 Season 2 on at
    Could you send a Chunk of the JSON?, 

    This way i can look if needs to be parsed multiple times. 

    If this solved your problem, please mark it as Solved to help others find the solution faster.
    If you found it helpful, consider giving it a Like to support each other in this community!

    Thanks, and happy building!

  • SR-02111122-0 Profile Picture
    78 on at
    This is my JSON :
     
    {
        "statusCode": "200",
        "body": {
            "API1": {
                "person": {
                    "id": "66f3f8549a37dc0001636fe3",
                    "first_name": "Manas",
                    "last_name": "Mehra",
                    "name": "Manas Mehra",
                    "linkedin_url": "http://www.linkedin.com/in/manas-mehra",
                    "title": "Global Chief Information Officer",
                    "email_status": "verified",
                    "photo_url": "https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2",
                    "twitter_url": null,
                    "github_url": null,
                    "facebook_url": null,
                    "extrapolated_email_confidence": null,
                    "headline": "Digital Transformation || IIM Lucknow || CIO",
                    "email": "manas.mehra@dabur.com",
                    "organization_id": "54a22fb07468693fda834c14",
                    "employment_history": [
                        {
                            "_id": "67f818d58f891d0001e583ce",
                            "created_at": null,
                            "current": true,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": null,
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "54a22fb07468693fda834c14",
                            "organization_name": "Dabur India Limited",
                            "raw_address": null,
                            "start_date": "2025-01-01",
                            "title": "Global Chief Information Officer",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583ce",
                            "key": "67f818d58f891d0001e583ce"
                        },
                        {
                            "_id": "67f818d58f891d0001e583cf",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2025-01-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "5f8e8986a9fea60166f4bd67",
                            "organization_name": "Gulf Oil",
                            "raw_address": null,
                            "start_date": "2022-07-01",
                            "title": "Head Of Information Technology",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583cf",
                            "key": "67f818d58f891d0001e583cf"
                        },
                        {
                            "_id": "67f818d58f891d0001e583d0",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2022-06-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "6131f47c6f7265000138e775",
                            "organization_name": "Unilever",
                            "raw_address": null,
                            "start_date": "2019-09-01",
                            "title": "Group Manager",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583d0",
                            "key": "67f818d58f891d0001e583d0"
                        },
                        {
                            "_id": "67f818d58f891d0001e583d1",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2019-08-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "6131f47c6f7265000138e775",
                            "organization_name": "Unilever",
                            "raw_address": null,
                            "start_date": "2016-06-01",
                            "title": "Sr Manager Enterprise Applications",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583d1",
                            "key": "67f818d58f891d0001e583d1"
                        },
                        {
                            "_id": "67f818d58f891d0001e583d2",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2016-05-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "54a1233869702d8ed4ee5703",
                            "organization_name": "Deloitte",
                            "raw_address": null,
                            "start_date": "2014-08-01",
                            "title": "Manager",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583d2",
                            "key": "67f818d58f891d0001e583d2"
                        },
                        {
                            "_id": "67f818d58f891d0001e583d3",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2014-08-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "54a1233869702d8ed4ee5703",
                            "organization_name": "Deloitte",
                            "raw_address": null,
                            "start_date": "2011-08-01",
                            "title": "Senior Consultant",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583d3",
                            "key": "67f818d58f891d0001e583d3"
                        },
                        {
                            "_id": "67f818d58f891d0001e583d4",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2011-08-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "54a1233869702d8ed4ee5703",
                            "organization_name": "Deloitte",
                            "raw_address": null,
                            "start_date": "2010-02-01",
                            "title": "Consultant",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583d4",
                            "key": "67f818d58f891d0001e583d4"
                        },
                        {
                            "_id": "67f818d58f891d0001e583d5",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2010-01-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "5ed6b83cb1021800014739ea",
                            "organization_name": "Tech Mahindra",
                            "raw_address": null,
                            "start_date": "2008-09-01",
                            "title": "Senior Technical Associate",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583d5",
                            "key": "67f818d58f891d0001e583d5"
                        },
                        {
                            "_id": "67f818d58f891d0001e583d6",
                            "created_at": null,
                            "current": false,
                            "degree": null,
                            "description": null,
                            "emails": null,
                            "end_date": "2008-08-01",
                            "grade_level": null,
                            "kind": null,
                            "major": null,
                            "organization_id": "5ed6b83cb1021800014739ea",
                            "organization_name": "Tech Mahindra",
                            "raw_address": null,
                            "start_date": "2005-07-01",
                            "title": "Technical Associate",
                            "updated_at": null,
                            "id": "67f818d58f891d0001e583d6",
                            "key": "67f818d58f891d0001e583d6"
                        }
                    ],
                    "state": "Maharashtra",
                    "city": "Mumbai",
                    "country": "India",
                    "organization": {
                        "id": "54a22fb07468693fda834c14",
                        "name": "Dabur India Limited",
                        "website_url": "http://www.dabur.com",
                        "linkedin_url": "http://www.linkedin.com/company/dabur-india-limited",
                        "twitter_url": "https://twitter.com/DaburIndia",
                        "facebook_url": "https://facebook.com/DaburIndia",
                        "primary_phone": {
                            "number": "+91 12039 62100",
                            "source": "Owler",
                            "sanitized_number": "+911203962100"
                        },
                        "languages": [
                            "English"
                        ],
                        "alexa_ranking": 92217,
                        "phone": "+91 12039 62100",
                        "linkedin_uid": "7203",
                        "founded_year": 1884,
                        "publicly_traded_symbol": "DABUR",
                        "publicly_traded_exchange": "nse",
                        "logo_url": "https://zenprospect-production.s3.amazonaws.com/uploads/pictures/67ca82f85d4089000187886b/picture",
                        "primary_domain": "dabur.com",
                        "sanitized_phone": "+911203962100",
                        "industry": "mechanical or industrial engineering",
                        "keywords": [
                            "ayurvedic",
                            "natural health",
                            "personal care",
                            "packaged juices",
                            "hair care",
                            "oral care",
                            "healthcare",
                            "home care",
                            "skin care",
                            "health supplements",
                            "ayurveda",
                            "manufacturing",
                            "ayurvedic products",
                            "natural healthcare",
                            "consumer goods",
                            "food & beverages",
                            "wellness",
                            "immunity",
                            "traditional remedies",
                            "fmcg",
                            "health-conscious consumers",
                            "young professionals",
                            "families",
                            "rural markets",
                            "sustainable development",
                            "innovation",
                            "quality assurance",
                            "customer service",
                            "market presence",
                            "diverse product portfolio",
                            "herbal ingredients",
                            "corporate governance",
                            "strategic business units",
                            "international operations",
                            "competitive analysis",
                            "customer demographics",
                            "product quality",
                            "brand loyalty",
                            "e-commerce",
                            "health & wellness solutions",
                            "health care",
                            "health, wellness & fitness",
                            "hospital & health care",
                            "mechanical or industrial engineering",
                            "consumers",
                            "sustainability",
                            "environmental services",
                            "renewables & environment",
                            "consumer internet",
                            "internet",
                            "information technology & services"
                        ],
                        "estimated_num_employees": 10000,
                        "industries": [
                            "mechanical or industrial engineering"
                        ],
                        "secondary_industries": [],
                        "snippets_loaded": true,
                        "industry_tag_id": "5567ce2673696453d95c0000",
                        "industry_tag_hash": {
                            "mechanical or industrial engineering": "5567ce2673696453d95c0000"
                        },
                        "retail_location_count": 0,
                        "raw_address": "Kaushambi, Sahibabad, Ghaziabad, Uttar Pradesh 201010, IN",
                        "street_address": "Sahibabad Road",
                        "city": "Ghaziabad",
                        "state": "Uttar Pradesh",
                        "postal_code": "201010",
                        "country": "India",
                        "owned_by_organization_id": null,
                        "seo_description": "",
                        "short_description": "We are Dabur, an Indian Transnational offering the best nature-based solutions to provide holistic Health & Well-Being to households in more than 120 markets spanning Asia, Europe and The US. A world leader in Ayurveda, we are a family of over 7,000 individuals continuously striving to conduct business in an environmentally sustainable manner.\nHome to trusted household brands like Dabur Chyawanprash, Dabur Honey, Dabur Red Paste, Dabur Amla, Vatika and Real, we are recognized the world over for our leadership, innovation and ability to reinvent ourselves and stay relevant for consumers across generations and geographies.\nAt the heart of our success is our team of diverse, experienced and talented employees. They play a key role in seamlessly driving of our operations, developing and delivering nature-based solutions on time, every time, with their passion, excellence and innovative spirit.\nBe a part of one of the world's Most Trusted brands... It's an opportunity to learn, develop and enhance your skills, while improving the lives of consumers and communities.",
                        "suborganizations": [
                            {
                                "id": "5e2964d99577ad00985e681f",
                                "name": "Dabur International Ltd",
                                "website_url": "http://www.daburinternational.com"
                            },
                            {
                                "id": "55699b4873696425d7b26400",
                                "name": "NewU (A Dabur Enterprise)",
                                "website_url": "http://www.newu.in"
                            },
                            {
                                "id": "5ed0e6505a56ca000123fbdc",
                                "name": "Badshah Masala",
                                "website_url": "http://www.badshahmasala.com"
                            }
                        ],
                        "num_suborganizations": 3,
                        "annual_revenue_printed": "96B",
                        "annual_revenue": 96000000000,
                        "technology_names": [
                            "Apache",
                            "Bootstrap Framework",
                            "Cloudflare DNS",
                            "DoubleClick",
                            "DoubleClick Conversion",
                            "Facebook Custom Audiences",
                            "Facebook Login (Connect)",
                            "Facebook Widget",
                            "Google Analytics",
                            "Google Dynamic Remarketing",
                            "Google Font API",
                            "Google Tag Manager",
                            "Microsoft Azure Hosting",
                            "Mobile Friendly",
                            "OpenSSL",
                            "Outlook",
                            "YouTube"
                        ],
                        "current_technologies": [
                            {
                                "uid": "apache",
                                "name": "Apache",
                                "category": "Load Balancers"
                            },
                            {
                                "uid": "bootstrap_framework",
                                "name": "Bootstrap Framework",
                                "category": "CSS and JavaScript Libraries"
                            },
                            {
                                "uid": "cloudflare_dns",
                                "name": "Cloudflare DNS",
                                "category": "Domain Name Services"
                            },
                            {
                                "uid": "doubleclick",
                                "name": "DoubleClick",
                                "category": "Ad Servers"
                            },
                            {
                                "uid": "doubleclick_conversion",
                                "name": "DoubleClick Conversion",
                                "category": "Advertising Networks"
                            },
                            {
                                "uid": "facebook_web_custom_audiences",
                                "name": "Facebook Custom Audiences",
                                "category": "Retargeting"
                            },
                            {
                                "uid": "facebook_login",
                                "name": "Facebook Login (Connect)",
                                "category": "Social Login"
                            },
                            {
                                "uid": "facebook_widget",
                                "name": "Facebook Widget",
                                "category": "Widgets"
                            },
                            {
                                "uid": "google_analytics",
                                "name": "Google Analytics",
                                "category": "Analytics and Tracking"
                            },
                            {
                                "uid": "google_dynamic_remarketing",
                                "name": "Google Dynamic Remarketing",
                                "category": "Retargeting"
                            },
                            {
                                "uid": "google_font_api",
                                "name": "Google Font API",
                                "category": "Fonts"
                            },
                            {
                                "uid": "google_tag_manager",
                                "name": "Google Tag Manager",
                                "category": "Tag Management"
                            },
                            {
                                "uid": "microsoft",
                                "name": "Microsoft Azure Hosting",
                                "category": "Hosting"
                            },
                            {
                                "uid": "mobile_friendly",
                                "name": "Mobile Friendly",
                                "category": "Other"
                            },
                            {
                                "uid": "openssl",
                                "name": "OpenSSL",
                                "category": "SSL Certificates"
                            },
                            {
                                "uid": "outlook",
                                "name": "Outlook",
                                "category": "Email Providers"
                            },
                            {
                                "uid": "youtube",
                                "name": "YouTube",
                                "category": "Online Video Platforms"
                            }
                        ],
                        "org_chart_root_people_ids": [],
                        "org_chart_sector": null,
                        "org_chart_removed": null,
                        "org_chart_show_department_filter": null
                    },
                    "intent_strength": null,
                    "show_intent": false,
                    "email_domain_catchall": true,
                    "revealed_for_current_team": true,
                    "personal_emails": [],
                    "departments": [
                        "c_suite",
                        "master_information_technology"
                    ],
                    "subdepartments": [
                        "information_technology_executive",
                        "information_technology"
                    ],
                    "functions": [],
                    "seniority": "c_suite"
                }
            },
            "API2": "This URL has no default content configured. <a href=\"https://webhook.site/#!/edit/4ac1474e-cfa5-4d2b-bab3-eb601788fad0\">Change response in Webhook.site</a>."
        }
    }
  • Verified answer
    Daniel Bocklandt Profile Picture
    5,099 Super User 2025 Season 2 on at
    Hey, 
     
     
    I think this could help. 
     
    It shows that you need someting like this based on the structure: 
     
    Text( First(ParseJSON( JsonString )).'body'.'API1'.'person'.'email' )
    I'm not sure if you can go 4 levels down. Maybe you'll need to parse twice
    Set(varAPI1,Text( ParseJSON( JsonString ).'body'.'API1' );
    Text( First(ParseJSON( varAPI1 )).'person'.'email' )
    Maybe you'll also need to adapt the first function depending on your needs. 

    But you can test it out and see what works best for you. 

    If this solved your problem, please mark it as Solved to help others find the solution faster.
    If you found it helpful, consider giving it a Like to support each other in this community!

    Thanks, and happy building!

  • Verified answer
    ronaldwalcott Profile Picture
    3,847 Super User 2025 Season 2 on at
    Are you returning the complete JSON to Power Apps using the Respond to Power Apps action then using parseJson in Power Apps to get the values?
     
  • stampcoin Profile Picture
    5,058 Super User 2025 Season 2 on at
    I tested it with different schema, it works. thanks for that.👍👍

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard