Forum Discussion

Hasan300's avatar
Hasan300
Copper Contributor
Apr 19, 2021

Want to add a restriction that will only allow you to submit your response if it adds to 100

Hi all,

 

I hope you're all well.

 

I am currently working on a form where I want to add in a restriction where if all the numbers to the questions don't add up to 100, it wont let the user submit it until it does. For example:

 

Answer to Question 1 = 25

Answer to Question 2 = 25

Answer to Question 3 = 25

Answer to Question 4 = 30

 

Then when the user goes to submit the response, a message comes up saying something like "All your answers must add up to 100" or something similar to that.

 

Is this possible on Microsoft Forms?

 

Thank you! 🙂

 

microsoft forms
Quiz
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Apr 19, 2021

    Hasan300 no it's not possible with Forms. You would need to create a flow in Power Automate to do the calculations and if they added up to 100 then save it to a SharePoint list or spreadsheet, and if they don't then send an email back to the responder asking them to resubmit (and of course it doesn't get saved to the list/spreadsheet).

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources