Is it possible to display the most recent 5,000 items in a list using the ID ? If the answer is yes, then how ? Also, is the ID inherently have an index ?

I noticed when I tried to create an Index on ID it was not an available field.


if the concern is just to get the most recent items, get it on the basis of Created date.

| improve this answer | |
  • How would I get the most recent 4,999 based on Created Date ? – daPlayaURH Nov 30 '17 at 3:25

5000 is the list item limit for a view, or as Microsoft puts it, "approximately 5000". (Source) So in theory the number is achievable.

ID has an incremental number as its value, but it is not available as a column to be shown. If you want to use it, you may achieve it by creating a calculated column which uses the value of [ID]. Bear in mind, that when a list item is removed, its index value becomes empty.

| improve this answer | |
  • If I create a calculated column then how do I view the most recent 5,000 – daPlayaURH Nov 30 '17 at 3:27
  • @daPlayaURH The item limit for a view is defines in the list's view settings. Adjust the item limit -setting according to your needs. – moe Nov 30 '17 at 8:04

You may want to make a view that shows items sorted by Created or Modified date to see the recent items in the list according to that. I wouldn't rely on ID's alone because they increase as time goes by but don't get replaced or re-used when users delete items in the list.

According to this the built in ID column is already indexed as it is a system field(column). https://msdn.microsoft.com/en-us/library/ff798465.aspx

| improve this answer | |
  • But if I sort on Created date and it gets beyond 5,000 I will not be able to view the list ? What am I missing ? thx – daPlayaURH Nov 30 '17 at 3:27
  • dealing with larges lists that exceed 5000 doesn't matter what you sort by. its a combination of using column indexing, using filers, and folders is what helps you overcome this. There are several articles on the web that talk about the 5000 view limit. See this slide deck for more: slideshare.net/gzelfond/… – Chris G Nov 30 '17 at 14:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.