Forum Discussion
KingHong
Jan 28, 2024Copper Contributor
How do I make a column in a Microsoft SharePoint an auto-incrimenting identifyer?
How do I make a column in a Microsoft SharePoint an auto-incrimenting identifyer that the user can not edit? I want it such that an ID field is incrimented automatically when a user enters a new row ...
Rob_Elliott
Jan 28, 2024Silver Contributor
KingHong the simplest way is just to show the ID column in your view. This auto-increments and cannot be edited:
But if you want the Title column to hold a unique, incrementing value then you will need to build a flow in Power Automate to populate this. It would get the highest value from your increment column, increment it by 1 and update the item that has just been created. But you cannot make this column non-editable as SharePoint doesn't have column-level security like a database, for example Dataverse, does.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)