Forum Discussion
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 submi...
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