Answered

Can a SharePoint ID be specified or modified?

(0) Share

Report

Posted on by 55552

682

Is it possible in Power Automate to specify a SharePoint ID column value when creating new list items, or when updating items? Or is that column completely protected? I have a Flow which deletes all the items in a list nightly (1600 items), then replaces them with new items from an SQL table. It works fine, but my SharePoint IDs keep getting larger each night. Maybe this is not a problem, but I would prefer to force them to start over with 1 each night. However, in the create item or update item action, there does not seem to be a way to push a value into the SharePoint ID column.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Runner55552

You won't be able to update the id's via Flow. You would be better to maintain a custom column and update via flow to maintain the id's you want. Also consider creating a custom list where to start from and current index or something so that when ever an item creates read the custom list to get the latest and update the custom list with latest value.

http://niftit.com/how-reset-the-id-counter-in-sharepoint/

Please have a look at the above link. Again not sure whether it is supported or not?

Thanks

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Runner55552,

Unfortunately, there is no way to reset the ID field via Flow, the ID will increase when a new item created, even though these previous items were deleted. So you could create a column, such as itemID, just as you like. Then edit the current view of SharePoint list to hide the ID field and make the itemID visible.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No