Learn how to use PowerShell in SharePoint Online from our best PowerShell tutorials.
Yesterday, I was trying to create a Copilot agent for a marketing SharePoint site. The goal was to help employees quickly find files and documents. But there was a problem: Even though SharePoint permissions were in place, I wanted additional protection so that users without proper access would not see sensitive content at all. So … read more…
A manager asks who can open the SPGuides site, and the Site permissions panel shows three group names instead of people. Click into Members and you find a Microsoft 365 group, not a list of names. In this tutorial, we’ll build the get SharePoint site members PowerShell scripts our team runs before a permissions review. … read more…
When I build Power Apps solutions for clients, SharePoint lists are almost always part of the setup. And most of the time, these lists require many fields. Sometimes 30. Sometimes 40+. Manually creating them was a big waste of time. So I started using PnP PowerShell to automate this.One script -> Run it once -> … read more…
Our sales team sends a spreadsheet of new orders every week, and someone has to get those rows into a SharePoint list. Typing them into the browser form takes an afternoon and invites typos, so we script it. In this tutorial, we’ll add SharePoint Online list items using PnP PowerShell. We’ll build a real orders … read more…
Many scripts that find a SharePoint site owner still load the AzureAD module. That module is retired, and those scripts also miss the real owners of sites connected to a Microsoft 365 group. The better way is PnP PowerShell. Run Get-PnPTenantSite -Identity <site URL> -Detailed and read Owner. If the site has a GroupId, run … read more…
Every tenant I clean up for a client has the same leftovers: test sites from a pilot, a project site nobody opened in a year, and three copies of the same team site. Clicking through the admin center works for one site, but it’s slow, and it won’t permanently remove a group-connected site at all. … read more…
Our IT team tracks every laptop, monitor and headset in an Excel workbook, and they asked me to move it into a SharePoint list. Pasting rows into grid view works once, but not when the import repeats every month. In this tutorial, we’ll add items from an Excel to SharePoint list using PowerShell: read the … read more…
As an administrator, you might need to work with Microsoft Teams using PowerShell. In this tutorial, I will show you how to connect to Teams from PowerShell with some real examples. You can use the Microsoft Teams PowerShell module to manage teams directly from the PowerShell command line. But before that, you need to install … read more…
I am working on a Document Management System where my client asked me to enable sensitivity labels. By default, sensitivity labels work with supported file types like Word, Excel, and PowerPoint. However, they also wanted to apply labels to PDF files. In this article, I will explain how to enable sensitivity labels for PDFs using … read more…
Someone asks you about a SharePoint site: when it was created, how much storage it uses, whether guests can get in, or whether it’s locked. The admin center can answer each question, but it takes several clicks per site, and you can’t paste the result into a ticket or a spreadsheet. PowerShell gives you all … read more…
Before you install a cumulative update, open a support ticket or deploy a third-party solution, someone will ask which SharePoint build you’re on. Guessing from the look of the site doesn’t work, because SharePoint 2016, 2019 and Subscription Edition all report version 16.0. In this tutorial, we’ll walk through the check SharePoint version PowerShell commands … read more…
Most SharePoint admin work comes down to a few dozen cmdlets. The catch is that they live in two different modules, and older guides mix in SharePoint Server commands that never worked in Microsoft 365. In this tutorial, we’ll go through the SharePoint PowerShell commands I use most, grouped by task. Use PnP PowerShell for … read more…
You paste a SharePoint script into PowerShell and it stops on line one with a red error about Connect-PnPOnline. The cmdlet worked yesterday, or on a colleague’s laptop, so the script itself usually isn’t the problem. In this tutorial, we’ll fix Connect-PnPOnline is not recognized step by step. We reproduced every cause, so each fix … read more…
