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 a same document to different libraries or even different folders in document libraries. So, How to find duplicate documents in SharePoint Online? SharePoint…

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 the services in your Office 365 environment. At times, you may need to…

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 CSOM using PowerShell How to Connect to SharePoint Online using CSOM using PowerShell? Although SharePoint Online Management Shell provides a number of PowerShell Cmdlets to manage SharePoint Online, it is quite limiting and the only way to do real SharePoint PowerShell is using the SharePoint CSOM….

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? Say for e.g. You may want to know if it is a team site in SharePoint Online. To check the site template of your site, do the following: Open your SharePoint Online site collection…

Read more