Learn how to use PowerShell in SharePoint Online from our best PowerShell tutorials.
A project lead asked me to clean up the SPGuides Projects library: last year’s archive folder, an old projects tree, and a pile of empty upload folders. Clicking through them in the browser is slow, and one wrong click takes the wrong folder with it. A script is faster and repeatable, but deleting folders blindly … read more…
To create a folder in SharePoint Online with PowerShell, connect with PnP PowerShell and run Add-PnPFolder with the new folder’s name and the library’s URL name. It takes one line, and it scales to hundreds of folders without a single click. In this tutorial, I’ll walk you through the create folder sharepoint powershell steps I … read more…
Three new client projects landed on our PMO desk in one week, and each one wanted the same SharePoint site: a Project Tasks list with owners, due dates and status, plus a Project Documents library with a document type and review date. Building that by hand three times is an afternoon gone. A PnP site … read more…
To export Microsoft Teams chat history with PowerShell, connect to Microsoft Graph with the Chat.Read permission, get the messages with Get-MgChatMessage, turn the HTML bodies into text and save them with Export-Csv: The raw messages need some cleanup before they’re readable. Below I cover finding the chat, skipping system events, converting HTML to text, fixing … read more…
On 10/09/2026 I created a new app in Microsoft Entra ID for PnP PowerShell, ran Connect-PnPOnline -Interactive with its client ID. Instead of a working sign-in, the PnP login window said AADSTS500113: No reply address is registered for the application. The cause is simple: the app had no redirect URI, so Entra ID had nowhere … read more…
On 10/09/2026 I ran Connect-PnPOnline -Interactive with a freshly registered Entra ID app, signed in, and the Please login for PnP PowerShell window answered with AADSTS650057: Invalid resource. The client has requested access to a resource which is not listed in the requested permissions in the client’s application registration. The message looks scary, but its … read more…
Every time I need to set up a new SharePoint site, list, or library, I don’t want to click through the UI ten times just to add a few columns. I want a script I can run once, change a couple of values, and be done in under a minute. That’s exactly what this post … read more…
A finance manager once asked me to hand over a full copy of a document library before a site was archived. It had about 9,000 files in nested folders. The browser’s Download button zipped for a while, then failed, and the partial zip was missing whole folders. That’s when PowerShell earns its keep. Below are … read more…
Last month a finance director asked me a simple question: who can open the Finance folder, and which subfolders have their own permissions? The Manage access panel answers that for one folder at a time, and the site permissions page doesn’t show folders at all. In this tutorial, we’ll get SharePoint folder permissions using PowerShell … read more…
You need a SharePoint list with thousands of rows for a migration, a load test or a delegation demo. Adding them one at a time takes close to an hour. In this tutorial, we’ll show you how to add more than 5000 items to SharePoint list using PnP PowerShell batching, straight from a CSV file. … read more…
Our project team asked for the same document library on every new client site: a clean URL, version history, a few metadata columns and the same folder tree. Building that by hand takes ten minutes per site, and somebody always misspells a folder. A short PnP PowerShell script does it in seconds and builds it … read more…
Need to empty a SharePoint list but keep its columns, views and connected apps? Run Remove-PnPListItem with only -List, and PnP PowerShell deletes every item in it. In this tutorial, we’ll delete all items from SharePoint list using PnP PowerShell, first in one line and then with batches, CAML filters and the recycle bin. Every … read more…
A few weeks ago, while working with a client on a SharePoint Online storage cleanup project, I got a very simple-sounding request: “Bijay, can you tell us which document libraries are eating up all our storage?” Sounds easy, right? But when you have 40+ SharePoint sites and hundreds of document libraries, clicking through each site one … read more…
To get the site template in SharePoint using PowerShell, run Get-PnPTenantSite -Identity <site URL> and read its Template property. You’ll get an ID like GROUP#0, STS#3 or SITEPAGEPUBLISHING#0, which tells you exactly what kind of site you’re looking at. That ID matters when you audit a tenant, script new sites or figure out why one … read more…
