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
Solved! Go to 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
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
Thank Yo so much
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
45 | |
18 | |
15 | |
14 | |
12 |
User | Count |
---|---|
81 | |
34 | |
29 | |
21 | |
20 |