Forum Discussion

Annette1101's avatar
Annette1101
Copper Contributor
Jan 23, 2025

Power Automate - when a form is submitted: Other choice text

I have a flow that will write details from a form when submitted. One question in the form is a choice field with an "other" option where they can enter text for the other option. I would like the flow to write "Other" as the choice column value in the SharePoint list and then take what they type in the form for the other text to be written to another SharePoint list column as the text of the other option. This will keep the column formatting on the list view consistent for the values in the choice column. Any ideas?

3 Replies

  • Try this out:

     

    • Create a New Flow: Go to Power Automate and create a new automated flow.
    • Trigger: Set the trigger to "When a new response is submitted" in Microsoft Forms.
    • Get Response Details: Add the "Get response details" action to retrieve the form submission details.
    • Condition: Add a condition to check if the choice field value is "Other".
    • If Yes: If the condition is true (i.e., the choice is "Other"), add an action to create an item in the SharePoint list with "Other" as the choice column value.
    • If No: If the condition is false, add an action to create an item in the SharePoint list with the selected choice value.
    • Add Text Field: For the "Other" option, add an action to create an item in another SharePoint list with the text entered in the form as the value for the text field.
      Trigger: When a new response is submitted (Microsoft Forms)
      Action: Get response details (Microsoft Forms)
      Condition: If choice field value is "Other"
          If Yes:
              Action: Create item in SharePoint list (with "Other" as choice column value)
              Action: Create item in another SharePoint list (with form text as text field value)
          If No:
              Action: Create item in SharePoint list (with selected choice value)
      

       

    • Mike_C96's avatar
      Mike_C96
      Copper Contributor

      If we had a form with questions that didn't require a response, would we have to create a condition for each item? I have a MS Form with 50 questions and a Word doc that gets populated with the answers. I want to return a specific text ("Intentionally unanswered") for any question that gets skipped, but it sounds like I'd have to create 50 conditions to check each question for blank responses.

    • Annette1101's avatar
      Annette1101
      Copper Contributor

      Thank you for your reply, but the "other" column in the MS Form, really isn't "Other". It indicates that in the text field where you would type your "other" response value. So if I had a list of options that was Red, Blue, Green, and then the last choice option was "other" I would type in my response. My text of the response wouldn't be other, it would be something like "Yellow". So a condition on "other" would never pass unless someone actually entered "other". 

      I was able to get around it by not using the "other" choice column that the form suggested but entered a real Option call Other. Then I did branching on the question and if the person picked Other, a new question was asked having them type in what their other option is. I can then use the logic you noted above!

Resources