Forum Discussion
Solved
How can I limit the number of items that can be entered into a list?
I want to limit the number of items that can be entered into a list. Anyone have any suggestions on how to achieve that? Thx in advance for any help.
- You may be better off listing all sessions in one list with spots available
user registrations using a forms which go into another list, this form has a lookup to the sessions list with a filter to only show sessions with spots > 0. And a workflow on each registration to take a spot available from a session each time a person registers.
This would need to be an enhancement to out of the box forms using javascript, powerapps or another 3rd party forms product
For those of us that don't want to try programming this is a dirty way to get a limited list in Teams. Create an Excel spreadsheet in the teams channel with the columns you want. The last column run the number of rows you need 1 through say 200 (an example as many rows as you want). Save the spread sheet. Create the list using an excel spread sheet. Find your spreadsheet and follow the instructions which include setting the range you want as a table include all the columns and counted rows. Once you have refreshed and the table is in the list. Go to list settings and hide the counted row. This will give you a list with 200 empty rows that participants can fill in. It isn't pretty but it is fast. Yvonne Klomp