Microsof Lists - when "ID" column added to Lists view, it generated all numbers except number 9

Petr Marak 62 Reputation points
2022-07-18T13:37:56.07+00:00

Hi all,

when I added to my Lists view "ID column", it generated unique IDs for all the items in the view, but for some reason it skipped number 9. I tried to remove the column, add again - the same results. There is nothing suspicious in column set up as I reviewed... Weird... Any explanation?

Microsoft 365 and Office SharePoint For business Windows
Microsoft Security Microsoft Graph
{count} votes

1 answer

Sort by: Most helpful
  1. Tong Zhang_MSFT 9,251 Reputation points
    2022-07-20T08:38:18.247+00:00

    Hi @Petr Marak ,

    Please try to do a troubleshooting:

    1. Check if an item was deleted.
    2. Check if the same situation occurs in other lists.

    The ID column generates unique IDs for all items . In my test, if I delete an item ,and then I add the ID column, I will find that it skips a number.

    For example(as shown below): I delete the "ddd" item, then added the ID column, it skipped the number 4.
    222593-pic1.png 222594-pic2.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.