Getting value from Microsoft forms "Other" choice and showcasing it on Sharepoint

(1) Share

Report

Posted on by SM-25071546-0

My form has a question with 3 choices, along with the optional "Other" field, with the option to select multiple answers. I have a Power Automate workflow which puts the responses on to a List on our Sharepoint. When the other option is filled in, my form records the response, however, Sharepoint does not showcase any of the choices, no matter how many are selected. I believe it is due to using the multiselect option in conjunction with the "Other" option that my solution is not currently working. I am using the "Select" data operation to modify the JSON value of the response detail to map it to the current item, then using the output of that as the input of the "Create item" action concerning the field I want to be populated on the Sharepoint. My Sharepoint list column type is set as "choice" with the 3 choices having the exact same wording as the form, along with the option to enter manual values being enabled, and multiple options selection is also enabled. I want the selected options to be displayed like the neighboring column "Estimate Type".

Is there a fix for this? Thanks.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

You'll need to parse the multi-choice selections. I cover how to do that in this YT Tutorial: How to Get a Microsoft Form RSVP Response into a SharePoint List

In this Microsoft Power Automate tutorial, I’ll show you how to get your Microsoft Form responses into SharePoint. I’ll cover how to build a Microsoft form with conditional fields by using branching. You’ll learn how to format your multiple choice responses for a SharePoint multi-choice column as well as converting it to text. I’ll also show you how to take a text response and convert it to a number with a switch action and with an expression. After adding the response to SharePoint, we’ll send the user an email confirmation with all the details of their form submission.

Also in the tutorial:
✅ How to get a Microsoft Form Response into SharePoint
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form response
✅ How to Build a Microsoft Form with Conditional Fields
✅ How to used Branching in Microsoft Forms
✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column
✅ How to parse a Microsoft Form multiple choice response as string of text
✅ How to convert a text response to a number
✅ How to use the Switch action
✅ How to create a custom email confirmation for a Microsoft Form submission
✅ How to Create a Custom View in a SharePoint list
✅ How to use the Compose Action
✅ How to write Power Automate Expressions

If you still have issues after watching the tutorial, upload a screenshot of where you are stuck. Ensure you toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
Suggested answer

SM-25071546-0 4 on at

Like (0)

Report

The fix was to close the computer and to come back to it after a while. The original flow worked without any changes.

Was this reply helpful? Yes No