read results from "Send an HTTprequest to sharepoint "

[Lk]

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

[v-yuazh-msft · Accepted solution]

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

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".

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

The flow would run successfully as below:

Please let me know if your problem could be solved.

Regards,
Alice Zhang

[Lk]

Thank Yo so much