Others

How to Set a Minimum Passing Score in Microsoft Forms

Khadija Khan Oct 10, 2026 870 views

Question details

The user wants to set a minimum passing score and an automatic retake option for quizzes created in Microsoft Forms.

How to Set a Minimum Passing Score in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a quiz and attempting to require respondents to achieve a certain score to pass, or automatically prompting them to retake the quiz if they fail.
Observed behavior: Microsoft Forms currently lacks a native, built-in feature to set a minimum passing score or automatically trigger retakes for failed quizzes.

Before you start

Since Microsoft Forms does not have a native passing score feature, ensure you have access to Microsoft Power Automate if you plan to use automated workarounds to manage scores and retakes.

Solution 1Recommended

Use Power Automate to Evaluate Scores and Trigger Actions

Create a custom flow in Power Automate to evaluate quiz scores and automatically email respondents if they need to retake the quiz.

While Microsoft Forms lacks a built-in passing score feature, you can integrate it with Microsoft Power Automate to handle the logic. This allows you to evaluate the score upon submission and automatically notify users whether they passed or failed.

Open Power Automate

Set the Trigger

Choose the trigger 'When a new response is submitted' for Microsoft Forms and select your specific quiz from the dropdown menu.

Get Response Details

Add the 'Get response details' action to pull the user's score and email address from the form submission.

Add a Condition

Insert a 'Condition' control to check if the total score is greater than or equal to your desired passing score.

Configure Email Notifications

In the 'If Yes' branch, add an action to send a congratulatory email. In the 'If No' branch, add an action to send an email containing the form link, prompting the user to retake the quiz.

Use Power Automate to Evaluate Scores and Trigger Actions

Power Automate Community Help: If you need specific implementation help for your custom flow, the Microsoft Power Automate Community forum is an excellent resource for detailed guidance.

Solution 2

Submit a Feature Request to Microsoft

Submit a request on the Microsoft Feedback Portal to encourage developers to add a passing score feature natively.

Free Microsoft Office alternative

Looking for a Better Office Experience? Try WPS Office

While dealing with Microsoft Forms limitations, consider optimizing your overall productivity suite. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office, offering Word, Excel, PowerPoint, and robust PDF tools in one seamless application.

1. Download WPS Office: Visit the official WPS website and click the free download button.
2. Install the Software: Run the downloaded installer and follow the quick on-screen instructions.
3. Start Creating: Open WPS Office to instantly access Docs, Sheets, Slides, and PDF tools.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Includes built-in document, spreadsheet, and presentation tools in a single lightweight app.Offers smart form capabilities and rich PDF editing tools to streamline your data collection.Familiar user interface with zero learning curve, making migration effortless.

Frequently Asked Questions

Can I prevent users from submitting the form if they do not get a passing score?

No, Microsoft Forms evaluates scores only after the form is submitted. It is not possible to block a submission dynamically based on a passing score natively within the form.

How do I let users see their scores immediately after submitting a quiz?

In Microsoft Forms, open your quiz, click the three-dot menu for Settings, and toggle on 'Show results automatically'. Respondents will then be able to see their results and correct answers immediately after submitting.

Is there a built-in way to issue certificates for passing a Microsoft Form quiz?

Not natively within Microsoft Forms. However, you can use Power Automate to generate a certificate using a Word template and automatically email it to respondents who achieve a passing score.

Office Quick Solutions