Others

How to Create Microsoft Forms Branching Based on Total Score

Tauseeq Magsi Sep 27, 2026 869 views

Question details

The user wants to calculate hidden point values from responses and display customized feedback pages based on the total score immediately after submission.

How to Create Microsoft Forms Branching Based on a Total Score

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating an assessment, quiz, or survey where the final feedback or redirection depends on the cumulative score of the respondent's answers.
Observed behavior: Microsoft Forms can only branch based on individual answers. It lacks the native ability to calculate hidden point values and display different result pages based on a total score post-submission.

Before you start

Ensure you have an active Microsoft 365 subscription with access to both Microsoft Forms and Power Automate, as you will need to build an automated workflow to calculate the scores.

Solution 1Recommended

Use Power Automate to Calculate Total Score and Send Feedback

Since Microsoft Forms cannot branch based on total scores natively, you can use a Power Automate flow to evaluate the submitted answers, calculate a total score, and email the appropriate feedback page link.

This solution works by capturing the form response upon submission. By setting up variables in Power Automate, you can assign point values to specific answers, sum them up, and then use condition blocks to determine which feedback email to send to the respondent.

Create your Microsoft Form

Set up your Microsoft Form with the necessary questions and options. Ensure you have a field asking for the respondent's email address if it is not recorded automatically.

Set up the Power Automate Trigger

Log into Power Automate and create an 'Automated cloud flow'. Select 'When a new response is submitted' as the trigger and choose your form from the dropdown menu.

Get Response Details

Add a new action called 'Get response details'. Select your Form ID again and insert the 'Response Id' dynamic content into the corresponding field.

Initialize a Total Score Variable

Add an 'Initialize variable' action. Name it 'TotalScore', set the type to 'Integer' or 'Float', and set the initial value to 0.

Calculate the Score

Use 'Condition' or 'Switch' actions for each question. For example, if Question 1 equals 'Option A', add an 'Increment variable' action to increase 'TotalScore' by your desired point value.

Send Conditional Feedback

Add a final 'Condition' block at the end of the flow to evaluate the 'TotalScore' variable. Based on the score range, use the 'Send an email (V2)' action to deliver specific text, links, or graphics to the respondent.

Use Power Automate to Calculate Total Score and Send Feedback

Automated Delivery: While this does not change the immediate 'Thank You' page in Forms, it provides a seamless automated way to deliver accurate, score-based results directly to the user's inbox.

Solution 2

Build a Custom App with Power Apps for Real-Time Result Pages

If you require respondents to see customized results with text, links, and graphics immediately on-screen after submission, consider building a canvas app in Power Apps instead of using Forms.

Free Microsoft Office alternative

Try WPS Office for Your Everyday Productivity Needs

While complex logic and conditional branching integrations require tools like Microsoft Power Automate, WPS Office is an excellent free alternative for handling your everyday document creation, spreadsheet calculations, and presentations. Enjoy a lightweight suite that boosts your efficiency without the heavy subscription fees.

Highly compatible with Microsoft Office formats (Word, Excel, PowerPoint)Lightweight installation with fast loading and responsive performanceFamiliar, easy-to-use interface that makes migration seamlessBuilt-in PDF editing tools for comprehensive document handling

microsoft office alternative - wps office

Frequently Asked Questions

Can I assign hidden point values directly in Microsoft Forms?

No, Microsoft Forms does not have a feature to assign hidden point values to options for background calculation. Its native branching feature only works based on the specific option chosen for an individual question.

Does Microsoft Forms Quiz mode allow custom end pages based on the score?

While Quiz mode can calculate a score and display total points to the respondent upon submission, it cannot dynamically redirect them to different web pages or display customized feedback screens based on that score.

What is the best alternative to get total score branching?

The most common workaround is integrating Microsoft Forms with Power Automate. By doing this, you capture each response in a flow, assign custom point values in variables, calculate the sum, and trigger emails with tailored feedback based on the result.

Office Quick Solutions