Forum Discussion

Keith_T's avatar
Keith_T
Copper Contributor
Mar 13, 2025

Microsoft Forms - Branching question

Hi all,

I have just joined these forums and this is my first post. 

Is it possible to do the following with Microsoft Forms and if so, how?:-

  1. Create a form in Microsoft Forms with 4 multiple choice questions.

  2. Each answer/option for each of these questions has a number of points allocated to it,
    for example, option1 has 10 points, option2 has 20 points and option3 has 30 points etc.
    (See below)
    Question:- "What is the size of the audience for your in-house training?-
     Select one answer:
    Option1:- 100 - (10 points)
    Option2:- 500 - (20 points)
    Option3:- 2000 - (30 points)
    Option4:- 10,000 - (40 points)

    The user does NOT see how many points are allocated per possible answer and all the other questions are like this. 

  3. Once the user has selected their respective answers, they are required to click a SUBMIT button at the bottom of the screen.

  4. Depending on how many points they have accumulated, they will see a different feedback screen, for example, if they have just "scored" 40 points, they will see the FIRST information/feedback screen with some text, a link and a graphic (if possible).

    If they have scored 60 points, they will see the SECOND information/feedback screen.

    This also applies if you get 80 or 100 points and you get different feedback depending on how many points you have "scored" as this form has a branching methodology with the form itself linking to 4 different screens or HTML pages with this feedback.

    Now million dollar question as before... Is this possible?
    If so, how can I do this and do I have to use some other kind of technology like Power Automate etc in conjunction with Microsoft Forms.

    I look forward to hearing from you.

    Thanks in advance.

Keith

 

microsoft forms
power automate

1 Reply

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Mar 14, 2025

    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)

Resources