Dynamic Country Maps in PowerApps

Today I stumbled upon an older, but wonderful article about how you can use SVGs (Scalable Vector Graphics) within PowerApps, and how you can modify them dynamically for custom visualizations: Advanced PowerApps visualizations with dynamic SVG’s. This made me think about other potential use cases, and I decided to check if I can build a reusable component that displays a World Map and allows to highlight countries with different colours. 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

Scheduling Twitter Content with Microsoft Flow

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 if the same functionality is also available with Microsoft Flow. So basically, I 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

This week I took the MS-300 Deploying Microsoft 365 Teamwork beta exam. This exam addressed the areas Configure and Manage SharePoint Online (35-40%) Configure and Manage OneDrive for Business (25-30%) Configure and Manage Teams (20-25%) Configure and Manage Workload Integrations (15-20%) My usual preparation for any tech exam is Read lots and lots and lots of documentation Get my hands dirty (tutorials, follow steps listed in docs, try things out, 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