How to Export a List Template in SharePoint Online using PowerShell?

Requirement: Export List Templates in SharePoint Online using PowerShell List templates in SharePoint Online enables you to reuse any list with its fields, formulas, formatting, and optionally data in other site collections without re-creating the list again. List Templates should be downloaded and uploaded to another sites in order to create lists…

Read more

How to Import List Template in SharePoint Online using PowerShell?

Requirement: Import List Templates in SharePoint Online using PowerShell Why we need list templates in SharePoint Online? Well, If you have a list with set of columns and customization in SharePoint Online, You can reuse it in any other site collections without re-creating the list again from the scratch. A list template…

Read more

SharePoint Online: Format Calculated Column as Hyperlink

Requirement: Format Calculated Column markup as Hyperlink. How to Format Calculated Column as Link using HTML Markup? Using calculated column formulas to frame hyperlinks and setting the column type to “Number” renders the column markup as HTML. E.g. I’ve used this formula to link project documents with the Projects list. Well, not…

Read more

SharePoint Online: Connect Existing Team Sites to New Office 365 Group

Requirement:  A SharePoint Online team site (Classic / Modern Experience) users wants to  transform their existing site to Office 365 group to take advantage of Office 365 Group offerings such as Shared mailbox, Planner, Teams, etc. How to Connect to New Office 365 Group in SharePoint Online? When you create a new…

Read more

SharePoint Online: Grant Permission to Each Folder in a Document Library using PowerShell

Requirement: Grant permission to all sub-folders in a SharePoint Online document library SharePoint Online: Grant Permission to Folders using PowerShell Here is the PowerShell to add a user to each folder in SharePoint Online list or document library. This script recursively loops through each sub-folder in the given list or library and…

Read more

SharePoint Online: How to Implement Cascading Drop-down in 3 Steps?

Requirement: Cascading drop-down list in SharePoint Online. How to Implement Cascading Lookup in SharePoint Online List Forms? Before implementing cascading drop down in SharePoint Online lists, we need lists with data for lookup. In my case, I’ve three custom lists on my SharePoint Online site. Namely: Region, Country, and Project Tasks. I…

Read more

SharePoint Online: How to Add a Custom Property to Advanced Search Properties Drop-Down?

Requirement: Add new property to advanced search drop-down in SharePoint Online. SharePoint Online: How to Add a Property to Advanced Search Drop Down? To perform search queries based on a specific column value in SharePoint, we can use “Advanced Search”. By default, you can search against any managed property such as “Author:Some…

Read more