SharePoint Document Issues

Fix SharePoint Auto-Generated ID Not Displaying in List Column

Rana GarciaRana Garcia Oct 19, 2026 870 views

Question details

New SharePoint list items are receiving auto-generated IDs, but these reference numbers are missing or not visible in the column view.

Fix SharePoint Auto-Generated ID Not Displaying in List Column
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.
Before you start

Ensure you have the necessary edit or admin permissions for the SharePoint list to modify column configurations, view settings, and access workflow histories.

Solution 1Recommended

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.

1
Edit the current view

Open your SharePoint list, click on the view dropdown menu in the top right corner, and select 'Edit current view'.

2
Check column display

Scroll through the list of available columns and verify that the checkbox next to your auto-generated ID or reference number column is selected.

3
Verify data type

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'.

4
Save and refresh

Save your view changes, return to the list, and refresh the browser page to see if the missing IDs populate.

Verify List View and Column Settings
Quick Tip: You can also quickly add hidden columns by clicking 'Add column' > 'Show/hide columns' directly from the list header.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website and click the free download button.
  2. 2. Install the software: Run the downloaded installation package and follow the simple on-screen instructions.
  3. 3. Start creating: Open WPS Office to seamlessly open, edit, and save your existing Office documents.
Highly compatible with Microsoft Word, Excel, and PowerPoint formatsLightweight design ensures fast loading and smooth operationBuilt-in cloud features for easy document sharing and collaborationFree to use with an intuitive, familiar user interface
microsoft office alternative - wps office

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.