'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Microsoft Lists Not Showing All Filter or Group Options
Question details
The user needs to make newly added values in a Microsoft Lists status column appear in the Group By or Filter dropdown menus.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Filtering and organizing list items based on newly added status column values in Microsoft Lists or SharePoint.
- Observed behavior
- New values added to a status column do not appear in the Group By or Filter menus, even though the list items actively contain those new values.
Ensure you have the necessary Site Owner or Designer permissions, as you will need access to the Advanced Settings menu to perform a list reindexing operation.
Manually Reindex the Microsoft List
Triggering a manual reindex forces the system to crawl the list and recognize newly added column values so they appear in your filter options.
When new options are added to a column, the search index may not immediately register them. Reindexing the list ensures that all data, including newly added status values, is updated during the next crawl schedule.
Open your SharePoint site and go to the specific list or library that is missing the filter options.
Click on the 'List' tab located in the top ribbon, and then choose 'List Settings' from the menu.
On the Settings page, look under the 'General Settings' section and click on 'Advanced settings'.
Scroll down the page until you find the 'Reindex List' button. Click it to confirm. The list content will be fully reindexed during the next scheduled crawl.
Contact Microsoft 365 Administrator
If reindexing does not resolve the issue or if it affects newly created lists, backend investigation by an administrator is required.
Discover WPS Office for Seamless Document Management
While Microsoft Lists handles complex team tracking, for everyday spreadsheet data filtering, document creation, and presentation management, WPS Office provides a free, lightweight, and highly compatible alternative. Enjoy an intuitive interface that makes managing tabular data and documents effortless.
Frequently Asked Questions
Why are my new Microsoft Lists column values not appearing in the filter menu?
This typically happens because the backend search index has not yet updated to include the newly added values. Reindexing the list forces the system to crawl the data and recognize these updates.
How long does it take for a reindexed list to show the new filter options?
The timeframe depends on your organization's SharePoint crawl schedule. Changes usually take effect within a few minutes to a few hours after the next scheduled continuous crawl completes.
Can I reindex a list without administrator permissions?
No, you generally need Site Owner, Designer, or Full Control permissions to access the Advanced Settings menu and trigger a list reindex.
