SOLVED

Build a questionnaire using multiple select answers

%3CLINGO-SUB%20id%3D%22lingo-sub-1485580%22%20slang%3D%22en-US%22%3EBuild%20a%20questionnaire%20using%20multiple%20select%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485580%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20I%20am%20phrasing%20this%20question%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20new%20employer%20(Financial%20services)%20has%20a%20client%20on%20boarding%20process%20that%20relies%20heavily%20on%20Word%20documents%20for%20information%20gathering.%20Many%20of%20the%20forms%20require%20the%20same%20basic%20information.%20Currently%20there%20is%20a%20Word%20doc%20for%20each%20service%20that%20a%20new%20client%20has%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20understand%20if%20it%20is%20possible%20to%20create%20an%20information%20gathering%20Microsoft%20Form%20based%20on%20an%20initial%20multiple%20select%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEG%3A%3C%2FP%3E%3CP%3ENew%20client%20has%20a%20choice%20of%20the%20following%20example%20services%20-%26nbsp%3B%3C%2FP%3E%3CP%3ECompany%20Tax%20Registration%3C%2FP%3E%3CP%3ECompany%20Voluntary%20Strike%20off%3C%2FP%3E%3CP%3EPayroll%20Services%3C%2FP%3E%3CP%3ECompany%20Account%20Management%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20question%201%20would%20be%20a%20multiple%20select%20of%20the%20above%20examples.%3C%2FP%3E%3CP%3EI%20would%20like%20the%20rest%20of%20the%20form%20to%20then%20present%20the%20relevant%20questions%20in%20order%20to%20gather%20the%20predetermined%20information%20based%20on%20services%20required.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20a%20question%20that%20explains%20the%20same%20dilemma%20but%20it%20was%20related%20to%20Adobe%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%22first%20page%20would%20have%20a%20set%20of%20check-boxes%20that%20identify%20what%20information%20is%20needed%20in%20the%20form.%26nbsp%3B%20After%20clicking%20the%20appropriate%20check-boxes%20on%20the%20first%20page%2C%20a%20custom%20version%20of%20the%20form%20would%20be%20generated%2C%20with%20only%20the%20needed%20sub-pages%20displayed.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1485580%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485733%22%20slang%3D%22en-US%22%3ERe%3A%20Build%20a%20questionnaire%20using%20multiple%20select%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F708784%22%20target%3D%22_blank%22%3E%40Brizzo27%3C%2FA%3E%26nbsp%3Byes%20this%20can%20be%20done%20easily%20with%20Forms.%20You%20would%20have%20a%20%3CSTRONG%3E%3CFONT%20color%3D%22%23008080%22%3Esection%3C%2FFONT%3E%3C%2FSTRONG%3E%20for%20each%20of%20the%20example%20services.%20Then%20use%20%3CFONT%20color%3D%22%23008080%22%3E%3CSTRONG%3Ebranching%3C%2FSTRONG%3E%3C%2FFONT%3E%20to%20take%20the%20user%20to%20the%20appropriate%20section%20and%20question%20based%20on%20what%20they%20selected%20in%20Question%201.%20So%20if%20Company%20Tax%20Registration%20was%20selected%20in%20Q1%20then%20you%20would%20tell%20the%20form%20to%20branch%20to%20the%20first%20question%20the%20Company%20Tax%20Registration%20section%20and%20then%20down%20to%20each%20of%20the%20subsequent%20questions%20in%20that%20section%20until%20you%20got%20to%20the%20last%20question%20which%20would%20then%20branch%20to%20the%20end%20of%20the%20form.%20Same%20with%20each%20of%20the%20other%20services.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22branching2.png%22%20style%3D%22width%3A%20797px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200701i80CE436CD9414989%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22branching2.png%22%20alt%3D%22branching2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485752%22%20slang%3D%22en-US%22%3ERe%3A%20Build%20a%20questionnaire%20using%20multiple%20select%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485752%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAh%20I%20see%2C%20so%20a%20section%20first%20for%20each%20service%2C%20then%20branching.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20try%20this%20now%20and%20revert.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485753%22%20slang%3D%22en-US%22%3ERe%3A%20Build%20a%20questionnaire%20using%20multiple%20select%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F708784%22%20target%3D%22_blank%22%3E%40Brizzo27%3C%2FA%3E%26nbsp%3Badd%20the%20sections%2C%20then%20add%20the%20questions%20in%20each%20section%20and%20finally%20do%20the%20branching.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485780%22%20slang%3D%22en-US%22%3ERe%3A%20Build%20a%20questionnaire%20using%20multiple%20select%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485780%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20have%20not%20misunderstood.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20advise%20if%20they%20were%20to%20select%20multiple%20options%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20you%20describe%20works%20well%20for%20one%20service%3A%3C%2FP%3E%3CP%3ECompany%20Tax%20Registration%20Required%20-%26gt%3B%20Yes%20-%26gt%3B%20Branch%20to%20the%20relevant%20section%20-%26gt%3B%20complete%20details%20-%26gt%3BSubmit%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20they%20also%20wanted%20to%20add%20more%20services%2C%20how%20can%20this%20be%20built%20in%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20new%20company%20would%20like%20to%20have%20the%20services%20%22Tax%20Registration%22%20and%20%22Salary%20Services%22%2C%20but%20are%20not%20interested%20%22Voluntary%20Strike-Off%22%20services.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESection%201%3A%20%22Tax%20Registration%22%20-%26gt%3B%20Yes%3C%2FP%3E%3CP%3ESection%202%3A%20%22Salary%20Services%22%20-%26gt%3B%20Yes%3C%2FP%3E%3CP%3ESection%203%3A%20%22Voluntary%20Strike-off%22%20-%26gt%3B%20No%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20a%20bunch%20of%20fields%20relating%20to%20those%20selections%20would%20show.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20be%20done%20in%20forms%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20build%20a%20form%20based%20on%20multiple%20previous%20answers%2C%20rather%20than%20branching%20to%20terminate%20after%20one%20selection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485810%22%20slang%3D%22en-US%22%3ERe%3A%20Build%20a%20questionnaire%20using%20multiple%20select%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485810%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F708784%22%20target%3D%22_blank%22%3E%40Brizzo27%3C%2FA%3E%26nbsp%3Bno%20that%20isn't%20possible%3A%20as%20branching%20won't%20work%20the%20same%20way%20with%20multi-select%20answers.%20They%20would%20need%20to%20complete%20a%20form%20for%20each%20service%20they%20required.%20Branching%20from%20an%20individual%20response%20in%20a%20multi-select%20answer%20isn't%20do-able%2C%20you%20can%20only%20branch%20to%20a%20specific%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

I am not sure I am phrasing this question correctly.

 

My new employer (Financial services) has a client on boarding process that relies heavily on Word documents for information gathering. Many of the forms require the same basic information. Currently there is a Word doc for each service that a new client has available.

 

I would like to understand if it is possible to create an information gathering Microsoft Form based on an initial multiple select question.

 

EG:

New client has a choice of the following example services - 

Company Tax Registration

Company Voluntary Strike off

Payroll Services

Company Account Management

 

So question 1 would be a multiple select of the above examples.

I would like the rest of the form to then present the relevant questions in order to gather the predetermined information based on services required.

 

I found a question that explains the same dilemma but it was related to Adobe:

"first page would have a set of check-boxes that identify what information is needed in the form.  After clicking the appropriate check-boxes on the first page, a custom version of the form would be generated, with only the needed sub-pages displayed."

 

Thank you

5 Replies
Highlighted

@Brizzo27 yes this can be done easily with Forms. You would have a section for each of the example services. Then use branching to take the user to the appropriate section and question based on what they selected in Question 1. So if Company Tax Registration was selected in Q1 then you would tell the form to branch to the first question the Company Tax Registration section and then down to each of the subsequent questions in that section until you got to the last question which would then branch to the end of the form. Same with each of the other services.

 

branching2.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

Ah I see, so a section first for each service, then branching.

 

I will try this now and revert.

 

Thank you very much.

Highlighted

@Brizzo27 add the sections, then add the questions in each section and finally do the branching.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@Rob Elliott 

 

Hi, 

 

I hope I have not misunderstood.

 

Can you advise if they were to select multiple options?

 

How you describe works well for one service:

Company Tax Registration Required -> Yes -> Branch to the relevant section -> complete details ->Submit

 

But if they also wanted to add more services, how can this be built in?

 

An example:

 

A new company would like to have the services "Tax Registration" and "Salary Services", but are not interested "Voluntary Strike-Off" services.

 

Section 1: "Tax Registration" -> Yes

Section 2: "Salary Services" -> Yes

Section 3: "Voluntary Strike-off" -> No

 

Then a bunch of fields relating to those selections would show.

 

Can this be done in forms?

 

To build a form based on multiple previous answers, rather than branching to terminate after one selection.

 

Thank you

 

Highlighted
Best Response confirmed by Brizzo27 (New Contributor)
Solution

@Brizzo27 no that isn't possible: as branching won't work the same way with multi-select answers. They would need to complete a form for each service they required. Branching from an individual response in a multi-select answer isn't do-able, you can only branch to a specific section.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User