web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Ms form with power aut...
Power Automate
Unanswered

Ms form with power automate

(0) ShareShare
ReportReport
Posted on by 7

Greetings team,

 

I'm seeking assistance to establish automated workflows.

 

I've configured a Microsoft Forms quiz for my group and aim to integrate it with Power Automate. The goal is to automatically send an email to the quiz participant if their total score falls below 80, detailing their score, the questions they answered incorrectly, and cc'ing me on the correspondence.

 

Despite exploring numerous options, I haven't succeeded in making this work and would greatly appreciate your help.

Categories:
I have the same question (1)
  • Verified answer
    RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    @hs101s this is possible but takes a lot more preparation than it should. My example here uses the classic designer as it is easier to show the steps.

     

    This is my form with 5 questions:

     

    0-Form.png

     

    The overall flow looks like this and there is a branch for each question and I've put the actions for each question inside a scope so that you can more easily copy the scope for each question then adjust, rather than having to create each branch action individually.

     

    0-FlowOverall.png

     

    The first part of the flow is as follows: 

     

    1-Flow.png

     

    Then add a Scope and inside it add the following Compose actions. Then add a condition with in this case Response3 is equal to CorrectAnswer3

     

    2-Flow.png

     

    In the green if yes channel add an increment variable action and add 1 to the varScore variable initialized above. In the red if no channel add an append to array variable action with the outputs of Question3:

     

    3-Flow.png

     

    Copy the scope and add it in for each question changing the question, correct answer, response conditions etc.

     

    Outside all the scope add a new step, a CVompose with the following expression to get the percentage score:

    mul(div(variables('varScore'), 5),100)

     

    4-Flow.png

     

    Then add a condition of the outputs of Percent is less than 80. Leave the red if no channel empty. In the green if yes channel add a join from the varIncorrect and a jojn with <br> so each incorrect answer will be on a separate line in the email.

     

    Finally add the Send an email action with the outputs of the Percent compose and the outputs of the Join Incorrect Answers.

     

    5-Flow.png

     

    In my test 2 questions were answered incorrectly and this is the email.

     

    6-Email.png

     

    Hope that helps, but if you have a lot of questions it will be a lot of work.

     

    Rob
    Los Gallardos
    Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

     

  • hs101s Profile Picture
    7 on at

    @RobElliott  you are a star 🙂 many thanks for your help, really appreciate it.

  • hs101s Profile Picture
    7 on at

    @RobElliott Sorry I noticed one issue with the email notification that shows the "incorrect questions" appears in different order in the email, example Q5, then Q6, then Q1, Then Q10. Is there a way I can put them in sequence/order, if not , then may be show them in bullet points.

     

    Lastly, I was wondering, if along with the %, we can show how many questions they answered wrong, example - 10 out of 20? if its possible.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard