SharePoint
Feedback by UserVoice

Piet de Boer

My feedback

  1. 1,267 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

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

      Piet de Boer supported this idea  · 
      Piet de Boer commented  · 

      The most urgent problem i currently have:
      i can't remove a (lookup)column in a list with more than 20,000 (or so) items, so i'm stuck.
      My list have 15 lookup-columns and i want to delete some of them

    • 300 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        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…

        Piet de Boer supported this idea  · 
        Piet de Boer commented  · 

        It's good to hear indexes can be altered in large lists from now on.
        The most urgent problem i currently have:
        i can't remove a (lookup)column in a list with more than 20,000 (or so) items, so i'm stuck.
        My list have 15 lookup-columns and i want to delete some of them.

      Feedback and Knowledge Base