Forum Discussion

Clint Lechner's avatar
Clint Lechner
Iron Contributor
Jun 20, 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's avatar
SergeiBaklan
Diamond Contributor
May 15, 2019

LucianC , I added to the sample renaming questions columns by their IDs since that is required some coding. Steps are

<prev step>
    QuestionIDs = {"1"..Number.ToText(List.Count(Table.ColumnNames(ProperType))-nLastBeforeQuestionsPosition)},
    QuestionsRenameList = List.Zip(
        {List.RemoveFirstN(Table.ColumnNames(ProperType),
        nLastBeforeQuestionsPosition),QuestionIDs}),
    QuestionsToIDs = Table.RenameColumns(ProperType,QuestionsRenameList),
<next step>

IDs for questions also added to Answers table. Please note IDs shall be used as text.

LucianC's avatar
LucianC
Brass Contributor
May 15, 2019

SergeiBaklan, thank you again for your detailed explanations, and for what I discovered until now from your sample I could mention two important advantages:

  1. Using your approach with an "answers" table I can see that:
    1.  I could award points based on the answer "weight" - this could not be done with Microsoft Forms - Quiz type
    2.  In this case is no longer necessary to use the Quiz Type so I could use a Form Type
  2.  Now because I no longer need a Quiz type form, using a simple Form have another advantages:
    1.  I no longer need Flow to put the answers into an Excel file because for this kind of form an Excel file will be created automatically on the corresponding SharePoint Site
    2.  So PowerQuery will have access directly to online Excel file.

Isn't that great? :)

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 15, 2019

    LucianC , yes, that's a great idea. Work with surveys linked to Excel is much easier than with quiz. Why we use it that's since user see the points right after submitting the form. They may, even shall, to repeat attempts (not necessary in the same session) till hit the bar collecting required number of points. That's kind of introduction training.

     

    In general to show the summary you may use the same connected to the form Excel, put it into another sheet of the same file. I more trust to "co-authoring" with Sharepoint app  which updates the file rather than to the flow.

     

Resources