SOLVED

if statement on microsoft form app

%3CLINGO-SUB%20id%3D%22lingo-sub-320236%22%20slang%3D%22en-US%22%3Eif%20statement%20on%20microsoft%20form%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320236%22%20slang%3D%22en-US%22%3E%3CP%3EHallo%2C%20I've%20a%20Microsoft%20forms%26nbsp%3B%20app%20with%2012%20questions.%20I'd%20like%20that%20if%20the%20user%20answer%20correctly%2010%20questions%20he%20is%20redirected%20to%20a%20specific%20url%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShoud%20I%20use%20Microsoft%20flow%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Alex%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320236%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-324170%22%20slang%3D%22en-US%22%3ERe%3A%20if%20statement%20on%20microsoft%20form%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324170%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20mutch%26nbsp%3B%20Maruthi%2C%26nbsp%3B%20you%20saved%20me!!!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%26nbsp%3B%20add%20just%20this%20picture%20to%20specify%20that%26nbsp%3Bthe%20condition%20are%26nbsp%3B%20inside%20the%20loop%20%26nbsp%3B%20%22Apply%20to%26nbsp%3B%20each%22%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20in%20%22Select%20output...%22%20I%20selected%20%22Elenco%20di%20notifiche%20di%20risposta%22.%20As%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22quizflow.PNG%22%20style%3D%22width%3A%20600px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F70690i1D9C7CD43BE79A31%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22quizflow.PNG%22%20alt%3D%22quizflow.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThank%20you%20again!!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321723%22%20slang%3D%22en-US%22%3ERe%3A%20if%20statement%20on%20microsoft%20form%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321723%22%20slang%3D%22en-US%22%3E%3CP%3Echeck%20the%20attachment.%20let%20me%20know%20if%20this%20fixes%20your%20issue.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321501%22%20slang%3D%22en-US%22%3ERe%3A%20if%20statement%20on%20microsoft%20form%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321501%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Maruthi%2C%20in%26nbsp%3B%20the%20condition%26nbsp%3B%20should%20I%20select%20%22Elenco%26nbsp%3B%20di%20notifica%20di%20risposta%20ID%22%20%3F%20And%20in%26nbsp%3B%20the%20cell%20%22scegliere%26nbsp%3B%20un%26nbsp%3B%20valore%22%20what%20string%20should%20I%20write%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22flow1.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F69148i1CFE4BF2E972C647%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22flow1.PNG%22%20alt%3D%22flow1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22oSioSc%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EB)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22flow2.PNG%22%20style%3D%22width%3A%20550px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F69149iD1E1F6BC649DD761%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22flow2.PNG%22%20alt%3D%22flow2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20step%20by%20step%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320393%22%20slang%3D%22en-US%22%3ERe%3A%20if%20statement%20on%20microsoft%20form%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320393%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20an%20Ideal%20Scenario%20You%20should%20be%20able%20to%20define%20Points%20for%20Each%20Question.%26nbsp%3B%20Trigger%20a%20flow%20when%20a%20response%20is%20Submitted%20.%26nbsp%3B%20Get%20the%20Points%20of%20the%20respondent%20and%20see%20if%20it%20is%20greater%20that%20X.%20Then%20send%20an%20email%20to%20the%20User.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%26nbsp%3B%20you%20do%20not%20get%20the%20Points%20scored%20by%20the%20respondent%26nbsp%3B%20in%20Flow%26nbsp%3B%20trigger%20whenever%20a%20Request%20is%20Submitted.%20You%20get%20the%20Response%20ID.%20Based%20on%20the%20Response%20ID%2C%20you%20Get%20the%20response%20Details.%26nbsp%3B%20use%20Conditions%20and%20Validate%20The%20response%20for%20Each%20Question%20Submitted%20by%20the%20user%20to%20the%20actual%20and%20create%20a%20score%20within%20Flow.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20you%20send%20the%20email%20based%20on%20the%20Score.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20a%20bit%20complex%20but%20i%20think%20this%20is%20the%20only%20simplest%20way%20as%20of%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hallo, I've a Microsoft forms  app with 12 questions. I'd like that if the user answer correctly 10 questions he is redirected to a specific url page.

 

Shoud I use Microsoft flow? 

 

How can I do that?

 

Thanks Alex

4 Replies

In an Ideal Scenario You should be able to define Points for Each Question.  Trigger a flow when a response is Submitted .  Get the Points of the respondent and see if it is greater that X. Then send an email to the User. 

 

Unfortunately  you do not get the Points scored by the respondent  in Flow  trigger whenever a Request is Submitted. You get the Response ID. Based on the Response ID, you Get the response Details.  use Conditions and Validate The response for Each Question Submitted by the user to the actual and create a score within Flow.  

 

Then you send the email based on the Score.  

 

It is a bit complex but i think this is the only simplest way as of now

 

Hi Maruthi, in  the condition  should I select "Elenco  di notifica di risposta ID" ? And in  the cell "scegliere  un  valore" what string should I write?

 

A)

flow1.PNG

 

B)

flow2.PNG

 

 

 

 

Please step by step

Thank you

 

 

best response confirmed by shozo lojacono (Occasional Contributor)
Solution

check the attachment. let me know if this fixes your issue. 

Thank you so mutch  Maruthi,  you saved me!!! 

 

I'd like to  add just this picture to specify that the condition are  inside the loop   "Apply to  each" 

and in "Select output..." I selected "Elenco di notifiche di risposta". As below:

quizflow.PNG

Thank you again!!!!