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 – 22 Modern and Classic Experience in SharePoint Online

Earlier this year, Microsoft announced and rolled out the modern experience for lists. They didn’t stop at that, but also introduced modern pages and sites. But what are the differences to the ‘classic experiences’, so the type of lists, libraries, pages, and sites that we’ve been using now for many years? How can you switch between these two experiences? And how can you customise the modern experience items? Luckily, there’s some 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 – 20 Get notified about new SharePoint Online Site Collection Administrators

If your organization provides business users with the possibility to manage sites themselves by assigning them site collection administrator rights, you may want to know if they add anyone else as site collection administrator. While you could run a script regularly to retrieve a list of all site collection administrators on all sites and then compare this data with previous information, there is also an alternative that you can use. 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 – 11 Adding sample items with random data to a SharePoint Online List

Scenario Sometimes you want to create some random sample data to be used in a SharePoint Online list. For example, in yesterday’s post I was using a list with some data which I entered manually, but I thought afterwards that I could’ve scripted it to create many more items in my demo list. Today, I show you how you can easily fill a list in SharePoint Online with as many Details

Office 365 Advent Calendar – 10 SmartFilters and Grouping in SharePoint Online Modern Lists

Microsoft has just started rolling out a new feature called Smart Filters to SharePoint Online tenants with First Release enabled, all tenants will see it in January. Smart Filters are available in Modern Lists, and allow you to filter from a sidebar pane to easily and quickly find items you’re looking for. What’s the difference to the existing filtering functionality on columns? Smart Filters are not just shown for a Details