Forum Discussion
Solved
Quiz score available via Flow in Forms Pro?
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/suggestions/31243432-quiz-score-available-to-ms-flow
Thanks
robertg
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
33 Replies
You can vote for this at Add result score to Forms Power Automate connector · Community (microsoft.com)
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
- 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.
- 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). Hey Buddy,
I have been trying to do this for 2 days now and I am getting an error message.
The inputs of workflow run action 'Compose' of type 'Compose' are not valid. The variable 'Answer1' must be initialized before it can be used inside the action 'Compose'.
Here is what I am trying to do...
If I don't add the variables with the formula in compose which I have mentioned below then it will work but then of this is how I do it and it does not sum the values. So eventually does not help me
Add(variables('Answer1'),add(variables('Answer2'),add(variables('Answer3'),add(variables('Answer4'),add(variables('Answer5'))))))
- hi, try a linear flow rather than parallel - it looks like your compose is trying to complete outside of the condition on the far right.
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- 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?
