locked
Can PowerShell - have a SharePoint list ID start at a particular number like 2000 (instead of 1)? RRS feed

  • Question

  • Hi there

    Can PowerShell or something else do this please?
    How to have a SharePoint list ID start at a particular number like 2000 (instead of 1)?

    Thanks.


    • Edited by ran009 Friday, May 20, 2016 11:17 PM
    Friday, May 20, 2016 10:13 PM

Answers

  • List item ID field cannot be controlled or configured.

    AFAIK Only option is create 1999 items and delete them using some kind of script like PowerShell. Otherwise create a new column, and start from 2000 and maintain the rolling number using workflow or event receiver.


    ---
    Rajesh
    rjesh.com| @rjesh
    You don't need to buy me a beer, if helpful just smile, vote, and mark it as answer.

    • Proposed as answer by romeo donca Saturday, May 21, 2016 7:55 PM
    • Marked as answer by ran009 Tuesday, May 24, 2016 11:37 PM
    Friday, May 20, 2016 10:24 PM

All replies

  • List item ID field cannot be controlled or configured.

    AFAIK Only option is create 1999 items and delete them using some kind of script like PowerShell. Otherwise create a new column, and start from 2000 and maintain the rolling number using workflow or event receiver.


    ---
    Rajesh
    rjesh.com| @rjesh
    You don't need to buy me a beer, if helpful just smile, vote, and mark it as answer.

    • Proposed as answer by romeo donca Saturday, May 21, 2016 7:55 PM
    • Marked as answer by ran009 Tuesday, May 24, 2016 11:37 PM
    Friday, May 20, 2016 10:24 PM
  • You can have a column added to your list, and auto increment its value whenever an item is added using a workflow in SharePoint designer. So its value will always be ID + 199

    Friday, May 20, 2016 10:40 PM
  • Any PowerShell to reset this value?

    Thanks.

    Friday, May 20, 2016 11:16 PM
  • No Powershell too.

    ---
    Rajesh
    rjesh.com| @rjesh
    You don't need to buy me a beer, if helpful just smile, vote, and mark it as answer.

    Saturday, May 21, 2016 12:11 AM