Automate Microsoft Forms Quiz Scoring in Power Automate with Dynamic Points Tutorial

Instantly grade Microsoft Forms quizzes and send personalized feedback—automatically! In this Power Automate tutorial, you’ll learn how to calculate quiz scores (including multi-choice questions and custom points) and email results in real time, all with low-code cloud flows. Perfect for educators, trainers, and anyone needing seamless digital assessment automation with Power Platform.

We’ll walk through building a workflow that scores Microsoft Form submissions, handles tricky multi-select answers, and even sends custom “congratulations” or “try again” emails based on results. No more manual grading or complicated logic—just streamlined, reliable automation for your BPA or citizen development projects.

What You’ll Learn:
✔️ Build an automated workflow to grade Microsoft Forms quizzes in Power Automate
✔️ Handle both single-answer and multi-choice questions (including JSON parsing and array logic)
✔️ Assign custom point values to questions and calculate total/percentage scores
✔️ Send dynamic feedback emails based on quiz performance—all without writing code

Timestamps:
00:00 – Instantly Calculate Microsoft Forms Quiz Scores in Power Automate
00:50 – Reviewing the Microsoft Form Quiz Setup
02:38 – Understanding Flow History and Output Details
05:31 – Deep Dive: Flow Logic and JSON Structures
09:00 – Managing Multi-Choice Answers with Arrays and Intersection
13:22 – Adding Custom Points and Calculating Scores
16:26 – Exploring the New Draft and Publish Feature in Power Automate Solutions
16:58 – Live Testing: Automated Score Calculation
18:40 – Sending Personalized Congrats or Commiseration Emails
22:07 – Testing Multi-Choice Scenarios and Troubleshooting

#PowerAutomate #PowerPlatform #workflowautomation #LowCode #MicrosoftForms

Ready to automate your quiz grading? Try this step-by-step guide and share your results or questions in the comments! Don’t forget to check out the related videos for building quiz Power Apps and mastering expressions.

Additional Links:
🔗    • Build a Dynamic Power Apps Quiz App with A...   Build a Power App quiz
🔗    • Power Automate JSON Array Challenges: 5 Ad...   Tutorial on writing Power Automate expressions
🔗    • Power Automate Group By, Sum & Count Witho...   Using SUM with XPath in Power Automate

🫠 About me:
👋 Hi, I'm Damien Bird — Power Platform Cloud Solution Architect at Microsoft ☁️
🧠 Former Forum Super User (2021/22) & Business Applications MVP (2022)
🎤 Speaker at conferences across Europe, the US, and local UK user groups
💡 Passionate about sharing knowledge, solving problems, and empowering the community with the Power Platform!

📚 Explore more:
🔗 Blog: https://DamoBird365.com
🎥 Video & Quiz CPD: https://DamoBird365.com/YouTube

💖 Support the Channel:    / @damobird365  
☕ Buy Me a Coffee: https://BuyMeACoffee.com/DamoBird365
💼 LinkedIn:   / damobird365  
🐦 Twitter: https://x.com/DamoBird365
🌐 Bluesky: https://bsky.app/profile/DamoBird365....
📜 Feedback or Request: https://forms.office.com/e/WAV1iF2Wis