Quiz score available via Flow in Forms Pro?

gbenoit
Copper Contributor
Sep 24, 2019
To add more detail: I'm using Microsoft Form quizzes to test employee subject knowledge. I was hoping to pull the results of the quizzes into a SharePoint list, which I could make visible to the employees, so they could see an overview on what subjects they've mastered and which they still need to work on. Microsoft Forms offers a great interface for the quizzes, but each quiz is stand alone, and I need to compile the results for the employees to review.

To do this in SharePoint now, I'd have to check each question's answer via the Flow and then calculate the results, which is an awful lot of work. Does anyone know another way of accomplishing the same thing? Maybe with a different Microsoft tool than SharePoint?
- rgentile
  Brass Contributor
  Oct 03, 2019
  Hello gbenoit
  
  We had to do what you are trying to avoid doing and it was a lot of work.
  
  Requirements: Users would take a MS Forms’ quiz. The grade earned would be stored in a SharePoint list.
  
  Our first attempt we let MS Forms determine the grade earned, but we could not get at the points scored. So, our approach changed to determining the grade earned in Flow.
  
  Here is (a simplified version) what we ended up doing:
  
  Each question on the form is worth 1 point
  Created Flow triggered on form submission
  In the flow we had variables for number of questions and a points counter
  We had checks for three types of questions: radio buttons, checkboxes, and ranking
  We looped through the form Response Details and checked if the answer was correct
  If the answer was correct we added 1 to points counter variable, if answer was wrong we did nothing
  When all the answers were checked, we calculated the grade (points counter divided by number of questions)
  We wrote the grade and exam info (exam name, course, user info, date, etc.) to a SharePoint List
  This does create the dependency that if a question or answer in the form changes, the Flow must be updated.
  
  Note: we had to create 37 Flows, so we created a template Flow then copied each item in the Flow to the clipboard (new Flow feature, click on 3 dots on right of item and choose Copy to my clipboard). We created the new Flow and pasted in each item from the clipboard then, where necessary, updated the item. Using the Copy to my clipboard feature saved us a lot of time.
  
  Good luck.
  - Lionel_Gueri
    Copper Contributor
    Dec 17, 2022
    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 !

Forum Discussion

Quiz score available via Flow in Forms Pro?

Share

Resources