SharePoint
Feedback by UserVoice

Eric Alexander

My feedback

  1. 36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Sites and Collaboration » Document Libraries  ·  Flag idea as inappropriate…  ·  Admin →
    Eric Alexander supported this idea  · 
  2. 424 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    21 comments  ·  Sites and Collaboration » Lists  ·  Flag idea as inappropriate…  ·  Admin →

    Hi everyone, I’m happy to announce that the ability to add indexes to lists of any size is available to SharePoint Online customers as of March 2018. You can now go to “Indexed columns” in List or Library Settings page, and add indexes even if your list has more than 5,000 items. For up to 20,000 items, the indexing should be near instantaneous. For lists with more than 20,000 items, indexing will use a background process and may take some time, usually minutes, but possibly longer if there are a lot of items and if SharePoint is busy serving other requests. Similarly, you are also able to remove indexes that you no longer need.

    We are continuing to work on making larger lists work better, so we will keep this item open. Please don’t hesitate to send feedback if you are running into issues while managing your large lists, and…

    An error occurred while saving the comment
    Eric Alexander commented  · 

    TYVM Product Team!

    An error occurred while saving the comment
    Eric Alexander commented  · 

    Dustin, neither have I when I'm under 5000, but once you go over 5000 items, you cannot create new indexes, therefore you can't create new views.

    Many times now, we carefully plan architectures to store hundreds of thousands of files, many folders, none going over 5000 items. We thing we have everything accounted for, indexed columns the whole nine yards. Then something needs changed down the line, maybe it's a new column or a new index or permissions on a subfolder need changed to not inherit. If you are over the limit you just can't do a lot of these things.

    An error occurred while saving the comment
    Eric Alexander commented  · 

    Yes there are several out there, this one is more directed at increasing the priority of this issue as it pertains to their roadmap. It is a general we will get to it sometime in 2017, I'd like to see a specific quarter or date this is targetted for.

    Eric Alexander shared this idea  · 
  3. 426 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Sites and Collaboration » Document Libraries  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Eric Alexander commented  · 

    And more than 2 levels of Sort By too

  4. 2,197 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    228 comments  ·  Sites and Collaboration » Document Libraries  ·  Flag idea as inappropriate…  ·  Admin →

    We are continuing to make our large list experiences better, please keep the feedback coming.

    Spring 2018 update:
    - We now support being able to manually add indexes to lists of any size (increased from lists up to 20,000 items previously).
    - Starting with the February release of the Office 365 Excel client, you will be able to export your full list instead of getting cut off part of the way through.

    What we are working on now:
    - Predictive indexing will start to work for lists larger than 20,000 items so your views will automatically cause the right indexes to be added to your lists.

    In our backlog:
    - Being able to index/sort/filter by lookup column types (like person, lookup or managed metadata columns) without being throttled.
    - Making sure that our REST APIs support querying in ways that will guarantee that the call will not be throttled.

    For…

    An error occurred while saving the comment
    Eric Alexander commented  · 

    No matter how much you preplan for large lists, something always changes down the line and you become powerless to do anything about it. Users can keep adding, and adding, and adding, and you as an administrator have NO means to help them. Moving or deleting files to get under 5000 items causes a whole range of problems; it's clumsy, slow, difficult, time consuming, and can lead to 404s as people try to access content that has been moved. Increase the limit, give us a happy hour, or update TechNet to show the actual boundary of SharePoint Online to be 5,000 items, not 30 million.

    https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/16487710-prioritize-large-list-management-in-sharepoint-onl

  5. 35 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Sites and Collaboration » Sites Management  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Eric Alexander commented  · 

    It is a pain yes, but I'd rather let site owners manage their access that IT support requests

    Eric Alexander shared this idea  · 
  6. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
    Eric Alexander supported this idea  · 
  7. 73 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Eric Alexander supported this idea  · 

Feedback and Knowledge Base