Others

Use Power Automate to Send Pass or Fail Messages for Forms Quizzes

Huma Ashraf Ch Oct 1, 2026 869 views

Question details

The user wants to automate pass or fail email notifications to respondents based on their Microsoft Forms quiz scores using Power Automate.

How to Use Power Automate to Send Pass or Fail Messages for Forms Quizzes

Product: Microsoft Forms & Power Automate
Device & OS: not provided
Scenario: Evaluating quiz scores against a passing threshold to send conditional follow-up instructions, such as asking a user to retake the quiz if they score below 60%.
Observed behavior: Setting up an automated workflow to process incoming quiz results and branch into different email responses based on the total score.

Before you start

Ensure you have active Microsoft 365 credentials with access to both Microsoft Forms and Power Automate, and that your quiz is already created and configured to collect responder email addresses.

Solution 1Recommended

Set Up a Condition-Based Flow in Power Automate

Create an automated cloud flow that triggers upon form submission, checks the user's score, and branches into specific pass or fail email actions.

By utilizing the 'Condition' control in Power Automate, you can evaluate the dynamic score data from Microsoft Forms. This allows you to set custom thresholds and tailor the communication based on the respondent's performance.

Create the trigger

Open Power Automate, create a new 'Automated cloud flow', and select 'When a new response is submitted' as your trigger. Choose your specific Microsoft Forms quiz from the dropdown menu.

Get response details

Add a new action and search for 'Get response details' under Microsoft Forms. Select your Form ID again, and click the Response Id field to select 'Response Id' from the dynamic content menu.

Add a condition control

Add a new action and select the 'Condition' control. In the first value field, select 'Total point' (or your score variable) from the dynamic content. Set the operator to 'is greater than or equal to', and type your passing threshold (e.g., 60) in the second value field.

Configure the pass message

In the 'If yes' branch, add the 'Send an email (V2)' action. In the 'To' field, insert the 'Responders Email' dynamic content. Draft a subject and body congratulating the user on passing the quiz.

Configure the fail message

In the 'If no' branch, add another 'Send an email (V2)' action. Address it to the 'Responders Email' and draft a message containing instructions to review the material and retake the quiz. Save and test your flow.

Set Up a Condition-Based Flow in Power Automate

Community Support: If you encounter complex workflow errors or need advanced configuration help, Microsoft recommends asking for assistance in the official Microsoft Power Automate Community.

Free Microsoft Office alternative

Discover WPS Office as a Lightweight, Free Alternative

While complex automations might require specialized ecosystem tools, everyday document, spreadsheet, and presentation tasks don't have to be expensive or complicated. WPS Office provides a complete, free, and highly compatible alternative to Microsoft Office, perfect for managing your data, forms, and daily workflows.

1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your device.
3. Open your files: Launch WPS Office to seamlessly open, edit, and save your existing Microsoft Office documents and spreadsheets.

Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx).Lightweight installation that runs smoothly on Windows, Mac, Linux, iOS, and Android.Built-in PDF editing tools for easy document conversion, annotating, and signing.Free to use with a familiar, easy-to-navigate user interface that requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I include the exact quiz score in the automated email?

Yes, you can use dynamic content in Power Automate to insert the user's exact score and total available points directly into the body of the 'Send an email' action.

Why is my Power Automate flow not triggering when a quiz is submitted?

Ensure the Form ID in your trigger exactly matches the quiz you are submitting. Also, check that your flow is turned on and that the connection credentials for Microsoft Forms in Power Automate are active and valid.

Do respondents need a Microsoft account to receive the pass or fail email?

No, as long as your Microsoft Form is set up to collect email addresses (or if you ask for their email in a required form question), Power Automate can send the automated email to any valid email address provided by the respondent.

Office Quick Solutions