cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

extract data from json array

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
1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

1 REPLY 1
abm
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,783)