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

Like (1) Share

Report

Posted on 9 Aug 2023 20:49:18 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!

Form.png

Automation.png

Testing Failed.png

All responses (10)

Answers (0)

ramysss 2 on 20 Feb 2024 at 10:19:15

Like (0)

Report

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

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?
trice602 13,760 Super User 2025 Season 1 on 09 Aug 2023 at 23:08:15

Like (0)

Report

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

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
Kukaicho 8 on 09 Aug 2023 at 22:51:58

Like (1)

Report

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

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!
Kukaicho 8 on 09 Aug 2023 at 22:50:49

Like (0)

Report

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

Hey SamLed,

I appreciate your response. I'll try this out and see if it works for me. Thanks for your input.
SamLed 2,332 Moderator on 09 Aug 2023 at 22:07:36

Like (0)

Report

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

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
trice602 13,760 Super User 2025 Season 1 on 09 Aug 2023 at 21:45:31

Like (0)

Report

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

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
SamLed 2,332 Moderator on 09 Aug 2023 at 21:42:19

Like (1)

Report

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

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.
trice602 13,760 Super User 2025 Season 1 on 09 Aug 2023 at 21:39:35

Like (1)

Report

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

I forgot to include, yes you can have multiple answers and score accordingly too.
SamLed 2,332 Moderator on 09 Aug 2023 at 21:38:14

Like (1)

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

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.
trice602 13,760 Super User 2025 Season 1 on 09 Aug 2023 at 21:37:50

Like (1)

Report

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

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