Forum Discussion

Iron Contributor

Jun 21, 2017

Quiz score via Flow?

It's great that you can use Flow to get Forms info and run workflows, etc, but curiously I see that the score isn't available. Seems like a strange piece to leave off.

microsoft forms

Quiz

SergeiBaklan

Diamond Contributor

May 15, 2019

LucianC , yes, unfortunately no direct solution. As workaround I collect answers by flow in Excel file published on SPO. From another Excel Power Query it, as well as table with answers and points in one more file plus some additional information from HR SQL database. This Excel with it's data model is published on Power BI services for scheduled updates. Using it one more flow sends reminders to people who didn't take the test in time and some summary is published in Teams as Power BI report.

Bit complicated, but fully automatic.

LucianC

Brass Contributor

May 15, 2019

SergeiBaklan, thank you for your message and workaround tip. Until Microsoft will decide to shorten my path I think I will have to use your workaround. :-)

The first part with getting the answers into an Excel file is done.

But for the second part - using PowerQuery to match the responses with a "CorrectAnswers" table... is harder for me. Could you point me to a link or an example? I'm a "basic user" with PowerQuery and I don't imagine how could I calculate the total points for each answer.