Microsoft Forms Quiz Scoring Made Easy with Power Automate
Vložit
- čas přidán 31. 07. 2024
- 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 Ap...
Writing Expressions • How to write expressio...
SUM with Xpath • Power Automate - Fast ...
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 forms.office.com/r/4EqE7VHVfH 👍
Want to buy me a coffee www.buymeacoffee.com/DamoBird365 ☕
#PowerAutomate #MicrosoftForms #PowerPlatform #Tutorial #Quiz - Věda a technologie
Thanks! Super stupid that Forms does not have a return value for at the very LEAST the points. Come on Microsoft.
Thanks for this video! Your requirement is exactly the one I'm working to now, and I should be able to implement this solution with very few changes.
This is about as complicated as I'd care to get, though. For greater flexibility & functionality, I'd definitely go with Power Apps.
I did attempt a basic power apps quiz for that reason: How to Build a Quiz App in Power Apps Canvas App #PowerApp #CanvasApp
czcams.com/video/ci97zOlthlw/video.html
@@DamoBird365 Yep, I'm going to watch your Power Apps quiz video shortly. In the meantime, I applied your solution to my requirement and it's working perfectly! Your video also taught me a lot about composing and expressions, which I've been afraid of.
I did come across one odd thing while testing. If the user fails to answer a question with multiple answers (checkboxes), the sort() function will fail. At first I thought it was just any null input that failed, as I originally said in this comment. Looking more closely, it appears that only the comparisons using sort() had a problem with null values. I know this condition isn't likely to happen in the real world. However, my users are experts at finding creative ways to break my apps and so I had to check.
I guess the solution would be to mark checkbox questions Required. Or test the responses for null inputs and handle them in the flow. Anyway, highly unlikely but useful to know - just in case.
Thanks again for this great video. On to Power Apps...
@@sbrutcher fantastic to hear about your success. Take a look at the coalesce expression. It could be used to return a fallback answer, like ‘no response’.
Great video. I'll have to go back and watch your XPath solution.
Thank you, I’ve now added the link to the description czcams.com/video/z5MxbwURV68/video.html
Awesome Video! I'm receiving an error after running my flow. Filter Array Error "
BadRequest
The 'from' property value in the 'query' action inputs is of type 'String'. The value must be an array."
I figured it out :)
Thanks Ryan. 👍
Very clever solution. Thank you very much, @DamoBird365.