How to Retrieve Microsoft Forms Quiz Scores in Power Automate
Question details
Users are unable to extract the total or partial quiz scores from Microsoft Forms when using Power Automate to save responses to a SharePoint list.
- Product
- Power Automate
- Device & OS
- not provided
- Scenario
- Building an automated flow to transfer scored quiz results from Microsoft Forms to a SharePoint list.
- Observed behavior
- The Microsoft Forms connector in Power Automate does not provide a dynamic field for calculated quiz scores, resulting in empty score fields in the destination list.
Verify that your Microsoft Form is explicitly set up as a 'Quiz' with point values assigned to the questions, and ensure you have edit access to the target Power Automate flow.
Calculate the Quiz Score Manually Using Power Automate Conditions
Since the native connector does not pass the score, you can recreate the scoring logic within your flow by evaluating the submitted answers.
The Microsoft Forms connector currently limits dynamic content to standard text responses, meaning the built-in grading system points are not exposed directly to Power Automate. To bypass this, you must calculate the total score using variables and conditional statements based on the answers provided.
Open your flow in Power Automate and add an 'Initialize variable' action at the top. Set the Name to 'TotalScore', Type to 'Integer', and Initial Value to 0.
Below the forms trigger, insert a 'Condition' action. Configure it to check if the specific dynamic response from your form matches the exact correct answer.
Inside the 'If yes' branch of the condition, add an 'Increment variable' action. Select your 'TotalScore' variable and enter the point value for that specific question.
Repeat this conditional logic for all scored questions. Finally, map the 'TotalScore' variable into your SharePoint 'Create item' action's score column.
Export Quiz Results Directly to Excel
If you do not strictly require a live SharePoint list integration, you can view the calculated scores directly by exporting the Microsoft Forms results to an Excel workbook.
Manage Your Exported Form Data with WPS Office
While Power Automate and Microsoft Forms have specific connector limitations, analyzing your exported quiz results is much easier with a powerful spreadsheet tool. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office, perfect for managing your Excel data, generating reports, and tracking scores without expensive subscriptions.
- 1. Download WPS Office: Download and install WPS Office Free on your computer from the official website.
- 2. Export Data: Export your Microsoft Forms quiz responses to an Excel (.xlsx) file using the built-in export button.
- 3. Analyze Results: Open the downloaded file in WPS Spreadsheet to seamlessly analyze and format your quiz scores.
Frequently Asked Questions
Why doesn't Power Automate show the Microsoft Forms score field?
The Microsoft Forms connector for Power Automate currently lacks a standard dynamic content field to expose calculated quiz scores or partial points. This is a known limitation of the integration, as it only passes raw submission data.
Can I use an HTTP request to get the quiz score in Power Automate?
Yes, advanced users can use the 'Send an HTTP request to SharePoint' action or premium HTTP connectors to query the Forms API directly to fetch the score. However, this requires advanced knowledge of API endpoints and premium licensing.
Will Microsoft update the connector to include the score field?
Microsoft frequently updates Power Automate connectors based on user feedback. It is highly recommended to submit a feature request on the official Power Automate or SharePoint feedback platforms to prioritize this update.
