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

New Contributor

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! :)


1 Reply

@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).


Los Gallardos
Microsoft Power Automate Community Super User