# My SharePoint list view does not show all items

> For the full documentation index, see https://250highstreet.com/llms.txt

> Items missing from a SharePoint list view? Check the view filter, the item limit, folders, the 5,000 threshold and which view is open, one at a time.

A view filter or the view's item limit may be hiding the row. Open the view, check the Filter and Item Limit settings, and switch to another view such as "All Items" to confirm the row exists. If the list holds more than 5,000 items, Microsoft says to "use indexed columns and filtering to keep the view size for the list to 5,000 items or less."

A view is a saved set of rules, and each rule can hide rows. After the filter and item limit, check the folder setting, the 5,000 item threshold, the sort or group, and which view is the default. Change one thing at a time.

## First, prove the item exists

Before you change any setting, find out if the row is really gone. Do these steps:

1.  Open the list in your browser at [https://www.microsoft365.com](https://www.microsoft365.com) and go to the list, or use the link your team already uses.
2.  Look at the name of the view at the top right of the list. Exact names may differ in your version.
3.  Switch to another view, such as "All Items". Microsoft says: "To see other views, select the View options menu on the upper right-hand side of the command bar."
4.  If the row shows up in another view, the first view is hiding it. Keep reading.
5.  If it shows up nowhere, ask the person who added it for the exact title. It may have been deleted; see "[Restore a deleted SharePoint list item or list](/guides/restore-deleted-sharepoint-list-item/)". The steps below cover the view only.

## Check 1. The view filter

A filter hides every row that does not match it. Microsoft says: "With a filter on, the list shows only the list items you want to view under the conditionals you set." So a view named "Open items" is built to hide closed rows. That is not a bug.

How to look at the filter:

1.  Open the view that is missing the row.
2.  Look for a filter icon or a filter panel on the right. If you see one, Microsoft says: "To remove all filters at once, select Clear filters on the right." Use this only to test. Do not clear a filter on a view that other people rely on.
3.  If the row now appears, the filter was hiding it. Open the view settings and read each rule.

Mistakes to look for in the rules:

- The filter value does not match the choice text. If your Choice column has numbered choices such as 1 Active, 2 On hold and 3 Done, the filter value is "1 Active", not "Active".
- The filter uses And when you meant Or. With two rules joined by And, a row must match both.
- The filter is on a column that was edited. A row that changed from "1 Active" to "3 Done" leaves a view that shows only "1 Active". This is how a view works.
- A column is blank for that row. A rule like "Owner is equal to a name" hides rows with no owner.

\[Today\] and \[Me\] filters. Microsoft says: "There are two keywords that you can use to filter based on the current day \[Today\], or the current user \[Me\]." It also says: "You must use the classic view editor to filter columns using these keywords." To get there, open the view, choose Edit current view, then open the Filters section. Exact names may differ.

Our advice, not a Microsoft rule: set blank and "is not equal to" filters in the classic view editor too.

For a "my items" view, see "[Show each person only their own items in a SharePoint list view](/guides/sharepoint-list-view-filter-current-user/)".

Which column types can you filter? Microsoft's filtering page has a table of "Supported and unsupported columns for indexing and filtering". Multiple lines of text, Choice (multi-valued), calculated, Hyperlink or Picture, and Person or Group (multi-valued) are on the unsupported side. On a list near or over 5,000 items, a filter on one of those can fail. A different design may be needed, such as a single-value Choice column.

## Check 2. The item limit

A view can be set to show only some of the rows. Microsoft's view page says: "You can specify how many items are displayed at the same time (batches) in each view." Microsoft's filtering page describes two choices: "Display items in batches of the specified size" and "Limit the total number of items returned to the specified amount". It adds: "When you create a view, the default number of items to be displayed is 30."

These two choices behave differently:

- Batches: the list shows the first group of rows and gives you a way to see the next group.
- Limit the total: the view stops at that number. Rows after that number are not shown in this view.

How to check:

1.  Open the view, choose Edit current view, then open the Item Limit section. Exact names may differ.
2.  Read the number and read which choice is selected.
3.  If the view must show every row that matches its filter, choose batches and set a size that suits you.

Microsoft's view page also says: "The maximum number of items in a view is 5000." Keep that in mind when you set a number.

## Check 3. The folder setting

If your list has folders, a view can show the folders with the items or show all items with no folders. Microsoft says: "Select Show items in folders to display the list or library folders in the view with the items." It also says: "Select Show all items without folders to display only the list or library items in the view."

What this means for a missing row: with "Show items in folders", a row inside a folder is not on the top level of the list. You have to open the folder to see it. With "Show all items without folders", rows from every folder appear in one flat list.

How to check:

1.  Open the view, choose Edit current view, then open the Folders section. Exact names may differ.
2.  See which option is selected.
3.  If you want every row in one place, choose "Show all items without folders".

A caution from Microsoft's threshold page: "you should be careful not to have a query on the folder return more than the List View Threshold." The next check explains the threshold.

## Check 4. The 5,000 item threshold

Microsoft calls it the list view threshold. It says the threshold "Specifies the maximum number of list or library items that a database operation, such as a query, can process at one time." It also says: "When a list view shows more than 5,000 items, you might run into a list view threshold error."

When this happens you may see an error message instead of a short list. Microsoft's troubleshooting page for sort and filter shows this 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." Its fix: "reduce the number of items in the view for the affected list or library to 5,000 items or less." It names two ways: use indexed columns and filtering in a new or changed view, or create folders and put items in them.

Microsoft also says you "might be warned on the List Settings page when your list has exceeded 3,000 items."

Microsoft's fix page adds a limit on the indexed-column route: "The list limit to add or remove an indexed column is 20,000 items." Our advice, not a Microsoft rule: add the index on the filter column before the list reaches that size.

The threshold is about one view, not about how many rows a list can hold. For the full plan, see "[SharePoint list over 5,000 items: what breaks and the fix](/guides/sharepoint-list-view-threshold/)". That guide covers the full fix.

## Calendar views

A calendar view is a view format, not a filter. Microsoft describes it as "a format similar to a wall calendar" and says the list "must contain columns with start dates and end dates for the calendar items." If a row has no start or end date, it has nothing to place on the calendar.

Microsoft also says you cannot change a view's format after you create it, so a calendar needs its own view. Open the calendar view's settings and read its filter and item limit the same way as in Check 1 and Check 2, because they apply to a calendar view too.

## Check 5. The sort and the group

Sorting and grouping do not remove rows, but they can make a row hard to find. A row sorted to the bottom of a long list is easy to miss. A grouped view may show groups collapsed, so rows inside a group look absent. Open each group before you decide a row is missing.

Microsoft also says sorting can trigger the threshold error: "Columns with column types like people, lookup, or managed metadata can cause list view threshold errors when sorting."

## Check 6. Which view is the default

People see the default view when they open the list. Microsoft says: "All lists and libraries have a default view, which is the view that people see when they go to the list or library." If your team sees different rows from you, you may be in different views. A personal view is yours alone. Microsoft says: "A personal view is a view that only you can see." So a coworker can have a personal view with its own filter that you never see.

How to compare:

1.  Ask your coworker for the exact name of the view they have open.
2.  Open that same view in your own browser.
3.  If it is a personal view, ask them to read out the filter rules.

## A one-page checklist

1.  Switch to the "All Items" view. Does the row appear?
2.  Read the filter rules on the view that hides it.
3.  Check the choice text, including number prefixes such as "1 Active".
4.  Check the item limit and whether it is batches or a total.
5.  Check the folder setting.
6.  Count the rows. If it is close to 3,000 or above 5,000, read the threshold guide.
7.  Open grouped sections.
8.  Compare your view with your coworker's view.

## What to avoid

- Do not edit the filter on a shared view to test an idea. Make a copy first with Save view as. Test on the copy.
- Do not delete rows to "make room". The view limit is not a storage limit.
- Do not make a new list for each problem. Fix the view first.
- Our advice, not a Microsoft rule: instead of one giant view for everyone, build a few named views, for example "Open", "Done this month" and "Mine".

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

### Why does my SharePoint list view not show all items?

A view hides rows by design. The filter, the item limit, the folder setting, the 5,000 item threshold and which view is open can each hide a row. Check them one at a time in that order.

### Why does my SharePoint list view show only 30 items?

Microsoft's filtering page says: "When you create a view, the default number of items to be displayed is 30." Open the view's Item Limit setting to change the number, and choose batches if you want to page through the rest. Microsoft says "The maximum number of items in a view is 5000."

### Why is my SharePoint calendar view not showing items?

A calendar view needs columns with start dates and end dates, and a row with no dates has nothing to show. The view's own filter and item limit can also hide rows, so check both.

### Is the item missing for everyone or only for me?

Ask a coworker to open the same view. If they see the row and you do not, check whether one of you is in a personal view. Microsoft says: "A personal view is a view that only you can see."

### Does a list with more than 5,000 items stop showing items?

Microsoft says: "When a list view shows more than 5,000 items, you might run into a list view threshold error." The threshold limits one view or query, not the list itself. Use a filtered view built on indexed columns.

## Sources

- [Microsoft Support, Create, change, or delete a view of a list or library](https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/create-change-or-delete-a-view-of-a-list-or-library)
- [Microsoft Support, Use filtering to modify a SharePoint view](https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4)
- [Microsoft Support, List View Threshold for large lists and libraries (Manage large lists and libraries in SharePoint)](https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59)
- [Microsoft Support, Working with the List View Threshold limit for all versions of SharePoint](https://support.microsoft.com/en-au/sharepoint/data-and-lists/working-with-the-list-view-threshold-limit-for-all-versions-of-sharepoint)
- [Microsoft Learn, Can't sort or filter a column in SharePoint Online](https://learn.microsoft.com/en-us/troubleshoot/sharepoint/lists-and-libraries/fails-filtering-sharepoint-column)

## Related guides

- [SharePoint list filter not showing all values: what to check](/guides/sharepoint-list-filter-not-showing-all-values/)
- [SharePoint list over 5,000 items: what breaks and the fix](/guides/sharepoint-list-view-threshold/)
- [Show each person only their own items in a SharePoint list view](/guides/sharepoint-list-view-filter-current-user/)
- [Delete all items in a SharePoint list without clicking one by one](/guides/sharepoint-list-delete-all-items/)

Source: https://250highstreet.com/guides/sharepoint-list-view-not-showing-all-items/