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.
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?
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“.
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 .
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.
When you share a file from your OneDrive for Business, maybe you don’t want recipients to download the file? In today’s short post, that’s what we are going to do! Share a file and block the download To share a file, you can select your file, and click on the ellipses (…), then click on Share Once the pop-up window opens, click on the permissions box, and choose your permission model.
There are some useful cmdlets in the PnP PowerShell module that one wouldn’t think about using, but coupled with a set of other cmdlets, they can be very useful! In today’s blog post, we’ll take the example of the Quick Launch. We can add, remove, or even change the name of a list / library by using PowerShell. And when I said earlier coupled with other cmdlets, we’ll create lists & document libraries too!
It’s not uncommon for companies to be wanting an inventory of files / folders in SharePoint. But we can also narrow down the request, and look for only specific documents? In this blog post, we’ll have a look at how to retrieve all the documents with particular name(s), from a Site. Maybe you have a naming convention for files / folders, and therefore, it’s easier to target. Current documents in a Site As a proof (although technically, you can only take my word for it), I’ll run a script to check ALL the documents I have in my site… In the image below, we can see that I have multiple documents, on different document libraries.