SharePoint Document Issues

Fix FirstPublishedDate Missing from SharePoint Sort Options

Algirdas JasaitisAlgirdas Jasaitis Oct 28, 2026 869 views

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.

Fix FirstPublishedDate Missing from SharePoint Sort Options
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.
Before you start

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.

Solution 1Recommended

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.

1
Access view formatting

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

2
Backup and clear JSON code

Copy your existing JSON code to a safe text editor like Notepad. Delete the code from the formatting pane and click 'Save'.

3
Sort by FirstPublishedDate

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

4
Save the view

Click on the view dropdown menu again and select 'Save view as' to lock in the new sorting preference.

5
Reapply JSON formatting

Return to 'Format current view', paste your original JSON code back into the formatting pane, and click 'Save'.

Temporarily Remove JSON View Formatting
Community Support: If the issue persists after removing JSON formatting, consider reaching out to the Microsoft Tech Community for advanced, site-specific troubleshooting.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS website to download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the downloaded file and follow the simple on-screen instructions to complete the setup.
  3. 3. Open existing documents: Launch WPS Office and directly open your Microsoft Word, Excel, or PowerPoint files without losing any formatting.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) for seamless sharing.Lightweight design ensures fast startup and smooth operation even on older devices.Familiar user interface with zero learning curve for a quick transition.Built-in cloud storage and collaboration tools tailored for efficient document management.
microsoft office alternative - wps office

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.