none
Error: List View Threshold. The number of items in this list exceeds the list view threshold, which is 5000 items. RRS feed

  • Question

  • Hi, i had created a SharePoint List in cloud ( office 365) using List Template.

    List template contains 12000 items taken as template from SharePoint on Premise.

    I am getting this error message, in SharePoint Online (Office 365)

    The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.

    How to resolve it, to get data in my SharePoint list, any help will be appreciated.

    Monday, February 2, 2015 11:57 AM

Answers

  • Hello,

    We have control over list view threshold on premises of SharePoint but Not much sure about Office 365.

    I found below link might help you

    http://community.office365.com/en-us/f/148/t/79787.aspx

    And Microsoft support KB article

    https://support.microsoft.com/kb/2759051?wa=wsignin1.0

    Thanks


    Thanks.... ________________ Baba (MCTS, MCPD)

    • Marked as answer by Rebecca Tu Friday, February 13, 2015 6:17 AM
    Monday, February 2, 2015 12:12 PM
  • With O365 lists over 5k items are now officially supported but they will have limited behaviour due to the threshold. There are no workarounds or options to increase the threshold either temporarily, for specific users or for the list itself as you have with on-prem.

    You'll need to remove enough items to get it below the threshold limit, add indexed columns to support indexed views, then re-add the items again. This article is for 2010 but the section around indexed columns and views is still accurate: https://technet.microsoft.com/en-us/library/cc262813(v=office.14).aspx

    It may be possible to add the indexes on your on-prem list where you can increase/avoid the threshold, then re-export the list. That would rely upon the list creation script adding indexes before it uploads items but it's a logical assumption.

    • Marked as answer by Rebecca Tu Friday, February 13, 2015 6:17 AM
    Monday, February 2, 2015 12:12 PM

All replies

  • Hello,

    We have control over list view threshold on premises of SharePoint but Not much sure about Office 365.

    I found below link might help you

    http://community.office365.com/en-us/f/148/t/79787.aspx

    And Microsoft support KB article

    https://support.microsoft.com/kb/2759051?wa=wsignin1.0

    Thanks


    Thanks.... ________________ Baba (MCTS, MCPD)

    • Marked as answer by Rebecca Tu Friday, February 13, 2015 6:17 AM
    Monday, February 2, 2015 12:12 PM
  • With O365 lists over 5k items are now officially supported but they will have limited behaviour due to the threshold. There are no workarounds or options to increase the threshold either temporarily, for specific users or for the list itself as you have with on-prem.

    You'll need to remove enough items to get it below the threshold limit, add indexed columns to support indexed views, then re-add the items again. This article is for 2010 but the section around indexed columns and views is still accurate: https://technet.microsoft.com/en-us/library/cc262813(v=office.14).aspx

    It may be possible to add the indexes on your on-prem list where you can increase/avoid the threshold, then re-export the list. That would rely upon the list creation script adding indexes before it uploads items but it's a logical assumption.

    • Marked as answer by Rebecca Tu Friday, February 13, 2015 6:17 AM
    Monday, February 2, 2015 12:12 PM
  •             

    What does this mean? 

     

    With O365 lists over 5k items are now officially supported but they will have limited behaviour due to the threshold.

    What is supported and what is the limited behavior?

    Wednesday, February 4, 2015 9:19 PM
  • we can control list threshold in on premis ebut not in o365 try these link as reference:

    http://www.csgpro.com/post/110085

    https://support.microsoft.com/kb/2759051?wa=wsignin1.0

    http://www.markrackley.net/2014/10/22/working-around-that-pesky-list-view-threshold-in-office-365-sharepoint-2013/

    since this is 0365 related question move it to office365 forum for better answer.

    --------------------------------------------------------------------------------------------------------------------------------------

    Please mark answer as correct if it is correct else vote for it if you find it useful Happy SharePointing

    Thursday, February 5, 2015 6:38 AM