Fix SharePoint Auto-Generated ID Not Displaying in List Column
Question details
New SharePoint list items are receiving auto-generated IDs, but these reference numbers are missing or not visible in the column view.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Managing list items and workflows in SharePoint where newly generated IDs need to be tracked and visible to team members.
- Observed behavior
- Older values display correctly, but the latest auto-generated IDs remain blank or invisible in the list column.
Ensure you have the necessary edit or admin permissions for the SharePoint list to modify column configurations, view settings, and access workflow histories.
Verify List View and Column Settings
The most common reason for hidden IDs is that the column was accidentally removed from the active view or its data type was altered.
SharePoint views can sometimes be customized or filtered in ways that unintentionally hide specific columns. Checking the active view settings ensures the column is toggled on for display.
Open your SharePoint list, click on the view dropdown menu in the top right corner, and select 'Edit current view'.
Scroll through the list of available columns and verify that the checkbox next to your auto-generated ID or reference number column is selected.
Go to the List Settings, click on the reference number column, and ensure its data type is correctly set to 'Number' or 'Single line of text'.
Save your view changes, return to the list, and refresh the browser page to see if the missing IDs populate.

Check Power Automate or Workflow Run History
If the reference number is generated by a custom workflow, a failed run might prevent the ID from being assigned to the new item.
Troubleshoot Browser and Sync Delays
Sometimes, the issue is purely a temporary caching or synchronization delay on the web interface.
Need a Lightweight Alternative to Microsoft Office? Try WPS Office
While SharePoint is great for enterprise list management, WPS Office provides a highly compatible, easy-to-use suite for your daily document creation, spreadsheet analysis, and presentation needs without complex configurations.
- 1. Download the installer: Visit the official WPS Office website and click the free download button.
- 2. Install the software: Run the downloaded installation package and follow the simple on-screen instructions.
- 3. Start creating: Open WPS Office to seamlessly open, edit, and save your existing Office documents.

Frequently Asked Questions
Why does the default SharePoint ID column sometimes skip numbers?
SharePoint auto-incrementing IDs can skip numbers if items are created and then deleted, or if a list item creation fails after the ID was already allocated by the backend SQL database.
Can I edit the auto-generated ID in a SharePoint list?
No, the default system-generated ID column in SharePoint is strictly read-only and cannot be manually edited, overwritten, or reset by users.
How do I recover an ID column that disappeared entirely from my list?
Click on 'Add column' at the far right of your list headers, select 'Show/hide columns', locate the 'ID' or your custom reference number column in the right-hand pane, check its box, and click 'Apply'.
Why are my Power Automate workflows failing to update the list column?
This typically happens due to permission changes on the list, invalid data types being passed to the column, or the flow attempting to update the item before it is fully created. Check the flow's run history for precise error codes.




