SharePoint Diary

SharePoint Online: Find All Files Exceeding Maximum URL Length Limitation using PowerShell

April 20, 2020 Admin Reports, File, PnP PowerShell, PowerShell, SharePoint Online

Microsoft Office Excel files stored in deep Folder, sub-folder structures with long names often result in an error when they exceed the maximum file URL length of 218 characters as in my other article SharePoint Online: URL Length Limitation of 218 Characters in Excel Files . So, we wanted to pr…

How to Promote a Site Page to News Post in SharePoint Online?

March 31, 2020 PnP PowerShell, PowerShell, SharePoint Online

Requirement: Convert Site Page into News post in SharePoint Online. How to Convert a Site Page into News Post in SharePoint Online? In modern SharePoint Online sites, any existing site page can be converted into the News page, so that it appears in News web parts. To promote a site page to Ne…

How to Convert SharePoint Online Site to Microsoft Teams?

February 08, 2020 Microsoft Teams, PowerShell, SharePoint Online

Requirement: Convert SharePoint Online Site to Microsoft Teams. Microsoft Teams is a chat-based collaboration platform that brings together people, conversations, content, and tools to create a more open, digital environment. Every time you create a new team in Teams, you're also creating a…

SharePoint Online: PowerShell to Get All User Profiles

January 26, 2020 Client Side Object Model (CSOM), PowerShell, SharePoint Admin Center, SharePoint Online, User Profile

Requirement: Get All User Profiles in SharePoint Online using PowerShell. How to Get User Profiles in SharePoint Online? User Profiles in SharePoint is a central location that stores information about users. It enables My Sites, social features and share profiles across multiple sites in the t…

SharePoint Online: Monitor External Sharing Invitations with Alerts

January 26, 2020 Alerts, External Sharing, OneDrive for Business, PowerShell, SharePoint Online

Requirement: Monitor SharePoint Online and OneDrive external sharing invitations. SharePoint Online: Configure External Sharing Alert When external sharing is enabled, users share files stored in SharePoint or OneDrive for Business site securely with team members, colleagues, external vend…

SharePoint Online: Activate a Feature on All Sites using PowerShell

January 16, 2020 Features, PnP PowerShell, PowerShell, SharePoint Online, Site Collection, Subsite, Tenant

Requirement: Enable a SharePoint Online feature for all sites using PowerShell. PowerShell to Activate a Site Collection Feature for All Sites We have a requirement to enable a SharePoint Online "Open Documents in Client Applications by Default" feature for all site collections…

SharePoint Online: Disable a Feature for All Sites using PowerShell

January 10, 2020 Features, PnP PowerShell, PowerShell, SharePoint Online, Site Collection, Subsite, Tenant

Requirement: Disable a feature for all SharePoint Online sites using PowerShell. PowerShell to Deactivate a Site Feature on All Collections in the Tenant We have a requirement to disable the SharePoint Online "Open Documents in Client Applications by Default" feature for all…

SharePoint Online: Bulk Delete Folders from a CSV using PowerShell

January 04, 2020 CSV, Folder, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Bulk Delete Folders in SharePoint Online. How to Bulk Delete Multiple Folders in SharePoint Online? To bulk delete folders with its sub-folders and files, we can use a CSV file with PowerShell script. #Set Parameters $SiteURL = "https://crescent.sharepoint.com/sites/Proj…

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

January 03, 2020 CSV, List, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Bulk create lists in SharePoint Online from a CSV File. How to Create Multiple lists from CSV File? We can use the combination of CSV and PowerShell to create multiple lists in bulk in SharePoint Online. Here is my CSV File: You can download this CSV here: SharePoint Online CSV Templ…

SharePoint Online: Bulk Delete Files from a CSV using PowerShell

January 02, 2020 Client Side Object Model (CSOM), CSV, Document Library, File, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Delete multiple files from SharePoint Online document libraries from a CSV using PowerShell. How to Delete Multiple Files in SharePoint Online Site from a CSV file? We have a CSV file with a list of URLs of various files in multiple document libraries in SharePoint Online. I wante…

Disclaimer