How to use conditions when connecting to an MS Form question with more than one answer

(1) Share

Report

Posted on by Kukaicho

Hey all,

I have been trying to create a flow that does the following:

- Automatically trigger when a new MS Form response is submitted

- Use conditions to check if the answers they picked in the form are correct, if so award 10 points to a variable

- Use the 'Compose' action to sum up all the awarded points

- Transfer the desired information into an Excel table.

Now here is the issue. One of my questions within the MS Form has two correct answers, and I cannot figure out how to properly run that through my flow. I attached the screenshots of what I am trying to do. and what the output is. I really would appreciate if someone could help me come up with an answer.

Thank you!

Categories:

Building flows

Form.png

Automation.png

Testing Failed.png

I have the same question (0)

All responses (10)

Answers (0)

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Kukaicho ,

I'll ask a question you have probably already investigated: have you considered just using the Quiz forms in MS Forms? I love the idea of assigning points to the correct answers and validating reasons why a question was correct or incorrect. The math is completely calculated for you and you can give a pass or fail. Please mark as a solution if this helps you move forward! Always glad to help! Tom

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report
Hi,
See these sample forms and flow to illustrate:

Flow use "When a new response is submitted" trigger
initialize an integer 'Score' variable
Add "Get response details" action
Add "Apply to each" action and set input with JSON converted "Question" dynamic content: in my exemple the expression is:
json(outputs('Get_response_details')?['body/r36552ba415b546c6850d31d723fb6b61'])

Add a condition to check if current item starts with the letter you gave to right answer:
Increment 'Score' variable when true. I increment by 5 if one answer is correct, so both selected gives 10.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

I forgot to include, yes you can have multiple answers and score accordingly too.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report

Sorry trice602, didn't saw you've already answered. Your answer looks nice, I've focused on how to do with flow not with forms.

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SamLed - I like what you have here. The quiz feature is so well built for quizzes with shuffled questions, scoring, reasons for correct or incorrect answers, I no longer do anything in PA for quizzes; well, except for sending the results to a SharePoint List maybe. I've also created a certification of completion at the end for those that passed the test and emailed it to them and their supervisor! Always glad to help! Tom

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report

Hi Tom,
Of course, I more a SharePoint specialist and a senior coder (not to say old 😉) and I don't know forms so well. I must admit your solution looks easier to implement and to maintain, codeless solution is always better (even if we can't really qualify PA as code), quite sure you can also export results to Excel as needed by Kukaicho.
Sam

Was this reply helpful? Yes No
Kukaicho 8 on at

Like (0)

Report

Hey SamLed,

I appreciate your response. I'll try this out and see if it works for me. Thanks for your input.

Was this reply helpful? Yes No
Kukaicho 8 on at

Like (1)

Report

Hey trice602,

I appreciate your response. My Form is already a quiz, so it does score itself. What I was trying to do was to export the score into an excel sheet. Still, thanks for your input!

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Understood. I know after I "post scores" I do get the scores in Excel but that is not automated however, you could post the scores using Power Automate Desktop and drive the scores into Excel. Tom

Was this reply helpful? Yes No
ramysss 2 on at

Like (0)

Report

In Microsoft Forms if I have the next case Question: Book the appropriate training program date for you. Options: February 21st February 22nd February 23rd Condition: No more than 20 people can choose each date. Additional English phrases that may be helpful: Limit the number of responses: Only allow 20 people to select each option: Once 20 people have selected an option, it will become unavailable. What do I do to resolve this case?

Was this reply helpful? Yes No