Find checked out files across multiple Site Collections using PowerShell

It might be another day, and you might have another requirement! In today’s blog post, we’ll have a look at we can find files that are checked out in SharePoint Online and extend the search across multiple Site Collections, multiple document libraries, using PowerShell PnP. Requirements Requirements are simple: Find all the checked out files in multiple sites, and multiple document libraries in my Office 365 tenant. Script And here we start writing down the logic 🙂

Find empty folders in SharePoint using PowerShell

We still have this debate about Folders vs. Metadata. Which one is better? Should I continue to use folders? etc… It’s OK to use a bit of both if you want. There are pros and cons for each one, and really depends on your organization requirements, user experience, and so on. Today, we’re not talking about choosing one or the other, but rather assuming you’ve got folders, and you want to clean up the empty ones!

Custom Search in SharePoint using OOTB features and Open Source webparts

As we all know, Search is extremely important in SharePoint. We have a lot of features out-of-the-box ready to help us configure a great Search, but we also have a great community out there working/contributing to open source Search webparts! In this post, we’ll configure a custom Search. We’re going to scope it to a few Site Collections, and add the PnP Modern Search Webparts which are open sourced on Github.

Get the check-in comments using PowerShell

Today’s post is not directly about PowerShell PnP, nor SharePoint Online, but it was such a struggle that I really wanted to share my experience, and my script. Hopefully it will help you in case you’re in the same situation. Scenario The reason why I was trying to get those check-in comments was because I was preparing to get a report from an on-prem SharePoint 2013 document libraries with some information, so I could migrate files to SharePoint Online using PowerShell and of course, bring over all the versions & the check-in comments if any.

Get nested folders, files count, folder size, and more in SharePoint using PowerShell

Isn’t it nice to have some reports, inventory, or any visual about a SharePoint site? So we know what’s going on, at a high level at least. Today’s post will be about running PnP PowerShell to extract info on a SharePoint site, and we’ll go fetch those nested folders! But that’s not all, we’ll also get the number of files in each folder, and the folder size! Want another bonus?

Split data into 2 columns in SharePoint using PowerShell and Power Automate

In this blog post, we are going to use SharePoint Online, PnP PowerShell, and also Power Automate (aka Microsoft Flow) so you really needed to know that we were about to built in the title 😅 ## The idea The idea here is to split the data from one column into 2 other separate columns in SharePoint Online. An easy example would be a column being called “Full Name“. We’d want to split this data in a column named “First Name“, and another one called “Last Name“.

Benefits of using PowerShell with SharePoint

This is an article I have written for the Microsoft 365 Community Docs repository on Github. If you don’t know what this repository is about, I would highly encourage you to have a look at the README file. It contains information to guide you about the purpose of the repo, and also how to contribute! What is PowerShell? PowerShell is an automation scripting language from Microsoft, which was originally only available on Windows devices, and built on top of the .

Get likes and comments count on SharePoint pages using PowerShell

Today, we’re going to play a bit with SharePoint Online pages, and try to get the number of Likes & Comments we have for each page within a Site Collection. Without further due, let’s get started! Get likes and comments count for all pages on a Site It might be useful to get get a report as to how your pages are performing, and you can get this with PowerShell.