"Cannot show the value of the filter" error when you try to sort or filter a column in SharePoint Online

PROBLEM

When you click the drop-down arrow to sort or filter a column in the view in Microsoft SharePoint Online, you receive the following message:
Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator.

SOLUTION

To resolve this issue, reduce the number of items in the view for the affected list or library to 5,000 items or less. To do this, take one of the following actions, as appropriate for your situation:
  • Create a new view for the list or library or change the existing view. When you do this, use indexed columns and filtering to keep the view size for the list to 5,000 items or less. For more information about how to create a filtered view that has a column index, go to the following Microsoft website: 
    Manage large lists and libraries in Office 365

    Note The list limit to add or remove an indexed column is 20,000 items.
  • Create folders in the library, and put items in the folders to keep the view for the library to 5,000 items or less.

MORE INFORMATION

This issue occurs when your list or library exceeds the list view threshold limit of 5,000 items for a view.

For more information, go to the following Microsoft website:

Still need help? Go to Microsoft Community.
Свойства

Номер статьи: 3095371 — последний просмотр: 21 дек. 2016 г. — редакция: 1

Отзывы и предложения