Generate and send a personalised certificate to users who pass your quiz with Power Automate!

Award your students/clients a personalised certificate when they complete your quiz in Microsoft Forms using this Power Automate Flow.

00:00 Introduction
01:25 Setting up the quiz (MS Forms)
07:30 Setting up the certificate (Word)
12:29 Setting up Excel
17:40 Setting up the Flow (Power Automate)
40:03 Testing it out

As well as a Power Automate Premium Licence (free trials available as of August 2021), you require a few things to get it to work. Here are some templates you can use:

[TheKermit]

Watched many content creators in power platform and i think you have a real talent. I'm a power platform consultant myself and recognize the high quality delivery you have in terms of pacing, understanding and delivery. You really should consider making more content for the power platform community as i believe you have a real skill in this area.

[melissaolive]

For the past 6 months I have been trying to create a flow in our biz sharepoint. I have watched at least 50 different tutorials. Your training was the ONLY one that THANK YOU and GREAT job!!!!

[RaeJobst]

Thank you for sharing not just the video but the templates as well! Amazing!

[robertl.edwards]

Awesome, thank you! I'm contracted for a company to create training test. You helped me to save this company a lot of money by using something this company already has versus purchasing an expensive e-training program. This is a time-consuming process but worth it for the safe of staying under budget.

[margaretadamiec]

Very grateful to have stumbled onto this video. Thank you for your work.

[renzonavarro]

Amazing, now I have to convince my boss to buy the premium features hahahaha thanks a lot man, a very especific explanation. You're the boss! Grateful from Peru

[WychfinderYT]

Matt, thank you very much for a very well presented and instructional video.

[cianancou]

It's pretty crazy there isn't a built in dynamic function to pull the total marks from the quiz when the output file has the total in it.
Really like this work around. Thank you so much.

[pritishdas]

Your a genius'👍👍👍👍.. Great video & Rare one in youtube.. M searching same kind of video since long time but finally you made my day .. Thanku soo much

[greencarlson]

Thank you! This is super helpful for automating certificate completion for all kinds of applications.

[katebrig]

You are amazing! Saved the day for me!

[chrisknowler]

Great tutorial Matt, you should do more, very clear and informative. 👍

[shazanasabri]

Awesome, thank you so much! really helpful :))

[jovaniofaccountthings]

very simple and easy to follow. this very much worked for me. thanks.

[pngtrips]

Your video is excellent perfectly explains what I need

[luisba]

Excellent! U r a great teacher! Excelente Matt muchas gracias!

[helbee]

Thank you very much for this. It was really clear and easy to follow along with.
This next bit might help other users who are using the New designer mode. Turn it off and revert to the old mode. The function of sending an email with a PDF attachment using the method explained in this tutorial doesn't work with the New designer mode. It sends a file which can't be opened properly. I expect this is an issue that Microsoft will deal with, but as on Jan 24, you need to use exactly the same steps as described above, but with New designer toggled off.

[mattwookie]

Thank you so much! It really helps me😭

[christineking]

This is really brilliant, so detailed and step-by-step so even I can follow it and I'm new to PowerAutomate. Just wondering which step in the process requires the Premium license?

[TheMaccistanmassive]

Hi Matt, such a good video.
Is there a way to complete a flow that you've created? But also include an anonymous (no name or email address) course/class survey. So you would complete a class then a quiz on the class then complete an anonymous survey about the class, finally, be issued your certificate via email.