Forum Discussion
Annette1101
Jan 23, 2025Brass Contributor
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 fl...
Kidd_Ip
Jan 24, 2025MVP
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
Jun 03, 2025Copper 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.