SharePoint Online: Get List Experience Settings using PowerShell

Requirement: Get List Experience Settings in SharePoint Online using PowerShell. How to Get SharePoint Online List Experience? Do you ever need to know the list experience settings applied in a SharePoint Online site? Maybe you’re troubleshooting an issue and had to confirm that the setting is configured as expected. Or, perhaps you’re…

Read more

How to Assign a User to SharePoint Online Administrator Role in Office 365?

Requirement: Set SharePoint Online Administrator. As the SharePoint Online administration is done by people other than Tenant Admin (or Global Administrator!) in most companies, You may need to delegate Office 365 roles so that users get administrative privileges to specific services like SharePoint without being full tenant admins. Global administrators in Office…

Read more

SharePoint Online: Copy List Items between Site Collections using PowerShell

Requirement: Copy List Items between Site Collections in SharePoint Online using PowerShell. PowerShell to Copy List Items between SharePoint Online Site Collections When you need to copy list items between site collections in SharePoint Online, PowerShell can be a quick and easy way. This blog post will show you how to use…

Read more

SharePoint Online: Copy Values from One Column to Another using PowerShell

Requirement: Copy values from one column to another column in a SharePoint Online list. PowerShell to Copy List Column Value in SharePoint Online To copy values between columns in the same list, use this PnP PowerShell script: For field types like single lines of text or choice, this script works fine. However,…

Read more

SharePoint Online: Change Column Order in List using PowerShell

Requirement:  Change Column Ordering in SharePoint Online List. How to Change the Column Order in SharePoint Online? When you create a SharePoint Online list, the columns are automatically added in the order they were created. In some cases, you may need to change the column order. Maybe you’ve added a new column…

Read more

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 of duplicate content in SharePoint. People may have uploaded the same document to various libraries or even different folders in document libraries. Duplicate files can take up valuable storage space and can…

Read more

How to Get the Tenant ID in SharePoint Online / Microsoft 365?

Requirement: Get Tenant ID from SharePoint Online / Microsoft 365. 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 (globally unique identifier) that links all services in your Office 365 environment. Sometimes,…

Read more