Forum Discussion
microsoft forms
VeroniqueD it is not possible to get the total score of the quiz in Power Automate, and the total score column is not even populated in the spreadsheet of the responses so Microsoft have obviously had problems with this. I haven't tried it with a quiz but you would need to save all the responses into a list in SharePoint and then in another flow (triggered by When a new item is created) loop through the questions and with a condition or a switch if it was the correct answer then increment a variable by 1. You could then use the outcome of the variable - the total score - in your email.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- VeroniqueDFeb 18, 2021Copper Contributor
Thank you for your answer. But how can I put the answers of the Forms in Sharepoint? And after how can I have this result in power automate?