Sharepoints threshold exceeded

%3CLINGO-SUB%20id%3D%22lingo-sub-1634809%22%20slang%3D%22en-US%22%3ESharepoints%20threshold%20exceeded%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634809%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20error%20below%20from%20Sharepoints%20could%20anyone%20advice%20me%20on%20what%20to%20do%3F%20Thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22100%25%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3Ehe%20number%20of%20items%20in%20this%20list%20exceeds%20the%20list%20view%20threshold%2C%20which%20is%205000%20items.%20Tasks%20that%20cause%20excessive%20server%20load%20(such%20as%20those%20involving%20all%20list%20items)%20are%20currently%20prohibited.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CA%3ELearn%20about%20managing%20a%20large%20list%20or%20library%20and%20ensuring%20that%20items%20display%20quickly.%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CSPAN%3E25204%20items%20(list%20view%20threshold%20is%205000).%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1634809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1634870%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoints%20threshold%20exceeded%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1634870%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782006%22%20target%3D%22_blank%22%3E%40SastroChang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20this%20wording%20refers%20specifically%20to%20a%20View%2C%20and%20not%20the%20entirety%20of%20the%20list.%26nbsp%3B%20The%20default%20%22All%20Items%22%20view%20doesn't%20have%20any%20filters%20in%20it%2C%20so%20it'll%20keep%20presenting%20list%20items%20till%20it%20breaches%20the%205k%20limit.%26nbsp%3B%20%26nbsp%3BSpecific%20advice%20will%20depend%20on%20your%20needs%20for%20the%20list.%26nbsp%3B%20Can%20you%20tell%20us%20a%20little%20more%20about%20the%20function%20of%20the%20list.%26nbsp%3B%20Otherwise%2C%20some%20suggestions%20might%20be%3A%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EAdd%20a%20date%20filter%20to%20the%20default%20view.%26nbsp%3B%20I%20tend%20to%20add%20a%2090%20day%20filter%20to%20my%20default%20view%20using%20the%20%22Created%22%20column%20so%20that%20older%20items%20aren't%20returned%3C%2FLI%3E%3CLI%3EManually%20delete%20older%20items%20that%20aren't%20needed%3C%2FLI%3E%3CLI%3ESet-up%20a%20scheduled%20flow%20to%20archive%20older%20items%20to%20an%20archive%20list%20%2F%20spreadsheet%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20expect%20the%20community%20will%20come%20in%20with%20some%20other%20ideas%20and%20their%20own%20experiences.%26nbsp%3B%20Do%20please%20let%20is%20know%20what%20the%20list%20is%20for%20and%20perhaps%20we%20can%20provide%20guidance%20that's%20a%20bit%20more%20specific.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello All,

 

I got error below from Sharepoints could anyone advice me on what to do? Thanks

 

he 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.
Learn about managing a large list or library and ensuring that items display quickly.

25204 items (list view threshold is 5000).

1 Reply
Highlighted

@SastroChang 

So this wording refers specifically to a View, and not the entirety of the list.  The default "All Items" view doesn't have any filters in it, so it'll keep presenting list items till it breaches the 5k limit.   Specific advice will depend on your needs for the list.  Can you tell us a little more about the function of the list.  Otherwise, some suggestions might be: -

 

  • Add a date filter to the default view.  I tend to add a 90 day filter to my default view using the "Created" column so that older items aren't returned
  • Manually delete older items that aren't needed
  • Set-up a scheduled flow to archive older items to an archive list / spreadsheet

I expect the community will come in with some other ideas and their own experiences.  Do please let is know what the list is for and perhaps we can provide guidance that's a bit more specific.