Forum Discussion
Quiz score available via Flow in Forms Pro?
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 FlowI 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
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
3. use a condition to test the answer to the question and "Set variable" to add a point for a correct answer
****i've since been back over my flow and tightened it up with by using a single "increment variable" instead of setting up a variable for each question. if anyone would like a further explanation then i can revisit this post****
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
5. now you just need to set the pass mark condition and what happens for pass/fails
Please accept this solution if you feel that it's a suitable workaround for marking quizzes with flows.
cheers,
Ryan
ryanVSS can you provide some guidance on the nesting process for adding the points?
- Add(variables('Answer1'),add(variables('Answer2'),add(variables('Answer3'),add(variables('Answer4'),add(variables('Answer5'))))))
each " Add() " is a function that you need to nest. essentially, you keen adding " Add( " for each variable until you've accounted them all. Then you need to close your nest with " ) " for however many functions you've added. The example above has 5 extra " ) " as there are 5 variables being counted.- I am sorry, I did not understand the explanation you just shared, but I tried entering this in compose formula.
Add(variables('Answer1'),add(variables('Answer2'),add(variables('Answer3'),add(variables('Answer4'),add(variables('Answer5'))))))
and I got the same error again...- also, get rid of the apply to each. you shouldn't need it as you're only marking one form at a time
