Unanswered

In my Power Automate Flow, how can I also transfer the points, not just the answers, from a Forms Quiz into Excel ?

(1) Share

Report

Posted on by MuMlerin

I have created an automation via Power Automate that when I get a new answer in my MS Forms quiz, it automatically adds a new row in my Excel spreadsheet stored on OneDrive. The answers to the questions are already transferred, but the points that result from the individual questions are not yet. How can I make sure that the points are also transferred to Excel?

I am grateful for any help!
THANKS

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MuMlerin ,

This is a common question that we all have asked. Here's what I can share: the quiz scoring feature is only available inside Microsoft Form quiz forms and the related excel result file but the scoring for each question and totals are not available as dynamic content in Power Automate. There is a small workaround:

Using variables and composes, you can assign a value to each question and then sum up those values for the total quiz score. However, an easier way to "score" your results is directly inside your excel worksheet using a simply =if() function.

Was this reply helpful? Yes No
MuMlerin 4 on at

Like (0)

Report

Hi @trice602,
thanks already for the help. Can you explain the step in more detail? I'm not a professional unfortunately and don't really understand what I need to do. Because, unfortunately, I don't even know how to transfer the score of a single question into Excel via Power Automate.
"Using variables and compositions, you can assign a value to each question and then sum those values to get the total score for the quiz."
Thank you! 🙂

Was this reply helpful? Yes No