SharePoint Online: How to Create a New List from Existing List?

Requirement: Create a list from an existing list in SharePoint Online. SharePoint Online: Create a List from an Existing List Creating a list as same as the existing list structure is a common requirement in SharePoint. We used the "Site list as Template" approach in previous versio…

SharePoint Online: Remove a Custom Theme using PowerShell

Requirement: Remove a custom theme in SharePoint Online. Remove a Theme in SharePoint Online Using PowerShell: We can remove a custom theme from SharePoint Online tenant using Remove-SPOTheme cmdlet Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking $TenantAdminURL …

SharePoint Online: CAML Query with IsNull and IsNotNull Examples in PowerShell

Requirement: Get all items from a list where a particular filed value is Null. SharePoint Online: CAML Query IsNull Example Here is the example of how IsNull operator can be used in CAML: #Parameters $SiteURL = "https://crescent.sharepoint.com/sites/marketing/" $ListName= "Doc…

How to Add Owner to Office 365 Group using PowerShell?

Requirement: Add Owner to Office 365 group using PowerShell How to Set Group Owners in Office 365? To add members to Office 365 group through Microsoft 365 admin center, follow these steps: Login to the Microsoft 365 Admin Center site: https://admin.microsoft.com Expand Groups and Click on …

Find All Office 365 Group Owners using PowerShell

Requirement: Get Office 365 Group Owners How to Get Office 365 Group Owners? To get Office 365 group owners from Microsoft 365 admin center, Login to the Microsoft 365 Admin Center site: https://admin.microsoft.com Expand Groups and Click on Groups link in the left navigation.  The groups…

Fix "Connect-AzureAD : The term 'Connect-AzureAD' is not recognized as the name of a cmdlet, function, script file, or operable program." Error

Problem: When trying to connect to Azure AD from PowerShell, using: "Connect-AzureAD" cmdlet, received an error: "Connect-AzureAD: The term 'Connect-AzureAD' is not recognized as the name of a cmdlet, function, script file, or operable program." Solution: Instal…

SharePoint Online: Get Files and Sub-Folders Count on Each Folder in a Document Library using PowerShell

Requirement:  Get the count of files and sub-folders at each folder in a SharePoint Online document library. How to Get the Number of Files and Sub-Folders at Each Folder of a Document Library? When a document library has multiple folders, sub-folder and files, you can get the number of files …

SharePoint Online: How to Add External User using PowerShell?

Requirement: Add External User to SharePoint Online using PowerShell. How to Add an External User in SharePoint Online? SharePoint Online provides an excellent solution when you have to share any site, list, library, or document with users outside your organization such as vendors, clients, o…

SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell

Requirement: Change Classic Experience to Modern Experience and Modern UI to Classic in SharePoint Online. How to Activate Modern Experience from Classic? The modern experience in SharePoint Online lists and libraries is faster, mobile friendly and easier to use.  It brings new functionalities…

SharePoint Online: Error Handling with Try Catch in PowerShell

One of the best practices while writing PowerShell scripting is handling potential errors to ensure smooth execution of the script when something goes wrong. Who can guarantee a script can run correctly in different environments every time? Error handling in PowerShell is made easy with try-…

SharePoint Online: How to Disable "Delete this list"?

Requirement: Disable delete on a SharePoint Online List or Document Library. How to Disable Delete options for List or Document Library in SharePoint Online? We have a requirement to disable any accidental deletes on certain SharePoint Online lists and document libraries that are provisioned…

SharePoint Online: Get Attachments Report in a List using PowerShell

Requirement: Generate a Report to get an Inventory of all Attachments in a SharePoint Online List. PowerShell to Get All Attachments in a SharePoint Online List This PowerShell extracts data from all attachments, such as Number of Attachments, Size, Filename, URL, etc. to a CSV file. Import-…

SharePoint Online: How to Remove the Title Column from List?

Requirement: Remove Title column from SharePoint Online List SharePoint Online: How to Remove Title Field from List? When you create a new list, it comes with "Title" column by default. You can rename the title column to something relevant to your list. E.g. I've created a "Me…

SharePoint Online: How to Set Item-Level Permissions in a List?

Requirement: Set Item Level Permission in SharePoint Online List. What is Item-level Permission in the SharePoint Online List? When you want to restrict all items in a list either with read or edit access to only those who created that item, You can utilize Item-level permission settings in Sh…

SharePoint Online: Create Multiple Subsites from a CSV File using PowerShell

Requirement: Create Multiple sub-sites in SharePoint Online using PowerShell. SharePoint Online: How to Create Multiple Subsites using PowerShell? Creating a subsite in SharePoint Online with PowerShell is explained in my other article:  How to Create a Subsite using PowerShell in SharePoint O…

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? To get list experience configuration of a list or library in SharePoint Online, Navigate to the list or library settings >> Click on the "Advanced Setting…

How to Assign 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 of the companies, You may need to delegate roles in Office 365, so that users get administrative privileges to specific services …

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 Just set parameters accordingly and run the script. Make sure your target list is already created with the same structure (eit…

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

Requirement: Copy values from one column to another column in 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: #Parameters $SiteURL = "https://crescent.sharepoint.com/sites/p…

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? To change the order of columns in a SharePoint Online list or library, do the following: Navigate to the list or library where you want to reorder the columns. Click on Sett…