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…
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…
A few days earlier, my manager asked me to send a report about who had permission (including external users) to access the files stored in the SharePoint library. This library has multiple levels of subfolders, so I need to make a report on the files present in those subfolders as well. To achieve this requirement, … read more…
Recently, one of our clients requested us to provide a solution for adding bulk Excel data to a SharePoint list programmatically. We can achieve this using a PnP PowerShell script. So in this article, we’ll learn how to read an Excel file and add bulk data to a SharePoint list using PnP PowerShell. Import Excel … read more…
If you’ve ever needed to compare numbers, dates, or even objects in PowerShell, you’ve probably wondered how to check if one value is greater than or equal to another. In this tutorial, I’ll walk you through the “greater than or equal” operator in PowerShell using examples. PowerShell Comparison Operators Comparing values is at the heart of scripting … 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…
Ever found yourself needing to quickly list every .pdf or .xlsx file scattered across hundreds of folders on your Windows laptop? PowerShell helps find every file with a particular extension—no matter where it’s hiding. In this tutorial, I will explain how to find all files with extensions using PowerShell with examples. Method 1: Find All Files with a Specific Extension (Single Extension Search) … read more…
Recently, one of my clients wanted to list down old files from a shared drive in their New York office. By using PowerShell, you can identify files older than any date you choose. In this tutorial, I will show you how to find files older than a specific date using PowerShell, along with some examples, such … read more…
As a PowerShell administrator, I mostly worked with the PowerShell Select-String cmdlet. So, I thought to show you 10 real examples of Select-String in PowerShell. Example 1: Basic Text Search in a File The most straightforward use of Select-String in PowerShell is to search for a specific text pattern in a file. This command searches … read more…
In this tutorial, I’ll walk you through multiple methods to concatenate strings in PowerShell’s Write-Host command, from the most basic approaches to advanced techniques. String concatenation in PowerShell, especially when using the Write-Host cmdlet, is something you’ll do almost daily if you’re writing scripts for system administration or automation tasks. As a PowerShell expert with … read more…
One of my clients recently asked how to check the size of a specific SharePoint document library. The easiest way is through SharePoint’s Storage Metrics, which is available in the site settings. It provides the total size, %of Site Quota, etc. In this article, I will also explain how to get the SharePoint document library … read more…
When working with strings in PowerShell, I often need to extract characters from the end of a string. You will get this kind of requirement when parsing log files, manipulating file names, processing data from APIs, etc. In this article, I’ll show you several methods to extract a substring from the end of a string … read more…
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
