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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / extract data from json...
Power Automate
Answered

extract data from json array

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi community,

 

I have a flow that receives following schema of an json object via HTTP POST request from an other flow.

 

schema:

{
    "type": "array",
    "items": {
               "type": "object",
               "properties": {
                   "LieferscheinID": {
                        "type": "integer"
                    },
                   "EmailEmpfaenger": {
                    "type": "string"
                   }
               }
          }
}
 
 the output data looks as follows:
{
  "LieferscheinID" : "1",
  "EmailEmpfaenger": "john.doe@123fakecompany.com"
}
 
Now, I need to extract the data as two separate variables, e.g. varID = 1 and varEmail=john.doe@123fakecompany.com
in order to use them for further steps in the flow.
How can I do that?
 
Thanks in advance
Categories:
I have the same question (0)
  • Verified answer
    abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

    1. Add a Parse JSON action step and set the Content mapping as output of your previous step.
    2. Click Generate from Sample
    3. Under Insert a sample JSON Payload copy the values from your compose step. Generally you can copy this from your run history or if you have a sample JSON data which you are going to receive.
    4. Click done.
    5. Next action on wards you can see all the dynamic properties from your JSON schema.

  • slx Profile Picture
    108 on at

    Hi

     

    if i have a json structure 

    parent

    child1

     subchild1 field

     subchild2 field

    child 2

     subchild3 field

     

    how do i extract all fields under child1 only? If i parse i get leaves/fields bit i want to send child1 as parameter to a different process

     

    thank you

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 535

Last 30 days Overall leaderboard