SharePoint Online: Bulk Add Multiple Fields to List from a CSV using PowerShell

Requirement: Add multiple fields to a SharePoint Online list from a CSV file. PnP PowerShell to Create Multiple Columns in a List from a CSV File Have you ever had to create multiple columns in a SharePoint Online list? Well, PowerShell can be a great solution if you need to quickly add…

Read more

Get Internal Name of a Column in SharePoint Online using PowerShell

Requirement: Get the internal name of a SharePoint Online list column using PowerShell How to Get the Internal Field Name in SharePoint Online? As explained in my other post: SharePoint Field Display Name vs. Internal Name, When you create a new column in SharePoint, You give a “Title” to it, which becomes…

Read more

SharePoint Online: Show or Hide a Form Field based on Another Field’s Value using Conditional Formula

Requirement: Show or Hide a field based on another field’s value in SharePoint Online list form How to Show or Hide a Field based on Another Field in SharePoint Online? In the past, we used to achieve this using jQuery Show or Hide SharePoint List Form Fields based on Another Field’s Value…

Read more

SharePoint Online: Number Column without Comma

Requirement: Display number column without a comma in SharePoint Online list How to remove the comma from the number column in SharePoint Online? Comma separators don’t make sense on specific number column values like “Year”! So, we wanted to display a number without a comma in a SharePoint Online list. While the…

Read more

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 have a document library with 100s of documents in several sub-folders and wanted to bulk update the metadata of all those documents. In comparison, the quick…

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 Have you ever needed to update SharePoint Online list items from a CSV file? Perhaps you need to do some bulk editing of list data. In this guide, we’ll show you how to…

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