Forum Discussion
Microsoft Forms - Branching question
No this isn't possible with Microsoft Forms. You can't assign different points depending on which option is chosen. I suppose you could do a very clunky workaround where you would create a quiz and have a question for each option, for example "Is the size of your audience between 1 and 100?" but that would be a horrible user experience.
Branching is for when the user is answering the questions and is a route through the form/quiz. So if they select Option 1 it goes to a different section, Option 2 goes to another section and so on. Only once they have answered all the questions does the Submit button appear.
Also, once the Submit button has been clicked it's not possible to then go to a different screen, the user just sees the thank you screen with or without a message which has to be entered by you when you create the form, it's not dynamic.
So what are the options?
1. if your users are all internal then you could do this with a fairly simple app in Power Apps. I've built a quick demo of this and it's shown in the attached video.
You can use a switch function to set the value of a variable based on the item selected. For example I've set the variable varIsland with the following (there are also variables for varAirline, varHotel and varDish). In the image above Martinique has been selected which has set varIsland to 30.
Switch(cbIsland.Selected.Value,
"Aruba",Set(varIsland,10),
"Guadeloupe",Set(varIsland,20),
"Martinique",Set(varIsland,30),
"Turks and Caicos",Set(varIsland,40
)
)Then set the variable of the overall score with varIsland+varAirline+varHotel+varDish.
You can then have a Submit button which a) saves the items selected and the score to a SharePoint list and navigates to the next screen where there are several text fields for the feedback, the visibility of each one is determined by the score. the code for the visibility property (for a score of 80) would be
If(Value(varScore) >=41 && Value(varScore) <=80, true, false)
2. If your users include external people then you could take the scores from the Microsoft Form, save the details to the SharePoint list. In your flow initialise an integer variable and add an increment variable action to add up the scores. Then, again, use a Switch action in the flow based on the total score to determine what text would go into an email to be sent to the submitter. I haven't built an example of this as I have a meeting in a few minutes, but can do so if you need it.
My preferred option from these 2 is the app as it's cleaner and a better experience for the user. But it does depend where the users are.
The app displays the score but this could be hidden so the user doesn't see it, but the functionality would still work.
I hope that's useful but do come back with any questions.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)