"This is fine" - a fine meme, I mean.

How to fix “LinkedAuthorizationFailed” when deploying an Azure Logic App?

This article explains one possible fix to “LinkedAuthorizationFailed” when you’re deploying a Logic App from a Azure Automation template. Maybe it’ll apply to other cases, too – but in my case, it helped me fix a broken template I had exported from Power Automate, and was bringing into Logic Apps. Problem So, another fun issue to solve! The actual error you run into might be something along these lines: The client has permission to perform action ‘Microsoft.Logic/integrationAccounts/join/action’ on scope ‘/subscriptions/[your subscription id here]/resourcegroups/[your app resource…Continue reading How to fix “LinkedAuthorizationFailed” when deploying an Azure Logic App?

Always ship Azure DevOps.

How to access invisible packages in Azure DevOps artifact feed?

Let’s go with a very simple “note-to-self” kind of a blog post today. Plenty of those to go around on this blog, and plenty more coming, I’m sure! This one is another case that should be really obvious, but isn’t, and should just work, but doeswn’t. Namely, when you have run a pipeline in Azure DevOps expecting it to publish a package in your internal NuGet feed so that all of your friends can use it. And Azure DevOps is great for just this, as…Continue reading How to access invisible packages in Azure DevOps artifact feed?

"This is fine" - a fine meme, I mean.

Guide: How to take over and kill a viral AAD tenant?

Rogue Azure Active Directories don’t sound like a huge and widespread problem, but Microsoft’s approach of generating unmanaged, viral AAD tenants whenever they encounter the tiniest reason to do so MUST be driven by some weird internal scorecard where “number of tenants” has a lot of weight, because you do get an Azure AD tenant really easily, and getting rid of one is surprisingly laborious. This guide aims to explain what’s the quickest way to remove one. Background Unmanaged directories can be troublesome because they…Continue reading Guide: How to take over and kill a viral AAD tenant?

PowerShell not loading them DLLs

How to list all of the assemblies loaded in a PowerShell session?

In this article, I’ll do my best to explain how to list all loaded assemblies in a PowerShell session. See PowerShell is great at caching assemblies in the weirdest possible way, so ending up with all kinds of mismatches in loaded DLL versions is pretty typical. Or just being plainly blocked from loading a new one as you already have a cached reference in. I mean, I’ve ran into all kinds of issues even if I only use PowerShell occasionally. Or maybe that’s the reason.…Continue reading How to list all of the assemblies loaded in a PowerShell session?

"I know Excel"

How to copy-paste a table from Excel to WordPress without using plug-ins?

So, I tried to paste a table from Excel to WordPress, and I failed. Annoying – but not a big problem. I can just paste it into an existing table and it’ll “sort itself out”, right? Well, no. Exporting the Excel sheet as a html page and copy-pasting the table from there didn’t work either. Actually, copy-pasting a table just didn’t work at all. So… WordPress is unable to understand HTML tables. Is that really it? Well, no, again, it’s not. It just refuses to…Continue reading How to copy-paste a table from Excel to WordPress without using plug-ins?

Welcome to your new SharePoint list - now don't rename the Title field!

How to create a new SharePoint list based on a List template (.stp)?

New Microsoft Lists are here. They are awesome, and a great move by Microsoft to reap even more value of the old war horse. Wait – old war horse? Well, behind the scenes, they’re actually “just” normal SharePoint lists with a bit of added sparkles and gizmos – namely, an app, a few automations to make users’ lives easier, and an application page to display the lists. Great move by Microsoft, launch quite well done, and a pretty good user experience so far. But it’s…Continue reading How to create a new SharePoint list based on a List template (.stp)?

Welcome to your new SharePoint list - now don't rename the Title field!

How to enable saving a list as template on SharePoint Online?

Another day, another fun little task in SharePoint Online… :) This time, I needed to be able to migrate 10 or so lists with some very specific fields and plenty of content from a site to another one. What’s the best way to do that now? While PnP templates have supported exporting contents for a while now, you can still run into some issues with them – namely, fields of type “person” (or rather, “user”) are not supported, and I didn’t feel like scripting a…Continue reading How to enable saving a list as template on SharePoint Online?

Elastic Premium plan? It's got potential.

How to upgrade your Azure Function app plan when you originally selected “Consumption”?

Sometimes, you need to change the hosting model (or tier) for your resources on Azure. Maybe you’ve outgrown whatever you’ve originally selected, maybe you’ve got too much cash on your hands, or maybe you’re like me, and you get absolutely and completely fed up with the cold starts for your Azure Function apps on Consumption plan. For these situations, you have the possibility of changing the hosting tier – the plan – you’re on. Although, this has been implemented in a disturbingly non-intuitive way! Problem…Continue reading How to upgrade your Azure Function app plan when you originally selected “Consumption”?

Let me explain SharePoint...

How to access the site collection app catalog in SharePoint?

This article explains how to access the Site Collection App Catalog in SharePoint Online. I mean – yeah, I had to google it after getting back to SPFx dev stuff after a while, and realized the first few results were useless. Of course. So how did you do this now… Turned out to be pretty easy, and borderline obvious! Still, yet another thing to document. Solution So, back to basics – how do you access the Site Collection App Catalog on a SharePoint Online site?…Continue reading How to access the site collection app catalog in SharePoint?

Powershell is hell

How to fix “System.InvalidOperationException: PowerShell Gallery is currently unavailable.”

This article explains how to fix an issue when updating a module in PowerShell. The error is something along the lines of: “System.InvalidOperationException: PowerShell Gallery is currently unavailable. Please try again later.” The whole error looks something like the one below, although you can probably get it for many different commandlets. The main point is the latter part of the error: PowerShell Gallery is currently unavailable. This, quite simply, stops you from installing or updating any modules, as you can’t access the PowerShell gallery, that…Continue reading How to fix “System.InvalidOperationException: PowerShell Gallery is currently unavailable.”

Microsoft Lists General Availability teaser image

How to change Microsoft Lists language?

I recently started playing around with Microsoft Lists. What a fun and friendly tool – makes SharePoint lists far more approachable offering a great editing experience, easy sharing, and hopefully in just a bit, awesome integrations and great mobile app (I mean, there’s iOS… But who has an iPhone in this day and age? 😉 However, as is usual in my tech endeavors, I immediately ran into an issue. Problem Some background: I’ve selected either EN-US or EN-CA as my locale everywhere on my work…Continue reading How to change Microsoft Lists language?

Visual Studio logo

How to remove your account as a guest in another Azure AD tenant?

This article explains how to fix your account, whenever it gets completely FUBAR due to your account being added as a guest in another AAD organization. And this might happen in multiple different situations – my most typical woe is Visual Studio’s Cloud Explorer, which stops showing me my subscriptions due to authentication against the other organizations failing. Add some extra difficulty by having someone in the other directory block your account from signing in, and you can’t even remove the account by any usual…Continue reading How to remove your account as a guest in another Azure AD tenant?

AADSTS50196 error message

How to fix error AADSTS50196 on Microsoft web properties?

This article explains how to fix error with error code AADSTS50196. This issue usually comes up with an error message somewhat like “The server terminated an operation because it encountered a client request loop.” The error seems to be popping up more and more often. No worries – it wasn’t caused by you! It is, in fact, an unintended side effect of a security hardening feature in some browsers, and some outdated configuration on Microsoft’s end. Obviously, you could run into the issue on other…Continue reading How to fix error AADSTS50196 on Microsoft web properties?

Visual Studio logo

How to restore lost windows in Visual Studio?

This article explains how to restore any hidden windows in Visual Studio without resetting your whole window layout, by using a common keyboard shortcut. Problem We’ve all been there – you’re opening a new window in Visual Studio, but your keyboard shortcut or clicking the item in the menu simply seems to do nothing. The window doesn’t show up anywhere. Reason The reason for this (most of the time) is simple: you have the window popped-up and located outside your screen. This happens pretty much…Continue reading How to restore lost windows in Visual Studio?

Docker is the unfortunate future

Gotchas when configuring Home Assistant on Docker on Windows

What a nice headline, right? 😅 One day, I thought I’d give Home Assistant a try! And obviously, I couldn’t just make things easy and run it in a Linux virtual machine or my Raspberry Pi – instead, obviously I decided to run it on Windows 10! And obviously, I’d use Docker for it. And of course, not just Docker, but docker-compose. Whatever that is. I don’t know – it’s the first time I’m trying out Docker. Or Home Assistant! Another learning experience coming in,…Continue reading Gotchas when configuring Home Assistant on Docker on Windows

Microsoft Azure logo

Enabling local cache for an Azure App Service

This article explains one easy way for you to improve the performance and uptime of your Azure App Service. I’ll explain a simple but kind-of-hidden and surprisingly badly documented feature – Azure App Service Local Cache, that is – which might make a huge difference. It sure did for me! Since it’s such a no-brainen, I’m kind of half expecting everyone else to already having known about this, but since nobody told me about it, I’m going to document it for future use. Background Let’s…Continue reading Enabling local cache for an Azure App Service

Azure Active Directory (Azure AD)

How to find out the Directory ID of your Azure AD tenant?

This article explains in extremely short way, how to fetch your Azure Active Directory tenant’s Directory ID. Let’s make it short and sweet, because quite frankly, it is really simple! Solution Option 1: Use whatismytenantid.com for finding your tenant/directory id: Quick solution – works (at least) for all standard tenants: Navigate to https://www.whatismytenantid.com/ Enter the domain associated with your Azure AD instance (often like contoso.onmicrosoft.com) Let ShareGate do their magic and find your tenant/directory id for you! Thanks to Thomas Vochten for pointing this out…Continue reading How to find out the Directory ID of your Azure AD tenant?

Microsoft SQL Server logo

How to clean up duplicates from MS SQL Database?

This article explains how to query and remove duplicate entries from a Microsoft SQL database using T-SQL. The same model works both for Azure Databases (in Azure SQL Query Editor) and databases on MS SQL Server (using SSMS – SQL Server Management Studio). I had to do this a while back due to a bug in an API creating multiple entities with the same content – save for the Identity field. Fun! Background Why bother? That’s a (somewhat) valid question. A table in a SQL…Continue reading How to clean up duplicates from MS SQL Database?

Microsoft Teams Logo

Tips on organizing an online conference using Microsoft Teams

Writing this in a country under lockdown, it feels like every single conference in the world has either been cancelled or switched to being online-only. And right now, that’s definitely for the best! But it does pose quite a dilemma for those in charge of these events – how do you organize an event for potentially thousands of attendees, online? How do you foster great interaction between the audience and speakers? How do you encourage your attendees to mingle as well? How do you avoid…Continue reading Tips on organizing an online conference using Microsoft Teams

Microsoft Teams context in SharePoint Framework client-side code.

Why you shouldn’t attach files from other channels in Microsoft Teams?

This article will describe a surprising issue with Microsoft Teams, and a simple workaround. 😊 Essentially, using the out-of-the-box “Attach” > “Recent” messaging extension in Teams has a couple of caveats or edge cases, that make it problematic to use. Instead, either move the file to the proper location using the “Files” tab, or share a link to your file (also available under “Attach” > “Browse Teams and Channels”). This post will describe the actual solution for moving the file safely, without data loss. Problem…Continue reading Why you shouldn’t attach files from other channels in Microsoft Teams?