SharePoint Online: Add Calculated Column to List using PowerShell

Requirement: Add Calculated Column to SharePoint Online List How to Add Calculated column to SharePoint Online List? Calculated columns in SharePoint Online is used to manipulate other columns in the list item. Instead of entered by a user, these field values are automatically calculated based…

SharePoint Online: Add Managed Metadata Column to List using PowerShell

Requirement: Create a managed metadata column in SharePoint Online SharePoint Online: How to Add Managed Metadata Field to List or Library Managed Metadata in SharePoint uses Term set from term store as the source for its allowed values. Term set defines set of values. E.g. Department is a T…

SharePoint Online: Add Multiple Lines of Text Column to List using PowerShell

The Multiple Lines of Text column in SharePoint Online is used to store Multiple rows of Text value. Based on the field settings, it can contain Rich text, including text, images, HTML formatted values, etc. How to Add Multiple Lines of Text Field to List in SharePoint Online? Browse to your…

SharePoint Online: Create Date and Time Column in List using PowerShell

How to Add Date and Time Column to SharePoint Online List? The Date and Time column in SharePoint Online captures date and optional time values. Browse to your SharePoint Online site and then Navigate to the target list in which you want to create date and time column. Under the List tab, cl…

SharePoint Online: Create Site Column using PowerShell

Site columns in SharePoint Online Site columns provides 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) o…

Fix "Another site or list is still using this content type. If you would still like to delete it, please remove the content type from all sites and lists and then try again" in SharePoint

Problem: When trying to delete a content type from List or site, received below error in SharePoint online site " Another site or list is still using this content type. If you would still like to delete it, please remove the content type from all sites and lists and then try again. "…

Add Links to Resources List in SharePoint Central Administration

The Resources list in SharePoint Central Administration site lets you to keep frequently accessed links to the home page. Say for e.g. To access User profile service application, you'll have to navigate through: Central Administration >> Application Management  Manage Service Applica…

Get All Available Cmdlets in SharePoint Online Management Shell

Here is a nifty trick to find all available cmdlets in SharePoint online management shell. Open SharePoint Online Management Shell and Enter: Get-Command | ? { $_.ModuleName -eq "Microsoft.Online.SharePoint.PowerShell" } This lists down all cmdlets from SharePoint Online Manage…

SharePoint Online: Rename Folder using PowerShell

Requirement: Rename a Folder in SharePoint Online. How to Rename a Folder in SharePoint Online? To rename a folder in SharePoint Online document library, Open the document library in browser, Right-click on the folder you want to rename, and then click "Rename". In the Rename…

SharePoint Online: Delete Column from List using PowerShell

Requirement: SharePoint Online delete column from list How to remove a column from SharePoint Online List? We can delete Columns from lists or libraries when they are no longer needed. To delete a list column, follow these steps: Go to List >> Click on Settings Gear and choose "Li…

SharePoint Online: Create a Content Type using PowerShell

What is Content Type in SharePoint Online? Content types are set of columns grouped together to serve a specific purpose. Think about a Invoice template! Instead of you and your users end up creating different templates each time from the scratch, you can define an Invoice template once and your…

SharePoint Online: Export Term Store Data to CSV using PowerShell

Requirement: Export Term store data from SharePoint Online to a CSV file How to export term store in SharePoint Online: There is no out of box way to export complete term store data in SharePoint online. However, we can utilize PowerShell to export term store data including all term groups, t…

How to Create SharePoint 2016 Farm using PowerShell?

Creating SharePoint 2016 farm using PowerShell is almost as same as in its previous version. In SharePoint 2016 there is an additional parameter -LocalServerRole added as SharePoint 2016 introduced MinRoles. Pre-Requisites: SQL Server is already installed and ready to use. You have created …

SharePoint Online: Version History Report using PowerShell

Requirement: Generate version history report for all sites in a SharePoint site collection. SharePoint Online PowerShell to Get Version History Details of a Document Library Version history feature in SharePoint Online maintains a history of all changes that have been made to any file or li…