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…

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 t…

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 hyperlink and setting the column type to "Number" renders the column markup as HTML. E.g. I've used this formula to lin…

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? …

SharePoint Online: Get OneDrive for Business URL of a User using PowerShell

Requirement: PowerShell to Get OneDrive URL in SharePoint Online. How to Get OneDrive URL of a User? My Sites in SharePoint On-premises bacame OneDrive for Business in SharePoint Online. Typically, OneDrive sites are located at the URL: https:// tenant -my.sharepoint.com/personal/ upn   (E.g. …

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. #Load SharePoint CSOM Assemblies Add-T…

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 in my SharePoint Onlin…

Co-Authoring Documents in Microsoft Teams

Co-Authoring is available in Microsoft Teams on documents stored, to enable multiple people to work on the same document at the same time. Documents stored in your teams are accessible to every member of the Team. Team members can collaboratively co-author documents. How to Co-Author a Document…

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 a…

SharePoint Online: Resize Column Width in List Forms using CSS

Requirement:  Change width of all columns in list edit form! How to modify column width in SharePoint Online? If you want to set width of a specific field in list form, find its title or ID using Developer tools and use this script in Script editor: <script> $(document).ready(function…

SharePoint Online: Apply Column Format using PowerShell

Requirement: Format Column in SharePoint Online using PowerShell How to Apply Conditional Formatting in SharePoint Online Column using PowerShell? Formatting columns in SharePoint Online is explained in my other post: Format Column in SharePoint Online , Here is the PowerShell CSOM script to s…

Get All SharePoint Online Groups with "Full Control" Permissions using PowerShell

Requirement: Get all groups with "Full Control" permissions in SharePoint Online sites. Get All Groups with "Full Control" from a Site Collection Let's get all groups with full control permissions from a given site collections. #Set Parameters $AdminCenterURL="ht…

How to Create Calendar Overlay in SharePoint Online?

What is Calendar Overlay in SharePoint Online? Calendar overlay is a cool feature in SharePoint that lets you to layer the contents of multiple calendars into a single easy-to-read, color-coded calendar view. Use it when you are managing more than one calendar in your SharePoint environment but …

SharePoint Online: Grant Permission to User on All Items in a List using PowerShell

Requirement: Grant Permission to a User on All Items in a SharePoint Online List PowerShell to Grant Permissions to a User on All Items in a List in SharePoint Online #Load SharePoint Online Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions…

How to Add SharePoint Online Document Library to "Quick Access" in File Explorer?

Requirement: Create a Quick Access Link to SharePoint in Windows Explorer. How to Add SharePoint Document Library to File Explorer? Being able to access SharePoint document libraries from windows explorer helps us to save a lot of time, especially when you want to save or open files quickly! …

How to Remove a User from Office 365 Group using PowerShell?

Requirement: Remove user from office 365 group using PowerShell How to Remove a User from Office 365 Group? As an admin, you can remove members from any Office 365 group through Microsoft 365 admin center. Here is how: Login to the Microsoft 365 Admin Center site: https://admin.microsoft.com…

SharePoint Online: Remove User from All Groups in a Site using PowerShell

Requirement: Remove user from all groups in a SharePoint Online Site Collection SharePoint Online: PowerShell to Remove User from All Groups This PowerShell script gets all groups of the given user and removes it from the group. #Set Parameters $AdminCenterURL="https://crescent-admin.s…

SharePoint Online: Remove User Permission from All List Items using PowerShell

Requirement: Remove user from all items in a list. SharePoint Online: Remove User Permissions from All Items using PowerShell There are multiple items with unique permissions in a SharePoint Online list where a specific user is granted access. There is a requirement to remove the particular …

SharePoint Online: Grant Permission to All Files in a Folder using PowerShell

Requirement: Grant Permission to All Files in a Folder in SharePoint Online PowerShell to Set Permission to each File in a Folder: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.d…

SharePoint Online: Update Permission Level using PowerShell

Requirement: Update Permission Level in SharePoint Online SharePoint Online: How to Edit a Permission Level? We have had a permission level "Contribute without delete" which allows users to add/edit items but not delete. Now, we got a new requirement to exclude edit also from the pe…