Available now: Hands-On Microsoft Lists

I am delighted to announce that a book I have co-written is getting published today! João Ferreira, a Microsoft MVP from Portugal, and myself have written “Hands-On Microsoft Lists“, edited and published by Packt Publishing. The target audience for our book are people who have used Office 365 and SharePoint before, and now want to learn more about how they can leverage Microsoft Lists. Microsoft Lists is an extremely flexible Details

It’s been a while… What’s next?

Well, it’s been a while since I wrote something here. As I changed my job in April last year, I also had a change in job scope – away from daily operational work (it’s been MONTHS since I last ran a PowerShell script!), on to more project and strategy focused activities. A good amount of the content on my blog originated from this daily work (scripts, how to do xzy, 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

Study Guide – MS-300 Deploying Microsoft 365 Teamwork

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 Vlad Catrinescu. 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:https://absolute-sharepoint.com/ms-300-study-guide-deploying-microsoft-365-teamwork This week I took the MS-300 Deploying Microsoft 365 Teamwork beta exam. This exam addressed the areas Configure 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

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

Awarded Microsoft MVP for the sixth year in a row

Together with more than a thousand other MVPs worldwide, I was eagerly awaiting July 1 – the day when Microsoft sends out the renewal emails for MVPs. And I am very honoured to announce that I have received the prestigious Most Valuable Professional (MVP) award for the sixth year in a row. Being part of this amazing group of people is something I am very grateful for. In Microsoft’s words, “Microsoft 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