SharePoint Online: Bulk Update Metadata Properties from a CSV File using PowerShell

Requirement: Bulk Update Metadata of Multiple Documents from a CSV in SharePoint Online. SharePoint Online: PowerShell to Bulk Edit Metadata Properties from a CSV File We’ve a document library with a 100s of documents in several sub-folders and wanted to bulk update metadata of all those documents. While quick edit is one…

Read more

SharePoint Online: Update List Items from a CSV File using PowerShell

Requirement: Update SharePoint Online List from a CSV using PowerShell. PowerShell to Update SharePoint Online List from CSV File We have a list called “Projects” with a bunch of columns and wanted to update items from a CSV file. Here is the PowerShell CSOM script to update the SharePoint Online list from…

Read more

SharePoint Online: Update Multiple Lines of Text Field Value using PowerShell

Requirement: Update Multiple lines of text field value in SharePoint Online using PowerShell. PowerShell to Set Multiline text field in SharePoint Online: I have a column called “Project Description” of “Plain text” type in the “Projects” list and here is the CSOM PowerShell script to update multiple lines of text field value…

Read more

SharePoint Online: Set Current User as Default Value in Person or Group Field

Requirement: Fill the Current user in person or group field (People Picker column) in SharePoint Online list New form. How to Set the Person or Group Field Default Value as Current User in SharePoint Online? I have a list to track travel requests and want to fill some people picker columns to…

Read more

SharePoint Online: How to Change Required Field Settings in a List or Library?

Requirement: Set required fields in SharePoint Online list or document library How to Set Required Fields in SharePoint Online? Required fields setting in SharePoint Online lists and libraries help to ensure that users enter certain information when saving items or uploading files. You can configure any field as a required field in…

Read more

SharePoint Online: Set Default Value for Multiple lines of text Field

Requirement: Set default value for multiple lines of text field in SharePoint Online. How to set the default value for a multi-line text field? The multiple lines of text field doesn’t support “default” value through the web user interface. However, here is the trick to set the default value for multiple lines…

Read more

SharePoint Online: How to Remove the Title Column from List?

Requirement: Remove Title column from SharePoint Online List SharePoint Online: How to Remove Title Field from List? When you create a new list, it comes with a “Title” column by default. You can rename the title column to something relevant to your list. E.g. I’ve created a “Metrics” list and I can…

Read more

SharePoint Online: Copy Values from One Column to Another using PowerShell

Requirement: Copy values from one column to another column in SharePoint Online list. PowerShell to Copy List Column Value in SharePoint Online To copy values between columns in the same list, use this PnP PowerShell script: For field types like single lines of text, choice this script works fine. However, for other…

Read more

SharePoint Online: Change Column Order in List using PowerShell

Requirement:  Change Column Ordering in SharePoint Online List. How to Change the Column Order in SharePoint Online? To change the order of columns in a SharePoint Online list or library, do the following: Navigate to the list or library where you want to reorder the columns. Click on Settings gear >> list…

Read more