Forum Discussion
Limit number of responses on a form
It would be really useful to be able to retrict the number of responses to a form. I use microsoft forms as an ordering device for food and need to be able to limit the number of responses (in a sim...
Put some sort of approval or validation after the form is completed so the form is a request but the recipient has to get an approved email first. To do this, use Flow to capture when a form is completed and write the data to a SharePoint list, you would add a step to query the list to get previous bookings or request for the room or the person using the Odata filter, then just add a condition on the count of the returned items from SharePoint and send either apporved or declined email. You could also add an email to yourself when a limit for a room booking is reached so you can put an end date on the form to stop further submissions.
Hi Alan,
It is nice to get an answer to a request I've had ever since I'm using Forms. Your solution seems okay as far as I understand your solution, I'm not that big on Flow and Sharefilelists and filters.
I do not know how to capture a Form with Flow, how to sent data from Forms to a SharePoint list, I never heard of an Odata filter so you see although I logically understand your answer (make a datalist, check it, send an email) as do I understand how my bicycles work but, sadly, that doesn't mean I kan build them.
So your answer is very much apreciated but I'm afraid it will take me the better part of a few days before I'll be near a replication of your solution.
