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

Scheduling Twitter Content with Microsoft Flow

Update May 2019: A follow up post with additional information has been published. Two years ago, I wrote a blog post about how you can schedule Twitter content with Azure Functions. I used Azure Table Storage to store relevant content that I want to get published, and Azure Functions to query it periodically to check if anything needs to get posted to Twitter. Today, I thought I should finally check Details

Advanced Flow – Daily Service Request Emails with Status Groups and Counts

After my Advanced Flow session at the Microsoft Ignite Hong Kong, an attendee asked me about a specific update that could be done to the demo. What she wanted to do is add some additional information to an auto-generated email, namely not just showing data grouped together, but also showing the count of the items within a group. If you’re curious about the overall demo in general, you can review 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

Automatically setting Cache-Control for Azure Storage Blobs via Azure Functions

I’m storing my blog’s images in Azure storage and serve them via Azure CDN for a better performance. However, the images didn’t have a Cache-Control header so far, so they wouldn’t get cached as much / as long as I wanted to. And while setting the CacheControl property on my Azure Storage blobs manually is possible, I didn’t want to do that, but rather have it automated. Azure and automation? Details

Getting AWS CloudFront CDN Cache Status with Fiddler

For a customer project I’m working on at the moment, we are using AWS CloudFront as a Content Delivery Network (CDN) to improve the global performance of a public website. Users in regions far away from the server should be able to view the website much faster thanks to it being cached on a CloudFront edge location close to them. For our testing, we wanted to know whether a resource 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