Forum Discussion
Branching multiple questions to another
alyssa1230 ok you build this as follows. Each of the 20 yes/no choice questions should be in its own section together with the text (long answer) explanation question. Give Section 1 a short title then add the choice question followed by the text question. I strongly advise you to make the text questions unique, but if that is difficult or the question is long add something at the beginning like Back: or Chest: etc to help you identify the correct question later on in the branching. See also the last paragraph in this post for another reason for doing this.
The choice questions should be set to required. The text question must be set to not required.
Branching
Click one of the add branching links. For the first section, if the No answer is selected then branch to the next Section. If the yes answer is chosen then branch to the text question in the same section. Make sure the Go to dropdown at the bottom of the section is set to Next.
Do the same for each of the sections until you get to the last section
For the last section, if No is selected branch to the end of the form. If Yes is selected branch to the final text question and at the bottom of the form in the Go to dropdown select End of the form.
I've only built this with 4 sections so it was quick to do. Yours will take a bit longer but I hope this is useful.
Power Automate and SharePoint
At my company we always save each response into a SharePoint list via a flow in Power Automate. This is for audit reasons and to ensure that we have a backup of each response in case something goes wrong with the spreadsheet behind the form - it's never happened to us but there are lots of reports of it on the forum. The SharePoint list has a column for each question:
In the flow when you use the Create item action you can't usually see the whole question as you'll see in the image below, so having something early in the question that helps identify reduces error and makes things quicker for you. A simple example flow for this questionnaire is shown below:
So when a new response is submitted the flow will pick it up and save it to the list with the following result:
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Hello alyssa1230 !
Yes, you can achieve this with branching logic in Microsoft Forms, but you’ll need to set up separate branches for each question. Create one explanation question at the end of the form. Then, for each Yes/No question, set branching so that if the user selects Yes, they are directed to the explanation question, and afterward, they return to the next question in the form. Ensure that after completing the explanation, they are directed back to the remaining questions so they don’t miss any.
For more detailed instructions, refer to this guide: https://plumsail.com/blog/microsoft-forms-branching-guide/ Forms Branching Guide.