cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lk
Frequent Visitor

read results from "Send an HTTprequest to sharepoint "

Hi ,

I have results like below

{
  "d": {
    "results": [
      {
        "__metadata": {

     },
        "Title""xxxxxx",
        "Email""xxxx@xxx.com"
      }
    ]
  }
}

Am trying to parse the above response but unable to do by using parseJSON but if I click on Use sample payload  to generate schema.It is not generating the schema automatically.Can you please guys help me on this how I generate schema then I will use that information in another action

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @ Lk,

 

Do you want to information from the response you provided?

 

I have made a test on my side,please refer to steps below to create the flow:

1.Add a trigger,my trigger is "Manually trigger a flow".

2.Add action "Parse JSON",Enter or paste the response you provided into the "Content" field of the "Parse JSON".

Click the "Use sample payload to generate schema" and then Enter or paste the response you provided in the pup up window.Click down and the schema is generate at the same time

Capture.PNG

3.You could add a Compose ,and then you could choose the dynamic content of the "Parse JSON" in the Compose.maybe an "Apply to each would be added automatically".

Capture.PNG

 

4.Make a tesk  to get the "Title" of the response, the flow would as screenshot below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Regards,
Alice Zhang

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

Hi @ Lk,

 

Do you want to information from the response you provided?

 

I have made a test on my side,please refer to steps below to create the flow:

1.Add a trigger,my trigger is "Manually trigger a flow".

2.Add action "Parse JSON",Enter or paste the response you provided into the "Content" field of the "Parse JSON".

Click the "Use sample payload to generate schema" and then Enter or paste the response you provided in the pup up window.Click down and the schema is generate at the same time

Capture.PNG

3.You could add a Compose ,and then you could choose the dynamic content of the "Parse JSON" in the Compose.maybe an "Apply to each would be added automatically".

Capture.PNG

 

4.Make a tesk  to get the "Title" of the response, the flow would as screenshot below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Regards,
Alice Zhang

Lk
Frequent Visitor

Thank Yo so much

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 (4,329)