Retrieving an item’s version history and changes with PnP PowerShell

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

Study Guide – MS-301 Deploying SharePoint Server Hybrid

Update 13 May 2019: In case I find other good study guides online, I’ll link to them from here,Here’s another study guide by fellow MVP Becky Bertram. While a good number of links are the same for both our guides, she also linked to a few other resources, so check it out:http://www.savvytechnicalsolutions.com/educational-resources/exam-study-guides/exam-ms-301-study-guide/ Back in February, I took the new MS-301 Deploying SharePoint Server Hybrid exam (besides the MS-300, for which Details

Updating SharePoint Online List Icons with PowerShell

During a recent migration from on-premises SharePoint 2013 to SharePoint Online, we noticed that some of the migrated lists did not use the most recent icons, but rather older ones (from SharePoint 2007 or 2010, I can’t remember whether there was a difference between these two). For example, the following screenshot shows that all lists except for Tasks use the current icon set: The question was, can something be done Details

Progress Bars with SharePoint Online Column Formatting – April 2018 Update

On my blog post Progress Bars with SharePoint Online Column Formatting I showed how the new Column Formatting functionality can help to show progress bars inside a list:   On this post, I received the following comment from Rick: Progress is usually associated with completion (blue). What would it take to have the progress % be blue, and the background color of the bar (= 100%), associated from a separate column? Your Details

Progress Bars with SharePoint Online Column Formatting

Now that Column Formatting has begun rolling out to SharePoint Online tenants, I decided to look at some older use cases and test how they could be achieved with this new functionality. The first use case is a common one: an item’s progress is tracked in a list with a percentage indicator – a project’s total completion so far, an individual task’s progress, etc. This is usually stored as a 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 – 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