SharePoint
Feedback by UserVoice

Steven Derveaux

My feedback

  1. 1,332 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    152 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…

    Steven Derveaux commented  · 

    Okay, trying to make sense out of it? Is the limit in general increased to 20.000? So, an "All Items" view will work on 20.000 items?

    Steven Derveaux commented  · 

    "Boom! It's Done", my first thought was: "Yes! the limit is removed or at least multiplied by 5" but after reading more I came to the conclusion that nothing has changed in the end.

    "Boom! It is just a joke". Hmm, I'm not laughing...

    Steven Derveaux commented  · 

    And another customer bites to dust...

    Keep in mind that the search box in document libraries (in the modern experience) is also struggling with this limit. Working with folders can overrule the 5000 items, but the new-autocompleted-search cannot cross this limit. MS Support pointed us to use the Search Center or create our own webparts. Meanless to say: you cannot replace this autocompletion search webpart because you cannot customize the modern view! Aargh!

    So what can you do? switch back to Classic Design but then you loose the new copy functionality!

    I have no words for this...

    Steven Derveaux supported this idea  · 
  2. 315 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    20 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…

    Steven Derveaux supported this idea  · 
  3. 11 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
  4. 8 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
  5. 9 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
  6. 38 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
  7. 22 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
  8. 13 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
  9. 13 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
  10. 10 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →

Feedback and Knowledge Base