SharePoint Online: PowerShell to Get Site Columns

Requirement: Get Site Columns in SharePoint Online using PowerShell SharePoint Online: How to Get Site Columns? Site columns or metadata fields you create at any list or library stays within that list or library. Say, you create a choice column “Department” in a list with a number of choices. If you need…

Read more

SharePoint Online: Set Site Column Properties using PowerShell

Requirement: Update Properties of a Site Column in SharePoint Online using PowerShell How to edit a Site Column in SharePoint Online? You can edit site column properties such as name, group, column type, etc in SharePoint Online by following the below steps: Navigate to the SharePoint Online site where the site column…

Read more

SharePoint Online: Add Site Column to List using PowerShell

Requirement: Add an existing site column to SharePoint list or library using PowerShell. How to Add a Site Column to SharePoint Online List? Site columns in SharePoint provide a great re-usability without having to recreate the same columns multiple times! Once created at the top-level site, we can utilize them to store…

Read more

SharePoint Online: Find Site Column Usage in Lists and Libraries using PowerShell

Requirement: Find a Site Column usage in SharePoint Online Site Collection SharePoint Online: PowerShell to Get a Site Column’s usage in lists and libraries of a Site Collection: This script gets a particular site column’s usage in lists and libraries and prints the finding as below:

Read more

SharePoint Online: Export-Import Site Columns using PowerShell

Requirement: Export-Import Site Columns in SharePoint Online. SharePoint Online: Export Site Columns using PowerShell This PowerShell script exports all site columns of a specific group for the SharePoint Online site to an XML file. Once executed, this PowerShell script exports all site columns from the given site column group to a XML…

Read more

SharePoint Online: Find Site Column Usage in Content Types using PowerShell

Requirement: Find Site Column Usage in Content Type in SharePoint Online site collection. Little background: When trying to delete a site column in SharePoint Online, Got a error message: “site columns which are included in content types cannot be deleted. Remove all references to this site column prior to deleting it”. So,…

Read more

SharePoint Online: Create Site Column using PowerShell

Site columns in SharePoint Online Site columns provide great re-usability in SharePoint without having to recreate fields every time you need them in lists and libraries. They save a lot of time especially when you have to standardize columns, create columns with data (such as choice fields) or assign default values to…

Read more

SharePoint Online: Delete a Site Column using PowerShell

Requirement: Delete Site Column in SharePoint online using PowerShell How to delete a site column in SharePoint Online? To remove a SharePoint online site column, follow these steps: Go to Site Settings by clicking Site settings gear and then “Site settings” from the menu. Click on the “Site Columns” link from the…

Read more

SharePoint Online: Rename a Column in List using PowerShell

When we create a new list or library in SharePoint/SharePoint Online, “Title” column gets created automatically. SharePoint doesn’t allow us to delete this title column. However, we can change the “title” column name to something relevant such as “Project Name” in “Projects” List. How to Rename a List Column in SharePoint Online?…

Read more