Forum Discussion
Maximum value for SharePoint List unique ID
Hi everyone,
I have a SharePoint List that gets updated daily. I have 25000-30000 items that get completely deleted every night and then created again with new values and content. So every new item gets a new list ID.
I'm a little bit worried because, even though SharePoint lists can store up to 30 Million items, what happens when the unique ID assigned to each item gets "overflowed"?
For example, right now the last item's ID is 480368, and as I said before I create 30000 new items every single day , so doing a simple math it would take 1000 days to reach an ID number of 30000000 (if that's possible, I don't even know).
What happens when the ID reaches a limit? Would it break the list? Will I be able to keep creating new items?
Just to make it completely clear: the list will never reach the 30 million limit. It will always stay on 25000-30000 items. But I'm scared that the ID will break this process in less than 3 years.
Thanks for your help!
3 Replies
Hi BagsOfSand,
There’s no explicit confirmation from Microsoft about the maximum value of the SharePoint List ID column. However, since the ID is of type Counter, which maps to a 32-bit signed integer, and SharePoint uses SQL Server as its backend (where int is 32-bit), the practical limit is 2,147,483,647. At a rate of 30,000 new items per day, it would take approximately 196 years to reach that limit—so there's no realistic risk of overflow.
---------------------------------------------------------------------------------
If this response was helpful, kindly consider marking it as the accepted answer.
I have the same setup and I'm concerned about this too, highest ID for me today is 1008041.
I have exactly the same situation and having the same concern, can anyone from Microsoft be able to confirm?
