Getting MS Forms choice responses into Sharepoint List Columns

(0) Share

Report

Posted on by BG-28051430-0

Hello,

I have a flow set up that takes MS Forms responses and puts them in a Sharepoint list. One of the questions (see snip below) has a response with quite a few choices. Responders can select multiple choices if applicable. I would like these choices to populates under the "Involved Asset(s) column in the Sharepoint list. However, they are populating in a strange format - please see snip below. The response should be populated like the first item in the list but they are showing up with unwanted brackets and quotes. I am not sure if I have not set the flow up correctly.. Any suggestions would be much appreciated.

Thank you!

Categories:

Business Process Flows

All responses (20)

Answers (0)

BG-28051430-0 24 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

@David_MA,

I updated with the same steps you advised on. The initialize variable step is just at an earlier step in the flow. Many different items can be created in SP depending on a condition but the select step is not in an apply to each loop. If you're not sure, no worries. I can go back to the HTTP route and figure that out. Thanks.
David_MA 11,329 Super User 2025 Season 1 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

I am not exactly sure what you're doing based on the screen shot, but it is not what I illustrated below when using the update item action. You may want to review that again. The select action should not be within an apply to each action.
BG-28051430-0 24 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

Hi @David_MA,

This seems to have added some additional values to the single bubble in the column. In the flow, automate seems to be defaulting to the "current item" from the apple to each step above. It was also automatically putting the "Update item" into an apply to each loop as well. I am not sure why?
David_MA 11,329 Super User 2025 Season 1 on at

Like (0)

Report
Getting MS Forms choice responses into Sharepoint List Columns

What you show in your screen shot is correct. Just make sure your cursor is in the "Enter Value" field in the Select action and then press the "Add" button in the expression builder. Otherwise, switch the Select action to text mode by clicking on the icon to the right of map and you should be able to copy and paste the following:

{ "Value": @{item()} }

Although in the screen shot you have the update item action in an Apply to each. Why?
BG-28051430-0 24 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

@David_MA,

Things change! I seem to be having trouble at the Select step. I cannot seem to build the appropriate expression or find the right dynamic content. I have tried inserting the Sharepoint item ID in the expression and other outputs. Let me know what I might be missing. Thank you!
David_MA 11,329 Super User 2025 Season 1 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

I could have sworn this used to work. I don't know if something changed or I am forgetting something. We'll need to use the alternate method using the Update Item action instead of using an HTTP request. I like the HTTP request because it allows you to specify just the column(s) you want to update and you don't need to worry about the required fields. Do this instead:

The manual trigger will represent your trigger of when a forms response is submitted, and the get item action will be the get response details action.

The Apply to each adds each choice selected in the forms response to the array variable:

In the Compose action, insert the variable:

In the select action, set it up as show:

Use the expression item() from the expression builder to insert item in the right side of the map.

In the update item action, put your multiple-choice field into array mode by clicking on the icon to the right of the field name and insert the output of the Select action:

Hopefully someone will spot what I was doing wrong with the HTTP method, as I prefer it over using the Update item action especially if you have a list with a lot of required fields.
BG-28051430-0 24 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

Hi @David_MA,

It's still returning the two choice result as one bubble separated by a semi-colon. Would the "split" function work to separate as per screen shot below? The upper row is the desired formatting
David_MA 11,329 Super User 2025 Season 1 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

Try updating the body of the HTTP request to remove the quotes around the join() expression. I believe that expression will return the values in quotes, so in essence it is sending the HTTP request with a double set of quotes, which is causing the issue.
BG-28051430-0 24 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

@David_MA, see below. Thx!
David_MA 11,329 Super User 2025 Season 1 on at

Like (0)

Report

Getting MS Forms choice responses into Sharepoint List Columns

Please share the configuration of the HTTP action and the configuration of the field in the SharePoint list.