SOLVED

Quiz score available via Flow in Forms Pro?

Brass Contributor

Hello,


Does anyone know if Forms Pro makes it possible to get a Quiz's Points Scored value using Flow?

 

Specifically, I need to use a Flow to access the Points Scored values from the spreadsheet made available by MS Forms by clicking on the Open in Excel from the Responses tab.

 

Here is the functionality I hoping is now available in Forms Pro from the MS Forms Suggestion Box:  https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggest...

 

Thanks

 

robertg

33 Replies
I used a nested function but the flow gives error in the compose.
Unable to process template language expressions in action 'Compose' inputs at line '1' and column '20627': 'The template language function 'add' expects two numeric parameters: the first summand as the first parameter and the seccond summand as the second parameter. The function was invoked with '1' parameter(s).
I used a nested function but the flow gives error in the compose .
Unable to process template language expressions in action 'Compose' inputs at line '1' and column '20627': 'The template language function 'add' expects two numeric parameters: the first summand as the first parameter and the seccond summand as the second parameter. The function was invoked with '1' parameter(s).
Hi ryanVSS, could you explain more about the nested function? The flow you recommended worked well up until my last variable and condition. I am unable to get the nested function right. Is there an example you can post here? 🙂 Thanks in advance.

@ryanVSS This is the error message I am getting. 

 Screenshot (559).png

Hi - can you paste the function you are using @Sandy08 

Thank you for your prompt reply. 🙂

 

@ryanVSS 

 

 

I removed the "add" before variables ("Answer10") and my flow worked. However, the quiz score calculated does not match the one on Microsoft Forms.
if the quiz score isn't matching then it could be a number of things - go through each of your conditions and pinpoint which section isn't marking correctly. if everything is marking correctly, then make sure you are assigning the same point value for a correct answer in both forms and flow.

Hi @rgentile 

 

Your post helped me a lot when I faced the same problem : Power Automate can't retrieve the score of a Ms Forms.

 

So I made a solution which works perfectly for my case.

 

- Made a Quiz in Ms Forms with questions that scored for 1 each, and with only one possible answer (because I don't know how to calculate the Score with a formula in Excel if multiple answers, see below)

- Populated an Excel File with the answers

- Added a column Score in the Excel with the following formula to check against the solution:

=SUM(IF(TabReponses[@[Question1]:[Question10]]=Solution!$A$2:$J$2;1;0))

This will sum all the '1', so when an answer cell is equal to the solution cell

- Get the line in the same Excel corresponding to the responder

- Get the score => one great thing is that the Excel formulas are recalculated automatically, I did not put a script or do anything, and I checked that my Excel file was closed

- Send an Email to the responder with its score

 

I hope this can helps others with dealing this missing functionnality of Forms + Power Automate !

 

 

quiz_powerautomate.jpgcalcul_score.jpgcalcul_score_2.jpgquiz_powerautomate_2.jpg

 

why not we get the score directly? I dont want to validate the entire form again since it is already done there @ryanVSS ?

@Nalini_Vijaykumar  your response is quite vague and unhelpful to most, or all, non-developers. 

 

At the time of putting forward a work-around solution (circa 4 years ago) to a problem with forms limitations, there was no known way to pull a score directly from an MS form. If you have a better solution then please do share this within the thread.