Microsoft Forms Quiz Scoring Made Easy with Power Automate

[@adrianquintanilla850]

Thanks! Super stupid that Forms does not have a return value for at the very LEAST the points. Come on Microsoft.

[@ann_usr]

I get the same error as one the comments. Filter Array Error " BadRequest The 'from' property value in the 'query' action inputs is of type 'String'. The value must be an array." I havent figure it out

[@DamoBird365]

@@ann_usr it means the dynamic value you have added to the “from” of the filter array is a “string” and not an [“array”]. You need to double check what your added.

[@nadiaRBNC]

Thank you so much for the great explanation . In my case my form have more than 150 questions and bunch of branching , so I want to get the score by just the questions answer and be able to email the user their score , is there away I can do that ?

[@DamoBird365]

Hi 👋 I don’t understand your ask. It’s a challenge but is possible. The alternative is a canvas app if it’s internal. This might give you inspiration kzbin.info/www/bejne/mZqcaK2Fodmbotksi=eqjaUNR_QFyxGlGV

[@martinemanuel1247]

Great video. I'll have to go back and watch your XPath solution.

[@DamoBird365]

Thank you, I’ve now added the link to the description kzbin.info/www/bejne/sGawqZWtireJbJo

[@sbrutcher]

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.

[@DamoBird365]

I did attempt a basic power apps quiz for that reason: How to Build a Quiz App in Power Apps Canvas App #PowerApp #CanvasApp kzbin.info/www/bejne/mZqcaK2Fodmbotk

[@sbrutcher]

@@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...

[@DamoBird365]

@@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’.

[@MatthewHaddix]

Thank you for the video. I cannot get the filter array to return my true values. What should be entered into the "From" and the "Filter Query" boxes?

[@DamoBird365]

You need to check if you’re comparing a string or a Boolean. There is an expression true for Boolean.

[@hugolagahe-r4d]

thanks for the video but woh you deal with the True or False Response ?

[@congobongo2009]

Would this still work if the questions were not mandatory. So let’s say I only wanted to answer two questions of the six.

[@DamoBird365]

In terms of validating answers? It would enable you to check any answer that has been responded too.

[@Ncredible07]

That's an amazing solution. Could you please tell us how we can obtain percentage if branching is involved in the quiz ?

[@tanguymachizaud5929]

Thanks for the video, i have a question. I have a several (11) multi choice questions. How can I adapt the step Compose MultiChoice Explained is it necessary ? Thanks you for your time

[@razcarine425]

What if the first question was set for the person's name?

[@ryanrankin1030]

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."

[@ryanrankin1030]

I figured it out :)

[@DamoBird365]

Thanks Ryan. 👍

[@TinaArmbruster-j5s]

@ryanrankin1039 I´m receiving the same error, can you tell me what you did to fix it?

[@binhlong]

Very clever solution. Thank you very much, @DamoBird365.