SharePoint item I.D

(0) Share

Report

Posted on by MiniMe_83

245

Hi,

Is there a way to change the ID number being produced when an item is added to a SharePoint list? We have an older system already producing ID numbers, which is in the 1000s, and I want to continue this sequence with the new SharePoint system.

I have tried creating a column named “Added Number” with a default value set, then created another column named “Reference” which will add my “Added Number” Column and the default “ID” column, using the following formula:

This is very hit and miss.

formula: =SUM([Added Number]+[ID])

Any ideas how to make this stable?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

rsaikrishna

3,703 on at

Like (2)

Report

@MiniMe_83

If you did not migrate all your old items to New items, then this question is related to SharePoint Migration.

You can use Sharegate or Context Matrix tools to migrate the SharePoint list items by preserving the List Item IDs but your new SharePoint list should be a NEW list without any items created by you. Item IDs are autogenerated. So, the migration tool options will maintain the Item IDs during migration process.

If you already migrated the SharePoint list items to New SP list, NewID. Write a Power Shell to copy the list item ID value to NewID column.

From Power App, you can set the NewID with appropriate increment on submitting the form.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@MiniMe_83
There is not any way to change the starting ID number of a SharePoint list.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Sharepoint-Online-List-ID-Starting-Point/td-p/294201

You have the right idea when it comes to creating your own reference number column but instead of making a formula in SharePoint you should do it in Power Apps instead. Include the 'Reference' field in your Edit Form and put this code in the Default property of its text box. It will calculate the next number in the sequence.

First(Sort(your_sharepoint_list, ID, Descending)).Reference + 1

Then go ahead and create a button to submit the form.

SubmitForm(Form1)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
MiniMe_83 245 on at

Like (0)

Report

@mdevaney

Im assuming the +1 within the formula is the offset which will compensate and make the ID number I wish to have?

Will give it ago now

Was this reply helpful? Yes No
MiniMe_83 245 on at

Like (0)

Report

@mdevaney

Not sure whats happened, Ive placed the formula in and as a trial I amended the +1 to +2002 (for testing) and have submitted a few items, the sequence of numbers 2002, 4002, 6002...... Im just looking for the number to continue on. I think I messed this one up 😩

Was this reply helpful? Yes No