Sharepoint Document Library- Metadata

%3CLINGO-SUB%20id%3D%22lingo-sub-54064%22%20slang%3D%22en-US%22%3ESharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54064%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWe%20have%20a%20document%20library%20in%20which%20the%20requirement%20is%20to%20add%2020%2B%20custom%20columns%20(Meta%20data).%26nbsp%3B%3C%2FP%3E%3CP%3EAdding%20custom%20columns%20(Meta%20data)%20to%20document%20libary%20helps%20to%20search%20the%20documents%20easily%20by%20providing%20required%20criteria.%3C%2FP%3E%3CP%3EIs%20it%20good%20to%20add%20so%20many%20additional%20columns%20to%20a%20document%20library%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20if%20any%20other%20best%20approaches%20are%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-61334%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-61334%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20affraid%20it%20are%20to%20many%20columns%20and%20if%20there%20is%20lots%20of%20data%20this%20can%20become%20a%20issue%20in%20delay%20and%20Search%20my%20advice%20would%20be%20to%20look%20at%20the%20columns%20and%20bring%20them%20down%20to%20max%2020%20but%20less%20would%20even%20be%20better%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-61001%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-61001%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20reply.%3C%2FP%3E%3CP%3EI%20have%20created%2030%2B%20columns%20%26nbsp%3Bin%20a%20content%20type%20and%20used%20that%20content%20type%20as%20base%20for%20all%20the%20document%20libraries%20(20%2B)%20%26nbsp%3Bin%20my%20site%20collection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20the%20document%20library%20type%2C%20I%20have%20hidden%20few%20columns%20for%20the%20users%20to%20avoid%20unnecessary%20inputs%20by%20%26nbsp%3Busing%20IProvisioningExtensibilityHandler%20in%26nbsp%3BOfficeDevPnP.Core.Framework.Provisioning.Extensibility%20namespace.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all%20for%20your%20suggestions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54354%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54354%22%20slang%3D%22en-US%22%3E%3CP%3EAgree%20with%20some%20of%20the%20fellow%20posters%2C%20I%20try%20to%20steer%20clients%20towards%203-5%20columns%20worth%20of%20metadata%20at%20most.%203%20tends%20to%20be%20the%20most%20common%2C%205%20is%20more%20for%20strict%20publishing%20site%20or%20application%20that%20was%20built%20on%20top%20of%20SharePoint.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54307%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54307%22%20slang%3D%22en-US%22%3EDo%20you%20need%20all%20columns%20for%20all%20types%3F%20I%20tend%20to%20use%20different%20content%20types%20with%20different%20columns%20for%20each%20to%20reduce%20number%20of%20fields.%20You%20can%20also%20use%20lookup%20columns%20so%20you%20have%20one%20select%20but%20show%20more%20info.%20As%20Paul%20mentioned%2C%20definitely%20check%20the%20limits%20and%20limitations.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54298%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54298%22%20slang%3D%22en-US%22%3EYou%20should%20carefully%20consider%20if%20all%20meta%20data%20is%20really%20needed.%20If%20so%2C%20you%20should%20strive%20to%20make%20the%20end%20users'%20life%20as%20easy%20as%20possible.%20SharePoint%20provides%20only%20a%20few%20ways%20here%20that%20could%20help%20you%20out.%20Column%20default%20values%20specified%20at%20the%20folder%20level%20for%20example%20where%20the%20library%20folder%20you%20put%20a%20document%20in%20determines%20the%20default%20values%20to%20be%20used.%3CBR%20%2F%3E%3CBR%20%2F%3EA%20custom%20add-in%20could%20also%20help%20in%20providing%20a%20better%20data%20entry%20experience...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54292%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54292%22%20slang%3D%22en-US%22%3E%3CP%3EPaul%2C%3C%2FP%3E%3CP%3EEach%20column%20is%20specifies%20a%20piece%20of%20metadata%20not%20the%20managed%20meta%20data.%20Agree%20the%20user%20has%20to%20input%20more%20data%20while%20uploading%20the%20document.%3C%2FP%3E%3CP%3EDo%20we%20have%20any%20other%20alternate%20approaches%20for%20this%20requirement%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54201%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54201%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20types%20of%20columns%20used%20make%20a%20huge%20difference%20as%20described%20in%20the%20article.%2020%20columns%20of%20type%20%22Single%20line%20of%20text%22%20has%20way%20less%20impact%20compared%20to%20using%2020%20columns%20of%20type%20%22Managed%20Metadata%22.%26nbsp%3BIt%20wasn't%20clear%20to%20me%20from%20the%20original%20question%20what%20types%20of%20columns%20where%20to%20be%20used...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F37647%22%20target%3D%22_blank%22%3E%40Venkata%20Ratnam%20Vemula%3C%2FA%3E%3A%20by%20%22Columns%20(metadata)%22%20do%20you%20refer%20to%20the%20fact%20each%20colum%20specifies%20a%20piece%20of%20metadata%20or%20do%20you%20refer%20to%20Columns%20of%20type%20%22Managed%20Metadata%22%20here%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54178%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54178%22%20slang%3D%22en-US%22%3EAgree%20with%20Luis%2C%20the%20more%20metadata%20you%20add%20to%20a%20list%20or%20a%20document%20library%2C%20the%20more%20probability%20you%20will%20have%20of%20experiencing%20performance%20problems%20when%20working%20with%20the%20list%20or%20document%20library%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54072%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54072%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20think%20that's%20gonna%20work%20if%20you%20later%20want%20to%20show%2Fquery%20all%20the%20fields%20(like%20in%20a%20List%20View).%20From%20my%20experience%2C%20once%20I%20tried%20to%20add%20like%2014%20metadata%20columns%20to%20the%20Pages%20library.%20I%20was%20able%20to%20add%20them%2C%20but%20then%20I%20got%20errors%20when%20trying%20to%20show%20and%20item%20with%20all%20the%20columns%20(don't%20remember%20exactly%20the%20case%2C%20but%20didn't%20work).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMetadata%20columns%20are%20threated%20like%20%22lookup%22%20columns%2C%20and%20there's%20a%20limit%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262787.aspx%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%23Column%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262787.aspx%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%23Column%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EList%20view%20lookup%20threshold%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E12%20join%20operations%20per%20query%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3ESpecifies%20the%20maximum%20number%20of%20joins%20allowed%20per%20query%2C%20such%20as%20those%20based%20on%20lookup%2C%20person%2Fgroup%2C%20or%20workflow%20status%20columns.%20If%20the%20query%20uses%20more%20than%20eight%20joins%2C%20the%20operation%20is%20blocked.%20This%20does%20not%20apply%20to%20single%20item%20operations.%20When%20using%20the%20maximal%20view%20via%20the%20object%20model%20(by%20not%20specifying%20any%20view%20fields)%2C%20SharePoint%20will%20return%20up%20to%20the%20first%2012%20lookups.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3ENote%3A%20After%20applying%20the%20SharePoint%20Server%202013%20cumulative%20update%20package%20released%20on%20August%2013%2C%202013%20(%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F2817616%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%230066cc%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F2817616%3C%2FFONT%3E%3C%2FA%3E)%2C%20the%20default%20value%20is%20increased%20from%208%20to%2012.%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-54069%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Document%20Library-%20Metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54069%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20are%20limitations%20around%20the%20use%20of%20columns.%20These%20are%20described%20in%20this%20article%20(written%20for%20SharePoint%202013%20but%20still%20applicable%20as%20far%20as%20I%20know)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262787.aspx%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%23Column%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262787.aspx%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%23Column%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20think%20you%20will%20run%20into%20the%20technical%20limits%20described%20in%20the%20article%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20potential%20downside%20of%20this%20many%20columns%20is%20they%20ultimately%20have%20to%20be%20filled%20with%20data.%20If%20some%20person%20is%20required%20to%20fill%20in%20all%20those%20columns%20manually%20the%20experience%20might%20not%20be%20that%20good.%20If%20an%20automated%20proces%20is%20used%20to%20fill%20in%20the%20columns%20this%20is%20less%20of%20a%20concern.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

We have a document library in which the requirement is to add 20+ custom columns (Meta data). 

Adding custom columns (Meta data) to document libary helps to search the documents easily by providing required criteria.

Is it good to add so many additional columns to a document library?

 

Please advise if any other best approaches are there.

10 Replies

There are limitations around the use of columns. These are described in this article (written for SharePoint 2013 but still applicable as far as I know)

https://technet.microsoft.com/en-us/library/cc262787.aspx?f=255&MSPPError=-2147217396#Column

 

I don't think you will run into the technical limits described in the article above.

 

A potential downside of this many columns is they ultimately have to be filled with data. If some person is required to fill in all those columns manually the experience might not be that good. If an automated proces is used to fill in the columns this is less of a concern. 

 

 

I don't think that's gonna work if you later want to show/query all the fields (like in a List View). From my experience, once I tried to add like 14 metadata columns to the Pages library. I was able to add them, but then I got errors when trying to show and item with all the columns (don't remember exactly the case, but didn't work).

 

Metadata columns are threated like "lookup" columns, and there's a limit here:

https://technet.microsoft.com/en-us/library/cc262787.aspx?f=255&MSPPError=-2147217396#Column

 

List view lookup threshold

12 join operations per query

Specifies the maximum number of joins allowed per query, such as those based on lookup, person/group, or workflow status columns. If the query uses more than eight joins, the operation is blocked. This does not apply to single item operations. When using the maximal view via the object model (by not specifying any view fields), SharePoint will return up to the first 12 lookups.

Note: After applying the SharePoint Server 2013 cumulative update package released on August 13, 2013 (https://support.microsoft.com/en-us/kb/2817616), the default value is increased from 8 to 12.

Agree with Luis, the more metadata you add to a list or a document library, the more probability you will have of experiencing performance problems when working with the list or document library

The types of columns used make a huge difference as described in the article. 20 columns of type "Single line of text" has way less impact compared to using 20 columns of type "Managed Metadata". It wasn't clear to me from the original question what types of columns where to be used...

 

@Venkata Ratnam Vemula: by "Columns (metadata)" do you refer to the fact each colum specifies a piece of metadata or do you refer to Columns of type "Managed Metadata" here?

Paul,

Each column is specifies a piece of metadata not the managed meta data. Agree the user has to input more data while uploading the document.

Do we have any other alternate approaches for this requirement?

You should carefully consider if all meta data is really needed. If so, you should strive to make the end users' life as easy as possible. SharePoint provides only a few ways here that could help you out. Column default values specified at the folder level for example where the library folder you put a document in determines the default values to be used.

A custom add-in could also help in providing a better data entry experience...
Do you need all columns for all types? I tend to use different content types with different columns for each to reduce number of fields. You can also use lookup columns so you have one select but show more info. As Paul mentioned, definitely check the limits and limitations.

Agree with some of the fellow posters, I try to steer clients towards 3-5 columns worth of metadata at most. 3 tends to be the most common, 5 is more for strict publishing site or application that was built on top of SharePoint.

Thanks for the reply.

I have created 30+ columns  in a content type and used that content type as base for all the document libraries (20+)  in my site collection.

 

Based on the document library type, I have hidden few columns for the users to avoid unnecessary inputs by  using IProvisioningExtensibilityHandler in OfficeDevPnP.Core.Framework.Provisioning.Extensibility namespace.

 

 

Thank you all for your suggestions.

I am affraid it are to many columns and if there is lots of data this can become a issue in delay and Search my advice would be to look at the columns and bring them down to max 20 but less would even be better