MS Form multi-response question to SharePoint List Issue

(0) Share

Report

Posted on by ChrisS81

134

Hello,

I'm running to an issue where I have multi-response question in MS Form and I'd like for each response to display in a Choice column within SharePoint Lists. It's currently displaying as:

["Option 1", "Option 2", "Option 3", etc.]

I need the responses to display without the bracket, commas, and quotes and display in it's own choice "bubble" in the SharePoint List. I'd like it to look like this:

Where each selection on the form displays in the List as a separate choice that can be filtered by and whatnot.

Any help would be greatly appreciate.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @ChrisS81 if the name of your action is outputs('formsresponse') you can add at the end ?[0] to get the first item on your array that is option 1.

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (1)

Report

Hi @ChrisS81

According to your description, you want to create the multiple-choice answers submitted in the Form into a column which type is multiple-choice in sharepoint list. If any misunderstanding, please kindly let me know.
I set up a simple Flow, you can refer to as below:

This is my list:

'Color' column is a choice column and allow multiple selections.

Please note that change the details inputs for array item to input entire array, then fill in the output of the select action in the filed.

Then save Flow and can test it.

When a form is submitted as below:

New item will be created as below:

Hope the content above may help you.

Best Regards

If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ChrisS81 134 on at

Like (0)

Report

@v-LilyW-msft ,

Thanks for the detailed response. I'm having an issuing with switching to input entire array. I don't have the option to do that.

I'm expecting to see the option it in the "Type of Issue" field but it doesn't display. Any ideas?

Was this reply helpful? Yes No
ChrisS81 134 on at

Like (0)

Report

@v-LilyW-msft ,

Please disregard my last message. I figured out the reason why "Switch to entire input array" did not display. I didn't allow for multiple answers within the List column settings 🙃. Once I allowed for multiple answers I was good to go. It now works as intended. Thank you so much!

Was this reply helpful? Yes No