Automate Certificate Generation for Event Attendees in Word & Power Automate

Become a Power Automate wizard and gather the skills needed to automate your business by taking the Collab365 Power Automate Success Path!

Attending conferences, workshops, or classes? As the organizer, you want to provide attendees with a nice certificate of completion. But creating unique certificates for each person can be tedious and time-consuming.

In this post, I’ll show you how to easily automate certificate generation using Word and Power Automate. No more manual work needed!

Step 1: Create a Template in Word

First, design a certificate template in Word. You can start from a pre-made template or create your own custom one.

Be sure to enable Developer options and add Content Controls to areas you want to populate with names, classes, etc. Give each content control a unique tag name.

Save the Word doc as a template in a accessible location like SharePoint.

Step 2: Build Your List in SharePoint

Next, create a SharePoint list to store attendee names and classes. The columns should match the tags you set up in the Word template.

For example:

  • Name
  • Class

Step 3: Automate with Power Automate

Now for the fun part – automation! Build a Power Automate flow that:

  • Triggers when a new item is added to your list
  • Populates the Word template using the list data
  • Converts the Word doc to PDF
  • Saves the PDF to a SharePoint document library

See the video above for a walkthrough for more details on how to set this up.

Step 4: Test It Out!

Once built, test your flow by adding items to the list. You should see personalized certificates automatically generate for each attendee!

Automating certificate creation is easy with the power of Word and Power Automate. Now you can instantly generate customized completion certificates for all your event or class attendees.

Join 11,000+ in the Collab365 Academy

Master Microsoft 365, Power Apps, Power Automate, Power BI, SharePoint with Exclusive Access to 450+ Hours of Expert Training and a Wealth of Resources!