Microsoft Forms - Branching Question

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

Answer 1

Hi, Keith Trodden

Thanks for choosing Microsoft Community.Understanding your problem.Microsoft Forms itself does not support directly assigning scores to options and jumping based on total scores; the branching feature of Forms primarily jumps based on the answers to individual questions, rather than accumulating scores. Therefore, it is necessary to use Power Automate in combination to realize this function.You will also need Microsoft 365 Enterprise or Developer account permissions.Here are the steps you can follow:Step 1: Create a Microsoft Forms FormCreate a new form and add 4 multiple choice questions.Set the answer options and turn off Show Summary of Results.Step 2: Setting Up Automated Flows in Power AutomateOpen Power Automate and create a new Automated cloud flow.Select the trigger: “When a new response is submitted by Microsoft Forms”.Select the Microsoft Forms form you just created.Add a Get response details action to extract the user's response.Step 3: Calculating ScoresAdd an “Initialize variable”:- Name: TotalScore- Type: Integer- Value: 0Create Condition logic for each question:- If the user selects option 1, then TotalScore + 10- If the user selects option 2, TotalScore + 20- And so on ......Use the Increment variable operation to accumulate scores.Step 4: Jump to different feedback pages based on scoresAdd a Condition:- If TotalScore = 40, send an email or update the SharePoint page to send the user to the first feedback page.- If TotalScore = 60, go to the second feedback page and so on.- And so on ......Use Send an email or Send a notification to provide the user with a link to the correct feedback page.Once the above steps are completed, you can test and check the results.It is important to note that the steps we have provided are for reference only and the exact results obtained may vary depending on the specific issue or detailed settings.If you have any other concerns or questions, please ask and we will do our best to help you.Best Regards,Kyra – MSFT | Microsoft Community Support Specialist