Microsoft Office Apps & Services MVP | Singapore
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
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
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
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
I’ll finish this year’s Office 365 Advent Calendar with a small overview of the Office 365 Services and Applications. Basically, the following document contains all current services and applications with a short description. You can use this document as a starting point for your organization, your customer, or anyone else with whom you want to discuss the Office 365 suite. Office 365 – Overview of Services and Applications (pdf)
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
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
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
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
When it comes to sharing content with external parties in SharePoint Online, setting up sharing can be done easily. But what if you want to get some details on who shared which content with which external party, for example for compliance or audit reasons? The good news is that this kind of information can be retrieved quite easily from Office 365, and you can even set up alerts to be Details