Quiz score available via Flow in Forms Pro?

[rgentile]

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

[#2]

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

[#3]

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

[#4]

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.

[#5]

@ryanVSS This is the error message I am getting. 

 

[#6]

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

[#7]

Thank you for your prompt reply. 🙂

@ryanVSS 

[#8]

@ryanVSS 

[#9]

@ryanVSS  

[#10]

I removed the "add" before variables ("Answer10") and my flow worked. However, the quiz score calculated does not match the one on Microsoft Forms.

[#11]

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.

[#12]

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 !

[#13]

You can vote for this at Add result score to Forms Power Automate connector · Community (microsoft.com)

[#14]

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

[#15]

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