Answered

MS Forms Quiz Scores to SharePoint List

(0) Share

Report

Posted on by chadvargo Microsoft Employee

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?

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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-Quiz-to-Teams/td-p/412623

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

Was this reply helpful? Yes No
chadvargo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @chadvargo ,

What's the error message?

Could you share any screenshot?

Best Regards,

Wearsky

Was this reply helpful? Yes No
chadvargo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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"

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
chadvargo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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#if

Best Regards,

Wearsky

Was this reply helpful? Yes No
chadvargo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @chadvargo ,

I made a sample for you.

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
chadvargo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No