/images/profilepic.jpeg

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? We’ll go through 1 document library, then through all document libraries in your site. Which means 2 PowerShell scripts! 🤠

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 .NET Framework. Since 2016, we also have PowerShell Core which is open-source, cross-platform, and built on top of .NET Core.

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. Blow is a full script for your comvenience!

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

/images/microsoft365-screenshots/block-file-download-in-odfb-img1.png
 

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!