Fix FirstPublishedDate Missing from SharePoint Sort Options
Question details
The user is unable to sort a SharePoint Site Pages view by the FirstPublishedDate field because it is missing from the sort-field menu.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Configuring and sorting a Site Pages view in SharePoint.
- Observed behavior
- The FirstPublishedDate field is visible in the view but does not appear as an option in the sort-field dropdown menu.
Ensure you have the necessary site permissions (such as Edit or Full Control) to modify list or library views and formatting in your SharePoint environment.
Temporarily Remove JSON View Formatting
Clear custom JSON formatting to restore default sorting capabilities, then reapply it after saving the view.
In SharePoint, complex JSON view formatting can sometimes interfere with standard UI interactions, such as column sorting. By temporarily removing the code, you can enforce the sort parameter natively before reapplying your customizations.
Open the SharePoint Site Pages library where the issue occurs, click on the view dropdown menu in the top right corner, and select 'Format current view'.
Copy your existing JSON code to a safe text editor like Notepad. Delete the code from the formatting pane and click 'Save'.
Click directly on the 'FirstPublishedDate' column header in the list view and select your desired sorting order (e.g., 'Older to newer' or 'Newer to older').
Click on the view dropdown menu again and select 'Save view as' to lock in the new sorting preference.
Return to 'Format current view', paste your original JSON code back into the formatting pane, and click 'Save'.

Looking for a seamless and lightweight Office alternative?
While SharePoint handles complex site and document management, your daily document creation needs a fast, reliable, and highly compatible suite. WPS Office provides a free, lightweight, and easy-to-use alternative to Microsoft Office, ensuring seamless migration and robust format compatibility.
- 1. Download the installer: Visit the official WPS website to download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded file and follow the simple on-screen instructions to complete the setup.
- 3. Open existing documents: Launch WPS Office and directly open your Microsoft Word, Excel, or PowerPoint files without losing any formatting.

Frequently Asked Questions
Why are certain columns missing from the SharePoint sort options?
Columns may be missing from the sort options if they are Multi-line text fields, if custom JSON view formatting restricts standard UI interactions, or if the column type isn't supported for indexing and sorting in SharePoint.
Does FirstPublishedDate always appear in Site Pages?
The FirstPublishedDate is a default system column in SharePoint Site Pages libraries, but it must be manually added to the active view settings to be visible to end users.
Will removing JSON formatting delete my SharePoint data?
No, removing JSON view formatting only affects how the data is visually presented on the screen. It does not alter, delete, or modify the underlying files or metadata.
How can I request advanced support for SharePoint issues?
If standard troubleshooting fails, you can seek help in the Microsoft Tech Community for SharePoint, or contact your organization's Microsoft 365 administrator to submit an official support ticket.




