Microsoft Forms Quiz Scoring Made Easy with Power Automate

Welcome to today's tutorial on how to calculate the percentage or score of a Microsoft Form Quiz or Form submission in Power Automate. This is a great use case for educational institutes or maybe employers looking to attest the knowledge understanding of their employees. This can be validated automatically and followed up using Power Automate Cloud Flows!

We'll start by looking at the Microsoft Form Quiz, submit some answers and trigger the flow to see the percentage of correct answers being calculated. We will then look to understand the expressions used to create this, talk about objects and arrays, the JSON and Intersection expression and also learn how to handle both single answer and multi choice answer questions.

During the course of the video, I will demonstrate the build but also extend the flow to include scoring, so that questions can have their own unique points.

We will also see the new draft and publish feature that has been dropped into General Availability recently, making an appearance in my developer tenant.

Finally we will test the scoring and extend the solution once more with conditional logic to either congratulate or commiserate the student or employee on the success of their quiz submission.

00:00 Intro
00:50 A look at the Microsoft Form Quiz
02:38 Exploring the history of the pre-built flow
05:31 Taking a look at the flow Edit
09:00 How to handle Multi Choice Answers
13:22 How to calculate quiz points
16:26 New feature, draft and publish solution flows
16:58 Testing the score calculation
18:40 Sending a congrats or commiseration email
22:07 Testing multichoice answers

Build a Quiz Power App    • How to Build a Quiz App in Power Apps...  
Writing Expressions    • Power Automate JSON Arrays: Fun, Prac...  
SUM with Xpath    • Power Automate - Fast Data Aggregatio...  

I also want to shout out to one of my subscribers 👍 Adi Christea for providing me with feedback on the initial logic of the multi-choice answers, which I have since addressed by re-uploading an amended video. I really do appreciate the feedback.

Got an idea? Or video request? Drop me a note here https://forms.office.com/r/4EqE7VHVfH 👍

Want to buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕

#PowerAutomate #MicrosoftForms #PowerPlatform #Tutorial #Quiz