0

My SharePoint List View exceed threshold (5000), but I'm still able to see all the items. Even after I added a filter, and sort conditions.

I have tried adding a filter and sort conditions. I am expecting to see an error message :"The number of items in this list exceeds the list view threshold, which is 5000 items", instead I saw all the items which were 8800.

Rania Abdalla
  • 1
  • 1

2 Answers2

1

You can store up to 30 million items or files in a list or library. However, when a list view shows more than 5000 items, you may run into a list view threshold error.

Reference: Manage large lists and libraries

Emily Du - MSFT
  • 491
  • 3
  • 6
  • My list view shows more than 5000 items, and I didn't run into a list view threshold error. I'm still I'm able to see the whole 8800 items. – Rania Abdalla Jan 17 '23 at 01:03
0

On most occasions, you won't run into such issues. But when your records start exceeding 50,000 or more, there are high chances that you will experience this issue.

If you want to see the threshold issue, try creating a child list and adding a lookup column to the parent list with more than 5000 items. Also make sure that the Column you are using as lookup is not indexed in the Parent Column.

Ucheuzor
  • 31
  • 6