SharePoint Document Issues

How to Fix SharePoint List View Showing the Final Item Twice

Bushra Parveen Oct 9, 2026 869 views

Question details

The user needs to resolve an issue where a SharePoint list view duplicates the final item when specific filters are applied.

How to Fix a SharePoint List View Showing the Final Item Twice

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Filtering a SharePoint list to view specific records.
Observed behavior: The last item in the list appears twice despite having a unique ID. Filtering directly by the ID only returns a single result.

Before you start

Verify that the duplicate items share the exact same ID by temporarily adding the 'ID' column to your list view to rule out actual duplicate data entries.

Solution 1Recommended

Create a New SharePoint List View

This is the most effective workaround if the current view has become corrupted and is causing the duplication glitch.

SharePoint views can occasionally become corrupted, leading to display glitches such as showing items twice even when the data itself is fine. Creating a fresh view often resolves these anomalies.

Navigate to your list

Open the affected SharePoint list in your web browser.

Open view options

Click the View options menu (usually displaying the current view name) in the top-right corner of the command bar.

Create a new view

Select 'Save view as' or 'Create new view', give it a new name, and reapply your desired filters.

Verify the fix

Check if the new view displays the items correctly without duplicating the final record.

View Restored: If the new view displays properly, you can set it as the default view and delete the corrupted one.

Solution 2

Contact Microsoft Support via Tenant Administrator

If the duplication issue persists across all newly created views, it indicates a deeper backend problem requiring Microsoft Support.

Free Microsoft Office alternative

Try WPS Office for Your Document and Spreadsheet Needs

While SharePoint list backend issues require Microsoft Support, if you are looking for a reliable, lightweight, and cost-effective solution for your daily document processing, WPS Office is an excellent alternative. It offers powerful tools for text creation, spreadsheet data analysis, and presentations.

1. Visit the WPS website: Go to the official WPS Office website.
2. Download the installer: Click the 'Free Download' button to get the setup file.
3. Install and run: Follow the on-screen instructions to install and launch WPS Office on your device.

Highly compatible with Microsoft Excel, Word, and PowerPoint formats.Free and lightweight, ensuring smooth performance even on older devices.Familiar user interface makes transitioning seamless and quick.Includes built-in advanced PDF editing and conversion tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint list show duplicate items?

Duplicate display issues in SharePoint lists are often caused by a corrupted list view or complex filtering logic that glitches the rendering of the final item. If the underlying data (Item ID) is unique, it is a display issue rather than a data duplication issue.

How can I tell if an item is actually duplicated in the SharePoint database?

The most reliable way is to add the 'ID' column to your list view. SharePoint assigns a unique ID to every created item. If two rows have the exact same ID, it is a view rendering error. If they have different IDs, the data was accidentally entered twice.

Will deleting and recreating the list fix the view issue?

Deleting the entire list is usually unnecessary and risks data loss. It is recommended to simply create a new view first. If all views are affected, escalate to Microsoft Support before attempting drastic measures like recreating the entire list.

Document & File Issues