Unanswered

Removing JSON from Multi-Choice Responses When Taking Responses from MS Forms to Sharepoint List

(0) Share

Report

Posted on by Jacozin

Hello,

I have built a flow take responses from MS Forms and populate a SharePoint list with them. With multi-choice questions, when they are copied over to the SharePoint list, they always have '[{"Value": }]' and I cannot find a way of getting rid of it. Here is an example:

In the above screenshot, I have used the select function to create items out of the responses to this multi-choice question. The code in the 'From' field is this:

if(empty(outputs('Get_response_details')?['body/r53416eabc6444e24bcb22c25ab0c77e4']),createArray('No response'),json(outputs('Get_response_details')?['body/r53416eabc6444e24bcb22c25ab0c77e4']))
 
Then I put the output of this into the corresponding field in the SharePoint list in the Create Items action:
 
And every time a response is given it has '[{"Value": }]" around the responses. Is there any way to get rid of that?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Chriddle 8,713 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
An answer to a multiple choice question is an array similar to the one I entered into Compose.

The expression in Compose 2 checks if the array is empty.
If so, it returns "No response".

Otherwise, it creates an XML from the array and queries each "Value" (this returns an array of values).
Then it joins those values with a semicolon.

if( empty(outputs('Compose')), 'No response', join( xpath( xml( json( concat( '{"Root":{"Item":',outputs('Compose'), '}}' ) ) ), '//Item/Value/text()' ), ';' ) )

Was this reply helpful? Yes No
Jacozin 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@Chriddle

Thanks for your reply. I did try this but it didn't work for me; it wasn't picking up any response from the form and was not printing 'No response'.

Was this reply helpful? Yes No
Chriddle 8,713 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you replaced both occurrences of outputs('Compose') in my expression with your corresponding array?

Probably with outputs('Get_response_details')?['body/r53416eabc6444e24bcb22c25ab0c77e4']

Was this reply helpful? Yes No