Forum Discussion
Multiple Choice answers with branching per answer
Forms is like someone's pet project at Microsoft and is not really advanced. It is definitely clunky and hope there will be more advancements as most often we run into this above scenario. A combination of two questions decides further sets of questions.
KumarHari007 we are needing to do the same thing.
Karen2021 in all the posts mentioning other platforms no-one has answered the problem of how they or Microsoft could possibly implement branching on multiple select options in a question. With 8 choices there are 40,320 possible branching combinations. I just don't think there is any way Forms will ever offer this level of complexity.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Sorry to reopen an old thread, but this isn't really that complicated if you think of the feature as show/hide as opposed to creating individual branches that need to be pre-coded. If option 1 is selected, show subsequent section 1. If option 1 is not selected, do not show section 1. "Rinse and repeat." Final output table has all sections, but blank responses (or even a non-shown code?) for non-shown questions. This is how other platforms handle this.
- We currently use Nintex forms and Nintex, for all its faults, has an entire Rules section you can apply to each form. The rules allow you to write out the If/Then statements someone else suggested and I would LOVE for Microsoft to implement something similar within Forms.
- what if, instead of all possible permutations, the presence of a check on any of the multi-selects could show an additional follow up question. By implementing it this way, each option of the multi-choice question could be treated as an atomic interaction; the only permutations at that point are on and off. It would be easier for the user to complete than separating out each response into a separate question. The case I'm trying to solve for is a form responded identifying which role(s) they play in a system. Any individual may play multiple roles. With some of the roles I want to collect additional data which would be nonsensical to other of the roles.
RobElliott That's true, it can't be done with conditional branching on multiple select questions. In my response on June 23rd I said much the same thing and suggested a practical alternative would be conditional questions. e.g. Show question 4 if the respondent ticked 2a,2b, but not 2d. Multiple questions can show conditionally based upon the responses to a single multiple choice. This approach can extend further to make questions conditional upon responses to multiple preceding questions too.
