Get attachment names in SharePoint lists using PowerShell

Have you ever noticed that in SharePoint, when you attach files in a list item, you can add the column “Attachments” and visualize a little clip thing, but it doesn’t show the number of files nor their names? So what if you wanted to know about all the attachments in a list item? In multiple lists? Are you going to… click click click? Noooo, let’s use PnP PowerShell for that!

Change column values based on other column values using PowerShell

Today, I wanted to share something I’ve learned thanks to the PowerShell Community out there, who responded to my Tweet for Help within minutes! 👏 Scenario We have a bunch of columns in SharePoint Online, all different types, but more importantly, some are Multi-line of Text columns. This means that users can enter whatever they like: Initials, words in UPPER/lower case, insert special characters, etc… You name it, users will type it!

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“.