Just a few days I wrote that ” it’s been MONTHS since I last ran a PowerShell script!” – and yesterday I not only had to run a script, but create it first. Luckily I still remembered how to use some of the PnP PowerShell cmdlets (though I have to confess, I forgot some syntax), and got the script working within a very short time. Not a surprise, really, as Details
PnP PowerShell script samples for SharePoint & Office 365
Over the past few years, I have been using the PnP PowerShell cmdlets quite regularly. They’re a constant companion in all my projects, and very often they’ve helped me to solve issues, automate tasks, and generally simplify my life. Examples include: Setting SharePoint Online Site Collection Search Settings with PowerShell Exporting SharePoint Online List/Library Detail Get Versioning Details for all Lists in a SharePoint Online Site Getting all Permissions Levels Details
Increased Path Length for Files in SharePoint Online and OneDrive
Update: I added a small script below to create a folder structure in a tenant so that you can test the new limit Yesterday, Microsoft announced another small but great change to SharePoint Online and OneDrive: in previous versions of SharePoint you were limited to a maximum path length of 256 characters. This meant that if you had a very deep folder structure, potentially also with long file or folder names, Details
Setting SharePoint Online Site Collection Search Settings with PowerShell
Today, we’re going to have another quick look at the wonderful world of PowerShell and how the PnP PowerShell cmdlets make our life a lot easier when administrating SharePoint Online. I had a couple of site collections that needed to have their Site Collection Search Settings updated to use a dedicated Search Center. While it would be possible to manually go into each site collection and update the settings, this Details
Office 365 Advent Calendar – 23 Bulk-updating File Extensions in SharePoint Online with PowerShell
Scenario A short while ago, I had to update a fairly large number of documents in multiple libraries in a SharePoint Online site. Problem was that their file extension was .html which doesn’t display in the browser if stored in SharePoint Online, but rather these files get downloaded upon opening. The workaround – rename them to .aspx. The following scripts does this for all .html files and renames them to Details
Office 365 Advent Calendar – 21 Get all Instances of a Web Part in a SharePoint Online Site
Scenario Sometimes you may need to figure out where a specific type of web part has been used. Today, I’ll show you how you can check all pages in your Site Pages library for a specific web part. I’ve had this code for a while as I was looking for some specific web parts (Content Editor) before. Yesterday, I briefly saw a blog post on dev.office.com announcing the deprecation of the Details
Office 365 Advent Calendar – 18 Adding a Web Part to a SharePoint Online Page with PowerShell
Scenario You’ve got a Web Part which you want to add to one, but more likely multiple web part pages in a SharePoint Online Site. Or maybe even on multiple pages across multiple sites. You could do this manually, but adding the same web part with the same configuration over and over again may not be a productive use of it. Let’s make use of PowerShell to do this! Code Details
Office 365 Advent Calendar – 15 Activating Publishing Features on SharePoint Online Sites with PowerShell
Scenario Activating SharePoint’s Publishing features can easily be done on a single site collection or site. But what if you need to activate Publishing on a hierarchy of subsites, or across multiple site collections? Code Once again, we’re using the PnP PowerShell cmdlets. First some basics. The ‘main’ feature to activate is the PublishingSite feature on the Site Collection level. After you connected to a site collection (Connect-PnPOnline), you can activate it as Details
Office 365 Advent Calendar – 14 Exporting SharePoint Online List/Library Details
Well, this is a bit embarrassing. Yesterday, for the first time, I didn’t verify if my scheduled blog post got published properly. And yesterday, also for the first time, it didn’t get published. I made a small scheduling mistake (it’s not 2017 yet…), so the 14th December post comes a day late: Scenario From time to time you may need an overview of all lists and libraries in your site Details
Office 365 Advent Calendar – 12 Get External Sharing Details for SharePoint Online Sites
Scenario SharePoint Online allows you to share your content with external parties – that is, if sharing is allowed on the tenant level as well as on the site collection level. But if you allow external sharing on the tenant level, how can you easily see for which site collection you have which kind of external sharing level enabled? Code Today’s script doesn’t make use of the PnP PowerShell cmdlets, Details