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 – 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 – 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 – 17 Overview of the new OneDrive for Business Admin Portal

At the Microsoft Ignite conference in September, it was announced that OneDrive for Business would get its own Admin Portal in Office 365. Yesterday, Microsoft finally made it available, even though it’s in Preview at the moment. See the official announcement here, and access it at https://admin.onedrive.com. So what does it include? Some existing settings, such as configuring your sharing settings, as well as new settings like the possibility to restrict 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 – 13 Useful Office 365 Sessions from Microsoft Ignite

End of September, the Microsoft Ignite conference took place in Atlanta with hundreds of sessions across a huge rang of Microsoft products. The great news is that these sessions are available on demand for anyone to view! If you’re interested in taking them offline, have a look at the Ignite 2016 Slidedeck and Video downloader script. Today, I’ll share with you some of my favourite sessions: Drive productivity with OneDrive and Details