SOLVED

Quiz score available via Flow in Forms Pro?

%3CLINGO-SUB%20id%3D%22lingo-sub-390906%22%20slang%3D%22en-US%22%3EQuiz%20score%20available%20via%20Flow%20in%20Forms%20Pro%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390906%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDoes%20anyone%20know%20if%20Forms%20Pro%20makes%20it%20possible%20to%20get%20a%20Quiz's%20Points%20Scored%20value%20using%20Flow%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpecifically%2C%20I%20need%20to%20use%20a%20Flow%20to%20access%20the%20Points%20Scored%20values%20from%20the%20spreadsheet%20made%20available%20by%20MS%20Forms%20by%20clicking%20on%20the%20Open%20in%20Excel%20from%20the%20Responses%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20functionality%20I%20hoping%20is%20now%20available%20in%20Forms%20Pro%20from%20the%20MS%20Forms%20Suggestion%20Box%3A%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F31243432-quiz-score-available-to-ms-flow%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F31243432-quiz-score-available-to-ms-flow%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Erobertg%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-390906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPoints%20Scored%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuiz%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-395370%22%20slang%3D%22en-US%22%3ERe%3A%20Quiz%20score%20available%20via%20Flow%20in%20Forms%20Pro%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-395370%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20does%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20appear%20MS%20Forms%20Pro%20makes%20a%20quiz's%20points%20scored%20available%20to%20Flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20MS%20Forms%20Pro%20Quiz%3C%2FP%3E%3CP%3EI%20created%20a%20Flow%20triggered%20when%20a%20MS%20Forms%20new%20response%20is%20submitted%3CBR%20%2F%3EI%20added%20MS%20Forms%20Get%20response%20details%20to%20the%20Flow%3C%2FP%3E%3CP%3EI%20added%20a%20SharePoint%20Create%20item%20to%20the%20Flow%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20took%20the%20quiz%20and%20the%26nbsp%3BFlow%20triggered%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%20the%20OUTPUTS%20in%20Create%20item%20and%20did%20not%20see%20any%20reference%20to%20'points%20scored'%20in%20the%20JSON.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20I'm%20thinking%20getting%20MS%20Forms%20Quiz%20points%20via%20Flow%20is%20still%20not%20possible.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20not%20a%20valid%20test%20or%20I%20am%20missing%20something%2C%20could%20someone%20please%20let%20me%20know%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-872340%22%20slang%3D%22en-US%22%3ERe%3A%20Quiz%20score%20available%20via%20Flow%20in%20Forms%20Pro%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-872340%22%20slang%3D%22en-US%22%3E%3CP%3EConfirmed.%26nbsp%3B%20I%20tried%20the%20same.%26nbsp%3B%20Anyone%20know%20how%20to%20get%20this%20information%20out%20of%20Microsoft%20Forms%3F%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280166%22%20target%3D%22_blank%22%3E%40rgentile%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-872379%22%20slang%3D%22en-US%22%3ERe%3A%20Quiz%20score%20available%20via%20Flow%20in%20Forms%20Pro%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-872379%22%20slang%3D%22en-US%22%3ETo%20add%20more%20detail%3A%20I'm%20using%20Microsoft%20Form%20quizzes%20to%20test%20employee%20subject%20knowledge.%20I%20was%20hoping%20to%20pull%20the%20results%20of%20the%20quizzes%20into%20a%20SharePoint%20list%2C%20which%20I%20could%20make%20visible%20to%20the%20employees%2C%20so%20they%20could%20see%20an%20overview%20on%20what%20subjects%20they've%20mastered%20and%20which%20they%20still%20need%20to%20work%20on.%20Microsoft%20Forms%20offers%20a%20great%20interface%20for%20the%20quizzes%2C%20but%20each%20quiz%20is%20stand%20alone%2C%20and%20I%20need%20to%20compile%20the%20results%20for%20the%20employees%20to%20review.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20do%20this%20in%20SharePoint%20now%2C%20I'd%20have%20to%20check%20each%20question's%20answer%20via%20the%20Flow%20and%20then%20calculate%20the%20results%2C%20which%20is%20an%20awful%20lot%20of%20work.%20Does%20anyone%20know%20another%20way%20of%20accomplishing%20the%20same%20thing%3F%20Maybe%20with%20a%20different%20Microsoft%20tool%20than%20SharePoint%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1248974%22%20slang%3D%22en-US%22%3ERe%3A%20Quiz%20score%20available%20via%20Flow%20in%20Forms%20Pro%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1248974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280166%22%20target%3D%22_blank%22%3E%40rgentile%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20driving%20me%20crazy%20for%20days%2C%20but%20i've%20found%20a%20workaround%20to%20mark%20quizzes%20through%20flows.%20it's%20a%20bit%20tricky%2C%20but%20should%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*This%20is%20my%20first%20post%2C%20and%20i'm%20not%20a%20developer*%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Get%20response%20details%20(forms)%3C%2FP%3E%3CP%3E2.%20Initialise%20a%20variable%20for%20each%20question%20in%20your%20quiz%20-%20you'll%20then%20use%20a%20condition%20to%20set%20that%20variable%20to%20either%201%20or%200%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ryanVSS_0-1585038809021.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179104i48D2F2B109D3428C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ryanVSS_0-1585038809021.png%22%20alt%3D%22ryanVSS_0-1585038809021.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E3.%20use%20a%20condition%20to%20test%20the%20answer%20to%20the%20question%20and%20%22Set%20variable%22%20to%20add%20a%20point%20for%20a%20correct%20answer%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ryanVSS_1-1585038987453.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179105iD81CBB7545678DCC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ryanVSS_1-1585038987453.png%22%20alt%3D%22ryanVSS_1-1585038987453.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E4.%20when%20all%20the%20questions%20have%20been%20completed%20you'll%20need%20to%20use%20a%20%22compose%22%20function%20to%20add%20all%20the%20variables%20(answers)%20together.%20*it's%20important%20to%20note%20that%20the%20ADD%20function%20only%20works%20for%20two%20variables%2C%20so%20you'l%20need%20to%20use%20nested%20functions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ryanVSS_2-1585039163159.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179106iF1D86B1A69B41256%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ryanVSS_2-1585039163159.png%22%20alt%3D%22ryanVSS_2-1585039163159.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5.%20now%20you%20just%20need%20to%20set%20the%20pass%20mark%20condition%20and%20what%20happens%20for%20pass%2Ffails%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ryanVSS_3-1585039241793.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179108i2B399652F66A55F8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ryanVSS_3-1585039241793.png%22%20alt%3D%22ryanVSS_3-1585039241793.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20accept%20this%20solution%20if%20you%20feel%20that%20it's%20a%20suitable%20workaround%20for%20marking%20quizzes%20with%20flows.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%2C%3C%2FP%3E%3CP%3ERyan%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-891537%22%20slang%3D%22en-US%22%3ERe%3A%20Quiz%20score%20available%20via%20Flow%20in%20Forms%20Pro%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891537%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414329%22%20target%3D%22_blank%22%3E%40gbenoit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20had%20to%20do%20what%20you%20are%20trying%20to%20avoid%20doing%20and%20it%20was%20a%20lot%20of%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ERequirements%3A%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3EUsers%20would%20take%20a%20MS%20Forms%E2%80%99%20quiz.%20The%20grade%20earned%20would%20be%20stored%20in%20a%20SharePoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20first%20attempt%20we%20let%20MS%20Forms%20determine%20the%20grade%20earned%2C%20but%20we%20could%20not%20get%20at%20the%20points%20scored.%20So%2C%20our%20approach%20changed%20to%20determining%20the%20grade%20earned%20in%20Flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHere%20is%20(a%20simplified%20version)%20what%20we%20ended%20up%20doing%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3EEach%20question%20on%20the%20form%20is%20worth%201%20point%3C%2FLI%3E%3CLI%3ECreated%20Flow%20triggered%20on%20form%20submission%3C%2FLI%3E%3CLI%3EIn%20the%20flow%20we%20had%20variables%20for%20number%20of%20questions%20and%20a%20points%20counter%3C%2FLI%3E%3CLI%3EWe%20had%20checks%20for%20three%20types%20of%20questions%3A%20radio%20buttons%2C%20checkboxes%2C%20and%20ranking%3C%2FLI%3E%3CLI%3EWe%20looped%20through%20the%20form%20Response%20Details%20and%20checked%20if%20the%20answer%20was%20correct%3C%2FLI%3E%3CLI%3EIf%20the%20answer%20was%20correct%20we%20added%201%20to%20points%20counter%20variable%2C%20if%20answer%20was%20wrong%20we%20did%20nothing%3C%2FLI%3E%3CLI%3EWhen%20all%20the%20answers%20were%20checked%2C%20we%20calculated%20the%20grade%20(points%20counter%20divided%20by%20number%20of%20questions)%3C%2FLI%3E%3CLI%3EWe%20wrote%20the%20grade%20and%20exam%20info%20(exam%20name%2C%20course%2C%20user%20info%2C%20date%2C%20etc.)%20to%20a%20SharePoint%20List%3C%2FLI%3E%3C%2FOL%3E%3CP%3EThis%20does%20create%20the%20dependency%20that%20if%20a%20question%20or%20answer%20in%20the%20form%20changes%2C%20the%20Flow%20must%20be%20updated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%20we%20had%20to%20create%2037%20Flows%2C%20so%20we%20created%20a%20template%20Flow%20then%20copied%20each%20item%20in%20the%20Flow%20to%20the%20clipboard%20(new%20Flow%20feature%2C%20click%20on%203%20dots%20on%20right%20of%20item%20and%20choose%20Copy%20to%20my%20clipboard).%26nbsp%3BWe%20created%20the%20new%20Flow%20and%20pasted%20in%20each%20item%20from%20the%20clipboard%20then%2C%20where%20necessary%2C%20updated%20the%20item.%26nbsp%3B%20Using%20the%20Copy%20to%20my%20clipboard%20feature%20saved%20us%20a%20lot%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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

10 Replies
Highlighted
Best Response confirmed by rgentile (Occasional Contributor)
Solution

It does not appear MS Forms Pro makes a quiz's points scored available to Flow.

 

I created a MS Forms Pro Quiz

I created a Flow triggered when a MS Forms new response is submitted
I added MS Forms Get response details to the Flow

I added a SharePoint Create item to the Flow

 

I then took the quiz and the Flow triggered

 

I checked the OUTPUTS in Create item and did not see any reference to 'points scored' in the JSON.

 

So, I'm thinking getting MS Forms Quiz points via Flow is still not possible. 

 

If this is not a valid test or I am missing something, could someone please let me know?


Thanks

Highlighted

Confirmed.  I tried the same.  Anyone know how to get this information out of Microsoft Forms?@rgentile 

Highlighted
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?
Highlighted

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:

  1. Each question on the form is worth 1 point
  2. Created Flow triggered on form submission
  3. In the flow we had variables for number of questions and a points counter
  4. We had checks for three types of questions: radio buttons, checkboxes, and ranking
  5. We looped through the form Response Details and checked if the answer was correct
  6. If the answer was correct we added 1 to points counter variable, if answer was wrong we did nothing
  7. When all the answers were checked, we calculated the grade (points counter divided by number of questions)
  8. 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.

Highlighted

@rgentile 

 

This was driving me crazy for days, but i've found a workaround to mark quizzes through flows. it's a bit tricky, but should work. 

 

*This is my first post, and i'm not a developer* 

 

1. Get response details (forms)

2. Initialise a variable for each question in your quiz - you'll then use a condition to set that variable to either 1 or 0 

ryanVSS_0-1585038809021.png

3. use a condition to test the answer to the question and "Set variable" to add a point for a correct answer

ryanVSS_1-1585038987453.png

4. when all the questions have been completed you'll need to use a "compose" function to add all the variables (answers) together. *it's important to note that the ADD function only works for two variables, so you'l need to use nested functions

 

ryanVSS_2-1585039163159.png

 

5. now you just need to set the pass mark condition and what happens for pass/fails 

 

ryanVSS_3-1585039241793.png

 

 

Please accept this solution if you feel that it's a suitable workaround for marking quizzes with flows. 

 

cheers,

Ryan 

 

 

 

 

 

 

Highlighted

@ryanVSS I tried your workaround solution, but in the condition step to test the answer, the "set variable" attempts to update the initialized variable as a text string instead of a variable. Did you run into this? Am I missing something?

Highlighted
This worked like a charm in my case! Thanks a ton
Highlighted
Hi Andy,

sorry for the late reply, hope you got on ok?

if not, can you post your flow and i'll take a look at it to see if I can help.

cheers,
ryan
Highlighted
i think you need your initialise variable set to "interger" rather than "string"?
Highlighted

@ryanVSS can you provide some guidance on the nesting process for adding the points?