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 Automate / extract data from json...
Power Automate
Unanswered

extract data from json array

(0) ShareShare
ReportReport
Posted on by

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,865 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

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 Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard