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.

In addition to limiting the number of responses to a whole form, it would be helpful to limit the number of people choosing a particular response to a question. For example, we'd like to create a sign-up sheet with multiple activity options, but each activity is limited to 16 people. We'd love to have an option disabled as a choice when it reaches the max number of people choosing it.

A setting for a max number of responses would be very useful.

Exactly... Google has an add-on called form limiter that does this. I would like to do the same thing and have a sign up form that limits the number of spots available for a particular choice.

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.

I created this example that you can use to create the Flow. I have a basic form with one question but can be more that runs to a particular day. Each person can only respond once (for testing I turned this off). Create the Flow trigger by item added with actions for getting form responses, get list items, condition on item count and then either email "no space" or get user details and add to SharePoint. If the get items, I created a Filter query: Course eq 'Forms and Flow training' this would match whatever you store in the Create item action. The condition formula is length(body('Get_course_attendees')?['value']). To create this, select Expression from the field selector that pops up and select length. Then click on Dynamic content and pick the Value field corresponding to the name of your Get Items action. I then check if its 1 as I only have space for 1 person on my course, you would obviously put in a higher number. You can also use values from the form in your SharePoint filter query. filter query documentation I exported the flow as well that is attached for you to import.

Limit number of responses on a form | Microsoft Community Hub

41 Replies

ta_pb
Iron Contributor
Jun 20, 2017
Hi Erica,
Some of these options do exist under "..." menu and "settings" but perhaps could be refined further.
See below
You can make suggestions and upvote on the official Forms uservoice forum here: https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box
- Abbody8002
  Copper Contributor
  Jan 06, 2024
  ta_pb have you find a solution for this? It's 2023 and I can't find a solution for this issue 🤦
  - KeithBGCAA
    Copper Contributor
    Apr 17, 2024
    Abbody8002
    
    It is now April in the year of our lord 2024 and this ~5+ year old question/feature is still unanswered and unavailable.
- Leah MacVie
  Copper Contributor
  Feb 08, 2018
  Yeah, that's not what we are asking for.
- Annie Contractor
  Brass Contributor
  Oct 13, 2017
  In addition to limiting the number of responses to a whole form, it would be helpful to limit the number of people choosing a particular response to a question. For example, we'd like to create a sign-up sheet with multiple activity options, but each activity is limited to 16 people. We'd love to have an option disabled as a choice when it reaches the max number of people choosing it.
  - Sabine Rietstap, te
    Brass Contributor
    Nov 17, 2017
    In any schoolorganisation this is a key feature. Totally agree with this request.
Geoffrey Bronner
Iron Contributor
Jun 18, 2017
A setting for a max number of responses would be very useful.

Forum Discussion

Limit number of responses on a form

41 Replies

Resources