SharePoint
Feedback by UserVoice

Elena

My feedback

  1. 1,219 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

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

      Elena commented  · 

      Dear Microsoft Guys, can you also put in your backlog handling of lookup fields that are looking up to large lists? Am I the only person who actually sees it as a problem that will never be resolved otherwise? If the lookup fields are here to stay, you MUST address this issue. Modern interface or not, lookup fields that are linked to large lists, still give ERROR "This is a lookup column that displays data from another list that currently exceeds the List View Threshold defined by the administrator (5000)". No matter how much effort we put into indexing the list and making the views work, those fields are real showstopper for us. We need a new lookup field that works regardless number of items in a lookup list. Maybe it could allow either filtering or searching, or be displaying items in batches.
      We can’t move many of our clients to the modern interface because we have to use a third-party control that addresses this issue, but unfortunately only works in a classic SP.

      Elena commented  · 

      It does look like the modern interface solves some of the issues caused by the 5000 list view threshold, however the issue with the lookup fields have not been solved, which is a huge show stopper for serious SP applications. See this: https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/13002084-lookup-on-lists-over-5-000

      Elena supported this idea  · 
    • 2 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

        0 comments  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
        Elena shared this idea  · 
      • 292 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…

          Elena commented  · 

          It would be good to know what improvement exactly are in the pipeline. Is handling of lookup fields will be improived too? https://sharepoint.uservoice.com/forums/330321-sharepoint-search/suggestions/13002084-lookup-on-lists-over-5-000

        • 58 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

            7 comments  ·  Sites and Collaboration » Lists  ·  Flag idea as inappropriate…  ·  Admin →
            Elena supported this idea  · 
          • 7 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

              1 comment  ·  Suggestion Archive  ·  Flag idea as inappropriate…  ·  Admin →
              Elena shared this idea  · 
            • 9 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

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

              Feedback and Knowledge Base