SharePoint Document Issues

How to Keep a Microsoft List Sorted by Recent Date in SharePoint

Algirdas Jasaitis Oct 9, 2026 869 views

Question details

The user needs to ensure a Microsoft List displayed on a SharePoint page is consistently sorted to show the most recent date first.

How to Keep a Microsoft List Sorted by Recent Date in SharePoint

Product: SharePoint
Device & OS: not provided
Scenario: Displaying a Microsoft List using a SharePoint web part.
Observed behavior: The list items appear from oldest to newest instead of displaying the most recent presentation date first.

Before you start

Ensure you have Edit permissions for both the underlying Microsoft List and the SharePoint page where the list web part is embedded.

Solution 1Recommended

Edit the Target View and Sort by Descending Date

Modify the specific view used by the SharePoint web part to ensure the date column is explicitly sorted in descending order.

SharePoint web parts often display a specific 'View' of a Microsoft List. If the sorting is incorrect on the page, the underlying view assigned to that web part needs to be updated and saved.

Open the Microsoft List

Navigate to your SharePoint site contents and open the underlying Microsoft List that is exhibiting the sorting issue.

Select the active view

In the top right corner of the list, click the View dropdown menu and select the specific view that the SharePoint web part is currently using.

Sort the date column

Click the column header for your date field (e.g., Presentation Date), and select 'Newer to older' (descending) from the dropdown options.

Save the view changes

Click the View dropdown menu again in the top right corner and select 'Save view as'. Keep the same view name and click 'Save' to overwrite it with the new sort order.

Verify on the SharePoint page

Return to your SharePoint page and refresh it to confirm that the web part is now displaying the most recent items first.

Edit the Target View and Sort by Descending Date

Success Tip: If the sorting still does not update, edit the SharePoint page, edit the web part properties, and re-select the updated view from the dropdown menu to force a refresh.

Solution 2

Configure Sorting Directly in the View Settings

Use the advanced List Settings to enforce a strict primary sort order for complex lists.

Free Microsoft Office alternative

Manage Your Documents Effectively with WPS Office

While SharePoint and Microsoft Lists handle online tracking, WPS Office offers a lightweight, completely free alternative for your daily document, spreadsheet, and presentation needs. Experience seamless compatibility with Microsoft formats and a highly familiar user interface without the subscription fees.

1. Download the software: Visit the official WPS Office website and download the free installation package.
2. Install WPS Office: Run the installer and follow the lightweight setup wizard to complete the installation.
3. Open your data lists: Launch WPS Spreadsheet and open your existing .xlsx or .csv files to sort and filter your data locally.

Highly compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight installation and incredibly fast startup speed.Built-in robust spreadsheet tools for offline sorting, filtering, and data management.Completely free to use for standard daily office tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint list keep reverting to the oldest date first?

This usually happens because the default view is set to sort ascending (oldest to newest), or the web part on the SharePoint page is referencing a different view than the one you edited. Make sure to save the view changes permanently and verify the web part properties are mapped to the correct view name.

Can I set a custom sort order for multiple columns in a Microsoft List?

Yes, you can edit the current view settings from the list dropdown menu to add primary and secondary sorting rules, such as sorting by category first (ascending), then by presentation date (descending).

Do I need special permissions to change the sort order on a SharePoint page?

Yes, you must have at least Edit or Design permissions for the SharePoint list to modify and save public views, and Edit permissions for the site page to update the web part settings.

Document & File Issues