Others

How to Create Pass or Fail Certificates with Microsoft Forms and Power Automate

Adam Davis Oct 7, 2026 869 views

Question details

The user needs to automatically generate and send a customizable pass or fail certificate to participants after they complete a Microsoft Forms quiz.

How to Create Pass or Fail Certificates Using Microsoft Forms and Power Automate

Product: Microsoft Forms and Power Automate
Device & OS: not provided
Scenario: Automating the delivery of customized certificates (including name, date, and score) based on a quiz's pass/fail threshold.
Observed behavior: Microsoft Forms can natively grade responses, but it lacks the built-in capability to conditionally generate and email customized certificates upon passing.

Before you start

Ensure you have an active Microsoft 365 subscription with access to Microsoft Forms, Power Automate, and OneDrive or SharePoint to store your certificate templates.

Solution 1Recommended

Build an Automated Certificate Workflow Using Power Automate

Connect Microsoft Forms to Word and Outlook using a Power Automate flow to instantly generate and send personalized PDF certificates when a quiz is passed.

Microsoft Forms natively handles quiz grading but requires Power Automate to handle conditional logic (pass/fail) and document generation. You will need a Word template prepared with content controls for dynamic data like name, date, and score.

Create the Microsoft Form

Set up your quiz in Microsoft Forms, ensuring you assign points to questions and include a required text field to capture the respondent's name.

Prepare the Certificate Template

Open a Word document to design your certificate. Enable the Developer tab and insert 'Plain Text Content Controls' for fields like Name, Date, and Score. Save this .docx file to SharePoint or OneDrive.

Trigger the Power Automate Flow

In Power Automate, create a new automated cloud flow. Select the 'When a new response is submitted' trigger and link it to your newly created Microsoft Form.

Add Conditional Logic for Pass/Fail

Add a 'Get response details' action. Next, insert a 'Condition' control to check if the quiz score is greater than or equal to your required passing threshold.

Populate and Convert the Certificate

In the 'If yes' branch, add the 'Populate a Microsoft Word template' action and map the form responses to your template's content controls. Follow this with a 'Convert Word Document to PDF' action.

Email the Final Certificate

Add the 'Send an email (V2)' action to deliver the generated PDF certificate directly to the respondent's email address with a congratulatory message.

Build an Automated Certificate Workflow Using Power Automate

Handling Quiz Retakes: If a user fails and your form settings restrict multiple responses, you will need to manually delete their previous response in Microsoft Forms to allow them to submit a retake.

Free Microsoft Office alternative

Design Stunning Certificate Templates with WPS Office

While Power Automate handles your background workflow, you need a reliable word processor to design attractive certificate templates. WPS Office is a free, lightweight suite that lets you create professional certificates with flawless compatibility for Microsoft Word formats (.docx).

Fully compatible with Microsoft Word (.docx) for seamless template creationLightweight and fast, perfect for quick document formatting and editsBuilt-in free PDF tools to easily view or convert generated certificatesRich library of built-in customizable templates for certificates and awards

microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Forms automatically send an email to respondents without Power Automate?

Yes, you can enable 'Send email receipt to respondents' in the Forms settings. However, this only sends a basic receipt. To send customized emails with attachments like pass/fail certificates, you must use a Power Automate flow.

How do I add dynamic fields like Name and Score to my Word certificate?

Enable the Developer tab in Microsoft Word (or WPS Office), place your cursor where you want the dynamic data to appear, and insert a 'Plain Text Content Control'. Power Automate will use these controls to map the submitted form data accurately.

Do I need a premium Power Automate license to populate Word templates?

Yes, the 'Populate a Microsoft Word template' action in Power Automate is a premium feature. If your account lacks premium access, you may need to request a license upgrade from your organization or explore alternative third-party PDF connectors.

Office Quick Solutions