Forum Discussion

Venkata Ratnam Vemula's avatar
Venkata Ratnam Vemula
Brass Contributor
Mar 17, 2017

Sharepoint Document Library- Metadata

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 provi...
jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
Mar 17, 2017
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
paulpascha's avatar
paulpascha
Bronze Contributor
Mar 17, 2017

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?

  • Venkata Ratnam Vemula's avatar
    Venkata Ratnam Vemula
    Brass Contributor
    Mar 18, 2017

    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?

    • paulpascha's avatar
      paulpascha
      Bronze Contributor
      Mar 18, 2017
      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...
      • Venkata Ratnam Vemula's avatar
        Venkata Ratnam Vemula
        Brass Contributor
        Apr 10, 2017

        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.

Resources