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 similar way as setting the end time)
It would also be extremely useful to get a notification when a form is completed and for the form filler to get a notification summary of how they have resonded.
Erica Schwiening This is available on Microsoft Forms Pro, but requires Microsoft Dynamics
This has been an ask for 5 years at this point, with folks re-asking as recently as last week. I'm wondering when Microsoft will make the switch or develop an add-on.
- Yuanquan
Microsoft
looping @Yichen_Zhao This blog will help you and others who are looking for this feature
https://wordpress.com/block-editor/post/coderscollection.wordpress.com/1683
Can I limit the number of answer choices a respondent can select?
On question types that allow multiple answer choices, rows, or textboxes, you can set a range or a limit on how many the respondent must answer.
Michaelamin no this isn't possible yet.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- Do we know anymore how to do this yet? Tried to use Alans way but my brain aint smart enough for that ðŸ¤
After choosing "When a new response is submitted", would you know why there is "No Dynamic Content Available"?
Please advise, thanks a lot!
Regards,
Anderson
Office Forms 365
Example: Nominations Form, 11 candidates, 5 spots to fill.
We have a form that list all 11 candidates and have to fill five spots, so we are asking the council to vote for only five candidates. Is there a way to limit the selections to go no higher than five choices allowed?
KristineHughes19 We have a similar need with MS Forms. A team is looking to have employees select a few sections with limited seating in the form. Unfortunately, we need to monitor the form and manually remove the items that become full. Would be a nice feature to fade out maxed out response items with a note that the limit has been reached. This would make MS Forms so much more useful for company environments.
Could you restructure your questions?
Have 5 questions, each with the same 11 candidates. Also allow for an empty/no response so they can vote for less. Gathering the statistics would be harder but that would give you the only 5 choices.
It would be nice if there was a way to limit the number of times somebody can respond on a form. For example, I use it for students to sign out of the room. I would like to limit the number of times to 4 a quarter. Any suggestions??
- 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. I hope I will have some days in the coming months, to try to make this work, but that will not be very likely.
Thank you very much for reacting, it was very nice thing to do.
I also would like this so that I can limit the number of signups to fit the room cap. For now, I have to find another solution that does this because I can't overbook an event sign up when the room itself ha a capacity.
