SharePoint Diary

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

May 30, 2019 List, SharePoint Online

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

May 30, 2019 Branding, PnP PowerShell, PowerShell, SharePoint Online, Theme

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

May 30, 2019 CAML, Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online

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…

Add Owner to Office 365 Group using PowerShell

May 28, 2019 Office 365 Group, 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

May 28, 2019 Office 365 Group, 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

May 28, 2019 Errors, Known Issues, PowerShell

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

May 25, 2019 Admin Reports, CSV, Document Library, File, Folder, PnP PowerShell, SharePoint Online

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?

May 20, 2019 External Sharing, External User, PnP PowerShell, PowerShell, Security, SharePoint Online, Users

Requirement: Add External User to SharePoint Online using PowerShell. How to Add 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, or p…

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

May 19, 2019 Client Side Object Model (CSOM), PowerShell, SharePoint Online

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

May 13, 2019 Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online

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

May 08, 2019 Client Side Object Model (CSOM), Document Library, List, List Settings, PnP PowerShell, PowerShell, SharePoint Online

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

May 08, 2019 Attachment, Client Side Object Model (CSOM), CSV, PnP PowerShell, PowerShell, SharePoint Online

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 Set Item-Level Permissions in a List?

May 07, 2019 Document Library, List, List Settings, Permission, PnP PowerShell, PowerShell, SharePoint Online

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

May 06, 2019 CSV, PnP PowerShell, PowerShell, SharePoint Online, Subsite

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

May 06, 2019 Client Side Object Model (CSOM), CSV, List Settings, PnP PowerShell, PowerShell, SharePoint Online

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?

May 06, 2019 Office 365, Permission, PowerShell, SharePoint Admin Center, SharePoint Online

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 such as SharePoint, without being full tenant admin…

SharePoint Online: Copy List Items between Site Collections using PowerShell

May 05, 2019 List, PnP PowerShell, PowerShell, SharePoint Online

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. #Function to copy attachments between list items Function Copy-SPOAttachm…

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

May 04, 2019 Column, List, PnP PowerShell, PowerShell, SharePoint Online

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

May 01, 2019 Column, Document Library, List, List Settings, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Change Column Ordering in SharePoint Online List. How to Change 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 Setting…

Disclaimer