This flow retrieves the questions and answers and combines them into an array of corresponding objects:
Send an HTTP request to SharePoint
Since the questions are not included in the response details, you have to get them with a request to Form API.
Site Address: https://forms.office.com/
Method: GET
Uri: /formapi/api/forms('@{concat(triggerBody()?['resourceData']?['formId'])}')?$expand=questions
Select
From
The first 2 properties of "Get reponse details" are skipped, because they are metadata (responder and submitDate) and should be handled seperately, iof needed.
skip(
xpath(
xml(json(concat('{"Root":',body('Get_response_details'),'}'))),
'/*/*'
),
2
)
Map Question
xpath(
xml(json(concat('{"Root":{"Item":',body('Send_an_HTTP_request_to_SharePoint')['questions'],'}}'))),
concat(
'string(//Item[id="',
xpath(
item(),
'name(/*)'
),
'"]/title)'
)
)
Map Answer
xpath(
item(),
'string(/*)'
)
Result:
[
{
"Question": "Test Question 1",
"Answer": "Anser 1a"
},
{
"Question": "Test Question 2",
"Answer": "Answer 2 a"
}
]
From here you can easily reformat it to your liking.
E.g.
Select 2
From
body('Select')
Map
concat(item()['Question'], ': ', item()['Answer'])
Compose
join(body('Select_2'), decodeUriComponent('%0A'))
