Best way to automatically get the score from a Microsoft Form response?

Question

Best way to automatically get the score from a Microsoft Form response?

Ben S 5

I am building an automation that relies on automatically accessing the numerical 'score' someone achieves upon submitting the MS (quiz-style) Form. I'm building in Power Automate, but the MS Form Action 'When a new response is submitted' doesn't include the user's score/result, only answers to the questions.

Synced Excel Spreadsheet
I have tried retrieving the score from the Excel spreadsheet, which syncs all MS Form responses; however, that spreadsheet doesn't automatically sync without a physical user opening the file.

Graph API
I understand people have managed to access the score data using the Graph API; however, I see threads suggest that the API doesnt work or isn't supported.

Does anyone know what the latest information is regarding automatically retrieving MS Form 'scores'?Thankful for any information I can get

Kwabena Ampong-Marfo Frimpong 0 Reputation points

2026-02-23T12:06:42.3666667+00:00

Hello @Daniel-Vo Please can you respond again to this, I have the same question asked here, The Data Sybc to Excel does not work unless is opened, that is not helpful to the Power Automate for us to send emails for people to know if they passed or not.
Daniel-Vo 4,420 Reputation points Microsoft External Staff Moderator

2026-02-24T13:11:30.0366667+00:00
Hi Kwabena Ampong-Marfo Frimpong, Chaitanya Joshi,

Thank you for your clarification.

Currently, the “When a new response is submitted” trigger (available through the Microsoft Forms connector in Power Automate) does not include the calculated quiz score in its output. While quiz scores are visible in Microsoft Forms and can sync to Excel, the score field itself is not exposed through the trigger or the “Get response details” action. This reflects the current product design rather than a bug or error.

According to the Microsoft Forms connector reference documentation, triggers and actions expose specific fields and known limitations; the quiz score field is currently not part of the dynamic content returned by the Forms trigger or “Get response details” action: Microsoft Forms - Connectors | Microsoft Learn

If your scenario requires sending a pass/fail email immediately after submission, relying solely on the Excel sync may not meet the requirement due to sync timing behavior.

Down here are some possible workarounds:

Option 1/ Calculate the score directly inside the flow (recommended for real-time automation) You can:

Use the “When a new response is submitted” trigger.

Add “Get response details.”

Initialize a variable (for example, TotalScore = 0).

Add Conditions to compare each answer with the correct value and increment the score accordingly.

Use the calculated score to determine pass/fail and send the email.

-> This approach ensures the email is sent immediately without depending on Excel sync timing.

Option 2/ Retrieve the score from the synced Excel file If you prefer to use the score calculated by Forms:

Add a short Delay after the trigger.

Use the Excel Online connector to read the row from the synced workbook.

Retrieve the “Total points” column and use it in your logic.

Please note this method depends on the synchronization timing between Forms and Excel.

Hope this message can fulfill your concerns.

1 answer

Your answer

Kwabena Ampong-Marfo Frimpong 0 Reputation points

2026-02-23T12:06:42.3666667+00:00

Hello @Daniel-Vo Please can you respond again to this, I have the same question asked here, The Data Sybc to Excel does not work unless is opened, that is not helpful to the Power Automate for us to send emails for people to know if they passed or not.

Answer 1

Hi Ben S,

Thank you for posting your question to the Microsoft Q&A forum.

With the recent Forms Data Sync to Excel enhancement, quiz response data (including score) can sync automatically to the connected Excel workbook. You may refer to this article for more details: https://techcommunity.microsoft.com/blog/microsoftformsblog/introducing-forms-data-sync-to-excel/4036051

To better understand your requirement and provide the most suitable approach, could you please clarify the following:

1/ Are you expecting your Power Automate flow to retrieve the quiz score directly from the Forms trigger at the moment the response is submitted? Or are you looking to retrieve the score from the synced Excel file after the data has been written there?

2/ Once the score is retrieved, what would you like the flow to do next (for example, send an email, update another system, trigger approval, etc.)?

This clarification will help determine whether the Excel sync can be leveraged as the data source, or if the score would need to be calculated within the flow logic. Looking forward to your update.

If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Daniel-Vo 4,420 Reputation points Microsoft External Staff Moderator

2026-02-20T14:27:20.14+00:00

Hello,

I am writing to you again to find out if the above information was helpful.

If you have any updates regarding this issue, please feel free to reply in this thread.

If my answer was helpful, I would appreciate it if you would mark it as the solution.

Thank you very much.
Chaitanya Joshi 0 Reputation points

2026-02-21T18:11:26.0966667+00:00

Hello,

I have a similar project as BenS.

With my project the score should get retrieved from the Forms trigger and used to add to a Excel spreadsheet.

Could you help me out?

Share via

Best way to automatically get the score from a Microsoft Form response?

1 answer

Your answer