How To Add Column In Multiple Libraries In SharePoint 2013

SharePoint 2013 offers different approaches to adding columns to multiple libraries, allowing for increased efficiency and improved library functionality. In this article, we will explore two methods – using PowerShell and making changes directly in the SharePoint site. Whether you prefer automating the process or making manual adjustments, we have you covered!

If you choose to use PowerShell, we will guide you through the steps using the Add-PnPField command from the SharePoint PnP module. This powerful tool enables you to specify the necessary details of the column and easily apply it to multiple libraries. By leveraging PowerShell, you can save time and streamline the column addition process.

Alternatively, if you prefer a more hands-on approach, we will walk you through the process of making changes directly in the SharePoint site. By accessing the site settings and navigating to the desired content types, you can effortlessly add columns to multiple libraries. This method provides flexibility and control over the specific libraries and content types you wish to modify.

Remember, the instructions provided may require some customization based on your specific SharePoint environment and requirements. Keep in mind that updating column order within content types is also possible, allowing you to organize your libraries according to your preferences.

By following the methods detailed in this article, you will be equipped with the knowledge and tools to enhance your SharePoint libraries with additional columns. Whether you choose PowerShell or direct site changes, SharePoint 2013 empowers you to efficiently manage and optimize your library functionality.

Adding a Column using PowerShell

PowerShell can streamline the process of adding a column to multiple libraries in SharePoint 2013 by leveraging the Add-PnPField command from the SharePoint PnP module. With this powerful command, you can easily define the display name, internal name, type, and other properties of the column. Let’s walk through the steps to accomplish this.

  1. First, make sure you have the SharePoint PnP module installed. If you don’t have it already, you can install it by running the following command in PowerShell:
Install-Module SharePointPnPPowerShellOnline

Note: Depending on your specific SharePoint environment and requirements, you may need to make adjustments to the steps and commands provided.

  1. Next, open PowerShell and connect to your SharePoint site by running the following command:
Connect-PnPOnline -Url "<your site URL>"
  1. Once connected, you can use the Add-PnPField command to add a column to multiple libraries. Here’s an example of how to use the command:
Add-PnPField -DisplayName "<display name>" -InternalName "<internal name>" -Type "<column type>"

This command will add the specified column to all the document libraries in your SharePoint site. You can customize the display name, internal name, and type of the column as per your requirements.

Note: Make sure you have the necessary permissions to execute PowerShell commands in your SharePoint environment.

Example: Adding a “Department” Column

Let’s say you want to add a “Department” column to multiple libraries in SharePoint 2013. You can use the following command:

Add-PnPField -DisplayName "Department" -InternalName "Department" -Type "Choice" -Choices "HR","Finance","IT","Marketing"

This will add a column named “Department” with a choice type to all the document libraries in your SharePoint site. You can specify the desired choices based on your organization’s needs.

Column Name Internal Name Type Choices
Department Department Choice HR, Finance, IT, Marketing

By utilizing PowerShell and the Add-PnPField command, you can efficiently add columns to multiple libraries in SharePoint 2013. This method saves time and effort, especially when dealing with a large number of libraries or making frequent changes to your SharePoint environment.

Making Changes in the SharePoint Site

If you prefer a more hands-on approach, you can directly make changes in the SharePoint site to add a column to multiple libraries by adjusting the content types. By navigating to the site settings, you can access the site content types or the list/library content types where you want to add the column.

Once you have selected the specific content type, you can choose to add an existing site column. From the available options, select the column you want to add. If necessary, you can also update all content types that inherit from the selected content type.

If you want to change the column order for a content type, you can easily do so by accessing the content type settings. Within the settings, you can rearrange the columns according to your preferences.

Please keep in mind that the steps and commands provided are based on various sources and may require customization to fit your specific SharePoint environment and requirements.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.