MS Forms Quiz Scores to SharePoint List

[chadvargo]

I need some help getting the score from an MS Forms Quiz into a SharePoint list.  There doesn't seem to be a way to get the score directly from Forms, so I have tried to use Power Automate to help calculate the score based on the user's answers.

When I create a flow in Power Automate, everything works well in terms of the flow matching the user's answer to a pre-defined answer for one condition.  My issue is the quiz has 10 questions and I can't repeat the same process more than twice before the flow starts failing.  Any suggestions on how to fix this?

[v-xiaochen-msft]

Hi @chadvargo ,

Have a good day.

---

I can't repeat the same process more than twice before the flow starts failing.

---

I'm confused about this, could you explain it?

Do you want to get the total score and patch that score to the list?

If my guess is correct, please take a look at the solution.

https://powerusers.microsoft.com/t5/Building-Flows/How-to-sent-back-the-score-from-Microsoft-Forms-Q...

As you said, PA can't get the score of the quiz. 

Since your quiz has 10 questions, you may have to create a flow with 10 'condition' actions.

Hope it helps.

Best Regards,

Wearsky

[chadvargo]

Thank you for the suggestion, Wearsky!

I was building my current flow to include 10 conditions, but when I get to about 2 or 3 of the 10 conditions, the flow fails. I can't get the flow to successfully run all 10 conditions.

All of the answers to my quiz are longer text answers so I'm not sure if that is part of the problem.

[v-xiaochen-msft]

Hi @chadvargo ,

What's the error message?

Could you share any screenshot?

Best Regards,

Wearsky

[chadvargo]

Screenshots are below.  The first screenshot shows the flow failing the first two conditions but succeeding on the third which is odd because they are relatively the same except each condition represents a different quiz question.

Failed flow error:

"status": 400,

  "message": "Save Conflict.\n\nYour changes conflict with those made concurrently by another user. If you want your changes to be applied, click Back in your Web browser, refresh the page, and resubmit your changes.\r\nclientRequestId: 7f983afe-139e-4feb-97a4-bef290ce45f9\r\nserviceRequestId: 7f983afe-139e-4feb-97a4-bef290ce45f9"

[v-xiaochen-msft]

Hi @chadvargo ,

It may caused by multiple updates to the same record at the same time.

Please try using an expression instead of the condition action. In your case, I think expressions can replace condition action at all.

Sample:

Best Regards,

Wearsky

[chadvargo]

Thanks! I will try this approach with the expression. If question is true that would mean a match of the correct answer to that question? Do I have to define the correct answers somewhere?

[v-xiaochen-msft]

Hi @chadvargo ,

You can define the answer in the second parameter of the if() function.

Here is the documentation.

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#...

Best Regards,

Wearsky 

[chadvargo]

Thank you!  I'm struggling writing the expressions.

How would I write the expression to say if Question 1's answer equals "Safety Boots" then return 1 point as the score for that question (0 points if false).  I would then repeat this expression for all 10 questions.  Is that what I need to do?

Question 1: What safety equipment is needed?

Answer 1: Safety Boots

Point Value: 1

[v-xiaochen-msft]

Hi @chadvargo ,

I made a sample for you.

if(equals(outputs('Get_response_details')?['body/rada413fb486e4e1ebda17f25c29c0306'],'Safety Boots'),1,0)

Best Regards,

Wearsky

[chadvargo]

Thank you!  I tried this approach but I have an error in my expression.  The answers to my quiz questions are rather long and also include both English and French text (see sample below).

if(equals(outputs('Get_response_details')?['body/r22d7e63fdcde491d80265ae9416db942']'Stop intervention with immediate effect, proceed to the nearest emergency exit and reach the assembly point, pending instructions from Equinix / Arrêter son intervention avec effet immédiat, se diriger vers la sortie de secours la plus proche et rejoindre le point de rassemblement, en attente des instructions d'Equin'),1,0)

I have tried to shorten the expression to use contains rather than equals, but I still get an expression error.

if(contains(outputs('Get_response_details')?['body/r22d7e63fdcde491d80265ae9416db942'],Stop intervention with immediate effect'),1,0)

What am I doing wrong?

Also, maybe another approach. On my SharePoint list, I currently have the data from the correct answer to quiz question (Q1) and the user's answer (A1) updated into the list item in separate columns.  Could I use an expression to compare Q1 and A1 to see if they are equal then input a value of 1 into another column (S1)?  If Q1 equals A1 then S1 equals 1 (score).  I could also use if Q1 contains A1 then S1 equals 1.  How would I write the expression for this?

[v-xiaochen-msft · Accepted solution]

Hi @chadvargo ,

Please try this:

if(equals(outputs('Get_response_details')?['body/r22d7e63fdcde491d80265ae9416db942'],'Stop intervention with immediate effect, proceed to the nearest emergency exit and reach the assembly point, pending instructions from Equinix / Arrêter son intervention avec effet immédiat, se diriger vers la sortie de secours la plus proche et rejoindre le point de rassemblement, en attente des instructions d'Equin'),1,0)

if(contains(outputs('Get_response_details')?['body/r22d7e63fdcde491d80265ae9416db942'],'Stop intervention with immediate effect'),1,0)

Best Regards,

Wearsky

[chadvargo]

Thank you so much Wearsky!  The expression examples you provided worked!  Many thanks! 😁