Home

SharePoint Online list view threshold question

%3CLINGO-SUB%20id%3D%22lingo-sub-5927%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20list%20view%20threshold%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5927%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Ecurrently%20I%20faced%20a%20problem%20that%20one%20of%20document%20library%20with%20a%20lot%20of%20content(20%2C000%2B)%20exceed%20the%20view%20threshold%20and%20as%20a%20result%20I%20can%20not%20export%20the%20list%20as%20a%20template(even%20not%20check%20the%20include%20data%20option)%2C%20it%20will%20give%20me%20the%20error%20message%20refer%20the%20list%20exceeds%20the%20list%20view%20Threshold.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ENow%20I%20need%20to%20know%3A%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E1.%20whether%20I%20can%20set%20the%20Threshold%20to%20a%20greater%20value%20by%20myself%20like%20on%20premise%20does.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2.%20How%20can%20I%20export%20the%20document%20library%20as%20a%20template.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EPlease%20help.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F1960i1504FE9F6D9CBC73%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.PNG%22%20title%3D%221.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20941px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F1959i1D124354C5173F85%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222.PNG%22%20title%3D%222.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-5927%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%20Administration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-6187%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20SharePoint%20Online%20list%20view%20threshold%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6187%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3BYes%2C%20I%20phrased%20it%20a%20bit%20awkward%2C%20but%20that%20was%20my%20intent.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-6152%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20SharePoint%20Online%20list%20view%20threshold%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6152%22%20slang%3D%22en-US%22%3EWhat%20you%20can%20do%20is%3A%3CBR%20%2F%3E(1)%20Use%20a%20third%20party%20tool%20to%20be%20able%20to%20export%20your%20list%20and%20list%20contents%20to%20another%20location.%3CBR%20%2F%3E(2)%20Use%20open%20source%20tools%20such%20as%20the%20PnP%20Provisioning%20Engine%20to%20export%20your%20list%20structure%20and%20import%20in%20another%20location%20%2B%20write%20some%20code%20to%20move%20the%20information%20from%20your%20source%20document%20library%20to%20the%20destination%20one.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2227%22%20target%3D%22_blank%22%3E%40Mike%20Platvoet%3C%2FA%3E%20I%20think%20you%20mean%20to%20re-organize%20views%20in%20the%20document%20library....a%20document%20library%20can%20store%20millions%20of%20documents%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-6048%22%20slang%3D%22en-US%22%3ERE%3A%20SharePoint%20Online%20list%20view%20threshold%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6048%22%20slang%3D%22en-US%22%3EHi%20Justin%2C%20if%20you%20want%20to%20move%20the%20content%20you%20can%20only%20export%20the%20files%20by%20explorer%20view%20and%20Import%20the%20files%20in%20a%20new%20library%20by%20explorer%20view.%20If%20you%20have%20a%20lot%20of%20META-data%20at%20these%20files%20you%20dont%20have%20any%20limitations.%20But%20if%20you%20have%20these%20META-data%20only%20on%20the%20fileobject%20in%20the%20document%20library%20you%20will%20loose%20that%20all.%20Secondly%20the%20template%20function%20including%20files%20have%20a%20file%20size%20limitation.%20You%20can%20get%20this%20Information%20%40%20Google%20or%20BING%20searchstring%20%22doc%20lib%20template%20limitations%22.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5948%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20list%20view%20threshold%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5948%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20far%20as%20I%20know%2C%20there%20is%20no%20way%20to%20work%20around%20it%20other%20than%20to%20bring%20down%20the%20number%20of%20items%20per%20view.%20In%20other%20words%2C%20you%20should%20reorganize%20your%20library%2Flist%20in%20such%20a%20way%20that%20there%20are%20less%20than%205000%20items%20in%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETake%20a%20look%20at%20this%20article%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FManage-large-lists-and-libraries-in-Office-365-b4038448-ec0e-49b7-b853-679d3d8fb784%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FManage-large-lists-and-libraries-in-Office-365-b4038448-ec0e-49b7-b853-679d3d8fb784%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20basically%20can%20do%20is%20reorganize%20your%20library.%20A%20nice%20post%20with%20some%20options%20to%20do%20so%20can%20be%20found%20here%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fsharepointmaven.com%2Fhow-to-overcome-sharepoint-5000-item-limit-threshold%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fsharepointmaven.com%2Fhow-to-overcome-sharepoint-5000-item-limit-threshold%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Justin Liu
MVP

Hi
currently I faced a problem that one of document library with a lot of content(20,000+) exceed the view threshold and as a result I can not export the list as a template(even not check the include data option), it will give me the error message refer the list exceeds the list view Threshold.
Now I need to know:
1. whether I can set the Threshold to a greater value by myself like on premise does.
2. How can I export the document library as a template.
Please help.

 1.PNG2.PNG

4 Replies
Highlighted

As far as I know, there is no way to work around it other than to bring down the number of items per view. In other words, you should reorganize your library/list in such a way that there are less than 5000 items in it.

 

Take a look at this article: https://support.office.com/en-us/article/Manage-large-lists-and-libraries-in-Office-365-b4038448-ec0...

 

What you basically can do is reorganize your library. A nice post with some options to do so can be found here;

http://sharepointmaven.com/how-to-overcome-sharepoint-5000-item-limit-threshold/

 

Highlighted
Hi Justin, if you want to move the content you can only export the files by explorer view and Import the files in a new library by explorer view. If you have a lot of META-data at these files you dont have any limitations. But if you have these META-data only on the fileobject in the document library you will loose that all. Secondly the template function including files have a file size limitation. You can get this Information @ Google or BING searchstring "doc lib template limitations".
Highlighted
What you can do is:
(1) Use a third party tool to be able to export your list and list contents to another location.
(2) Use open source tools such as the PnP Provisioning Engine to export your list structure and import in another location + write some code to move the information from your source document library to the destination one.

@Mike Platvoet I think you mean to re-organize views in the document library....a document library can store millions of documents
Highlighted

@Juan Carlos González Martín Yes, I phrased it a bit awkward, but that was my intent. Thanks!