SharePoint Online: Fix Lookup Field using PowerShell

Problem: SharePoint Online lookup column in a list is broken when the parent lookup list is recreated! Root Cause: SharePoint Online list lookup columns are connected with its parent lookup list column through the “List” (GUID of the parent list) and “ShowField” attributes. When the parent lookup list is re-created, its GUID…

Read more

SharePoint Online: Find Duplicate Files using PowerShell

Requirement: Find Duplicate Documents in SharePoint Online. When multiple people from different teams work together, there is a huge possibility for duplicate content in SharePoint. People may have uploaded the same document to various libraries or even different folders in document libraries. So, How do you find duplicate documents in SharePoint Online?…

Read more

How to Get the Tenant ID in SharePoint Online?

Requirement: Get Tenant ID from SharePoint Online. What is my SharePoint Online Tenant ID? When you subscribe to Office 365, You’ll be assigned a unique identifier as your Tenant ID. This Tenant ID is a GUID that links all services in your Office 365 environment. At times, you may need to know…

Read more

SharePoint Online: Find All Communication Sites using PowerShell

Requirement: Get All Communication Sites in SharePoint Online Tenant How to Find All Communication Site Collections in SharePoint Online? Communication sites are used to broadcast a message, such as news, reports, etc., to your organization in a visually compelling way. E.g., Intranet site. If you want to get a list of communication…

Read more

SharePoint Online: Grant Access to All Lists and Libraries with Unique Permission using PowerShell

Requirement: Grant Access to All Lists and Libraries with Unique Permission in SharePoint Online. How to Set Permissions on All Lists and Libraries with Broken Inheritance? We have a SharePoint Online site with a bunch of lists and document libraries uniquely permission-ed. How do we quickly find unique permission lists and add users or…

Read more

How to Connect to SharePoint Online using CSOM PowerShell?

Requirement: Connect to SharePoint Online using PowerShell CSOM How to Connect to SharePoint Online using CSOM using PowerShell? Although SharePoint Online Management Shell provides several PowerShell Cmdlets to manage SharePoint Online, it is pretty limiting. The only way to do real SharePoint PowerShell is to use the SharePoint CSOM. The Client Side…

Read more

How to Find the Site Template in SharePoint Online using PowerShell?

Requirement: Find Site Template in SharePoint Online using PowerShell. How to Find the Site Template in SharePoint Online? You may have an existing site and want to know the site template used in creating the site in SharePoint Online. In this article, I’ll show you how to find the site template in…

Read more