I have a list with around 5500 items in it currently, it grows by around 1000 items per month.

I have folders enabled for this list, there are around 500 folders in total, each of those folders has unique permissions. Each folder will contain only a small number of items, no more than 26 per year per folder.

I have a view that shows all items without folders, grouped on a metadata field for each item. The average user only has permission to somewhere between 1-12 folders, however as soon as we breached the 5000 item limit for the whole list the view stopped showing any items with an ID greater than 5000. The users DO NOT get the list threshold error. The view shows up normallyswith a small number of items from the folder that user can see, but simply doesn't include the most recent items in that folder.

It seems like the security trimming does not count as a filter.

Has anyone run into this before? Any suggestions other than just "figure out a different filter value"? I don't have a good field to filter on unfortunately. I was relying on the folder permissions to be the filter.

I'm using entirely different views with appropriate filters for the users that need to see all the records in the list, it just doesn't apply to the average user of the list.

  • If you are applying filters in the list view, add indexing on the columns you used for filtering. Also, make sure the the filtered view returns less than 5000 items in each view (if you are using classic experience list view pages). Let me know if it works for you. Feb 21 at 9:39
  • That is not helpful at all, you didn't even read the question and just copy pasted the standard view information.
    – Aboba
    Feb 23 at 5:58


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.