07-28-2017 08:33 AM
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.
07-28-2017 08:57 AM
07-28-2017 11:32 AM
Hello,
I'm not sure if there is a way to actually do what your asking but there is one idea that came to mind if you would like to give it a try.
I created a test list that has a Choice column that has some numbers or text. (I used numbers 1-3 for my choices.) Once that was set I made the column required and also set it to enforce unique values. This requires users to use the column and then only allows each choice to be used once in the list. Therefore if I have 3 choices there will only end up being 3 items in my list at any given time. (unless i delete them)
In a way I'm using the enforce unique values column setting to limit the data that is used in the list overall. Feel free to play around with this concept.
07-28-2017 01:49 PM
07-29-2017 04:19 PM
I've also wanted to do something like this in order to create a list that users can use to sign up for a class or event with a limited number of seats.
Would be great to be able to set the limit to, let's say 20 items, users trying to add more items should get a message saying this specific list is full. (custom message would be even more lovely)
07-30-2017 11:25 PM
We're having an annual "Summercourse" with various breakout sessions. Our employees can sign up for three breakout sessions of they're choise. Each breakout session has a limited number of seats available.
I've made a list for every breakout session, where people can put they're name up (O365 accountname), and would like to limit the number of entry's possible to the maximum number of seats available for that session.
07-30-2017 11:27 PM
07-31-2017 02:36 AM - edited 08-02-2017 04:01 AM
07-31-2017 04:20 AM
Solution07-31-2017 11:54 AM
Two possible approaches:
(1) Create a master list that will take registrations and a workflow that copies item into each breakout session list, or
(2) Create separate breakout sessions and have a workflow that starts automatically to check whether you've reached the maximum number of seats.
In both cases, you may have to include a hidden/restricted list that keeps track of the count. It will be more complex if you have to factor allowing 1st, 2nd or 3rd choice. I hope that helps.
08-02-2017 05:22 AM
Thank you all very much for suggestions. You were most helpfull!
@Warwick Ward, I tried you approach and it does the trick!
One master list with all sessions and places available.
One registrations list, with a lookup field to the masterlist, entry form shows only sessions that have places available.
When a registration is entered succesfuly a workflow kicks off and adjusts the number of available places in the masterlist.
Works just like it was meant to.
Thanks again!!
10-02-2017 04:33 PM
11-03-2017 02:17 PM
In SharePoint no of list item Threshold limit defined on tenant level, if you want to limit the number of items reach out to tenant admin. Other side if you want limit the list items in view then modify List view setting no of items you want to view.
Using developed a custom even receiver we can also limit the items that can be entered into a list.
Hope this helps!!
11-03-2017 02:22 PM
Hi, I think we can achieved by using SharePoint designer List workflow.
Create a SharePoint List Workflow on New Item Added.
Add a variable VarMaxVal and store max Val like 10
Add condition steps , If List field (ID) > VarMaxVal
Action Delete current Item.
I hope this helps!!
03-01-2019 01:06 AM
@Yvonne Klomp wrote:Thank you all very much for suggestions. You were most helpfull!
@Warwick Ward, I tried you approach and it does the trick!
One master list with all sessions and places available.
One registrations list, with a lookup field to the masterlist, entry form shows only sessions that have places available.
When a registration is entered succesfuly a workflow kicks off and adjusts the number of available places in the masterlist.
Works just like it was meant to.
Thanks again!!
Hi @Yvonne Klomp I am very much new to the sharepoint world. Would you mind sharing a bit more details on how you managed to setup this subscription list ?
Thank you in advance
Beata
01-17-2020 06:17 AM
Hi there, I know time has pasted since this issue was added, But would you be willing to share the steps you took to accomplish this. If can included scripts also if needed. thanks@Yvonne Klomp
02-14-2020 12:12 AM
This is so needed when your not a Sharepoint wizzard and just a teacher in a school! @Edvard Wikström