SharePoint list limitations

Question

Hi all

I have a SharePoint list which has exceed the 5000 item limit. I understand this is a view limit and SharePoint will hold millions of entries.

I need to figure out how to create a second view as my 'All items' view feeds into an excel doc which I need for reporting. e.g. I need the 'All items' view always displaying all items.

When I try to create a new view I get an error message:

"This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator."

I was hoping within the view I could display items only if column A =123... Through the view settigns. Its not allowing me to do this. I've also tried to index columns but I get the same error.

Whats the way around this?

Thanks in advance

Simon

Source link from TechNet

Answer 1

Hi

If the second view you create still exceeds 5,000 items after filtering, obviously, such error messages will still appear.

I recommend that you still need to change your list structure and keep the items displayed in the view below 5000. In general, this is always the best practice to solve similar problems.

If your list is always too large (regardless of filtering by any means), I recommend saving these items into multiple different lists.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

i use power query with from Power bi and I can see all the rows.