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.

Block file download in OneDrive For Business

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.

Modify the quick launch in SharePoint using PowerShell

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!

Get files with specific names in SharePoint using PowerShell

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.

Create folders in OneDrive For Business using PowerShell

A few years back, I needed to create folders in OneDrive for Business in preparation for a migration. And as PowerShell PnP (Patterns & Practices) didn’t exist, I used CSOM (Client Side Object Model). Now that we have PowerShell PnP, we can accomplish so much with only a few lines of code, and it’s more “admin-friendly“. In this blog post, we are going to see the process of creating folders in OneDrive for Business, and also what I call “clean up after yourself”.

Share SharePoint sites with specific domains only

Sharing with external users (outside your organisation) has never been easier with SharePoint Online. A good business case could be the use of Extranet sites. You have business partners you wish to collaborate with, securely and quickly, without the hassle of settings up a complex infrastructure. In this blog post, we’ll look at setting up a SharePoint Online site collection sharing settings for external users but only for specific domain(s).