SharePoint is not broken - it just does't work

(Literally) Breaking: Changes to app authentication on SharePoint! 😵

This article explains how to get rid of sudden and unexplainable 401 Access Denied errors when trying to authenticate against a fairly fresh Microsoft 365 / SharePoint Online tenant. This issue seems to be caused by a long-ish project to finally retire ACS – Azure Access Control service) on SharePoint (it’s retired everywhere else already!) Note: This is an updating story, as the situation with ACS is definitely… Developing. Yeah, let’s call it that. It’s a developing situation. Problem In the beginning of September (2020),…Continue reading (Literally) Breaking: Changes to app authentication on SharePoint! 😵

When my Azure Function doesn't build

How to fix “System.IO.FileSystem: Could not find a part of the path \AppData\Local\AzureFunctionsTools\Releases\3.17.0\workers. Value cannot be null. (Parameter ‘provider’)” when running Azure Functions locally?

Well, that title is a mouthful. But it’s the topic for today, so what can you do? That said, this article should be pretty topical, as the issue started popping up only a few days ago. Chances are it’ll be patched soon enough, but in the meantime, it’s always useful to document the fix! Problem When running or debugging Azure Functions locally, your runtime just blurts our this error and fails to compile your functions: [2021-01-11T10:28:11.495Z] A host error has occurred during startup operation ‘0d00defa-b8bd-4fb8-9794-b0e5950a4c38’.…Continue reading How to fix “System.IO.FileSystem: Could not find a part of the path \AppData\Local\AzureFunctionsTools\Releases\3.17.0\workers. Value cannot be null. (Parameter ‘provider’)” when running Azure Functions locally?

Have you tried turning it off and on again?

How to nuke the Identity Cache in Visual Studio?

This article explains one easy workaround to a lot of Visual Studio authentication issues. Personally, it’s helped me multiple times when Cloud Explorer has gotten into a weird authentication loop or Visual Studio stops seeing my MSDN subscription. And it also helps you clean up any old and unused credentials – such as the ones you only used once in 2018 to log into a customer’s Azure environment to debug an issue they had with their AppInsights extension on an app service (and that ended…Continue reading How to nuke the Identity Cache in Visual Studio?

What in tarnation (and tarnation accessories)

Fixing unexpected Microsoft.AspNetCore package errors after a dependency update

This was a fun one! Suddenly, while running or debugging my ASP.NET Core 3.1 application, I started getting errors about missing assemblies. These dll files were not required a minute earlier – nor did requiring them really make much sense in my mind – but there was a nonsensical, easy fix, so in the end it was all good! But let’s go through this thing in order. What was the problem now? Problem So, this was the error I was running into, whenever I ran…Continue reading Fixing unexpected Microsoft.AspNetCore package errors after a dependency update

Hindsight is 2020 meme

2020 – Year Review

Like almost customary at this point, I decided to take a look at 2020 – which goals I had set for myself, if I hit them, and what happened on koskila.net during the year. And like last year, I thought I’d set myself a few new goals! In my last year review post, I commented on 2019: 2019 was borderline tumultuous – in 2020, I hope it’ll be slightly smoother sailing. Me, in my 2019 review Oof. Overall, 2020 was definitely not “smoother sailing”. But…Continue reading 2020 – Year Review

Microsoft Graph g-raph (giraffe) - the spirit animal of Microsoft Graph

Graph API throws “$count is not currently supported.” when you KNOW it’s supported?

Hey, another funny case. “Funny” as in “the error message is misleading and googling didn’t really help”, but also as in “a colleague knew the answer right off the bat because he already fixed it in another project”. This time the documentation was in fact there, it just wasn’t there to be found. Anyway – what have I broken this time? Problem When you’re calling Graph API with both $filter and $count, for example like this: Instead of the expected number of found items, you…Continue reading Graph API throws “$count is not currently supported.” when you KNOW it’s supported?

Entity Framework Core logo

“An assembly specified in the application dependencies manifest was not found” when running Add-Migration in Entity Framework Core?

Another quick one – I’m sure this doesn’t apply to all cases, but I’m still logging it in case someone (like myself) stumbles upon the issue and finds help here. I was building a solution with some Azure Functions fetching and populating data in a database, and was planning on building an UI for browsing the data at some point later on – but I actually got stuck on the second step already :) While adding the database to my project, while running Add-Migration in…Continue reading “An assembly specified in the application dependencies manifest was not found” when running Add-Migration in Entity Framework Core?

Azure Active Directory (Azure AD)

How to fix Visual Studio Cloud Explorer being unable to access your subscriptions?

This article will describe a number of fixes to a situation, where your Visual Studio Cloud Explorer fails to show you the Azure Subscriptions you (should) have access to. Problem Your Cloud explorer might load for a long while, and finally fail to display anything meaningful. Instead, you might see an error like below: Solution This one was not fun. There are quite a few different reasons why your Visual Studio might suddenly struggle with your accounts. Below, I’ll explain a couple of steps you…Continue reading How to fix Visual Studio Cloud Explorer being unable to access your subscriptions?

Pulumi Azure Next-gen logo/splash

Pulumi task on Azure DevOps fails with error “azureblob.OpenBucket: accountName is required”

This article explains how to fix one of the many issues you might face when configuring Pulumi deployments for your Azure DevOps Pipelines! The particular error you may run into was “azureblob.OpenBucket: accountName is required” – what a descriptive one, when there’s no accountName to be specified anywhere! But first – let’s get through the basics. Namely… “Pulumi?”, you ask – “What’s that?” Well, let me give you a 1-line response to that. One very long line, that is. But what was the error I…Continue reading Pulumi task on Azure DevOps fails with error “azureblob.OpenBucket: accountName is required”

Hacktoberfest 2020 - completed!

Hacktoberfest 2020

Another year, another Hacktoberfest, another haphazard participation and – as usual – another blog post a little bit late. Still, better late than never, and the event has become such a phenomenon I’m happy I did finish the challenge (or like DigitalOcean calls it – the celebration)! The event has a special place in my heart, as it did (in 2017, I think?) encourage me to contribute more to the community – not only by maintaining this blog but also by occasionally submitting a Pull…Continue reading Hacktoberfest 2020

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?

Frequently Asked Robot Lawn Mower Questions

This article is my attempt at documenting my experiences with Worx Landroid L2000. It’s a phenomenal little helper in your garden, but it will run into issues – and it’ll make you work a bit in order to get it to run efficiently! This article contains all of the gotchas I’ve run into so far, wrapped in a handy FAQ-format for your convenience (and mine, to be fair – I’ll be back to consult my notes later)! Most of the points should apply to a…Continue reading Frequently Asked Robot Lawn Mower Questions

Say "Dependency Injection" one more time I DARE YOU

How to inject EF Core DbContext in an Azure Function?

Ah, one more on the related topics of different configurations for your Azure Function apps. In this article, I’ll describe how you can configure the Entity Framework Core database context to be injected into your Azure Functions App. In my experience, this is a very typical and often-needed model to structure your Azure Functions, so while tooling and templates aren’t quite there, it’s worthwhile to document here. Solution I’ve posted before about how to instantiate a database context using DbContextOptionsBuilder – see a copy-pasteable example…Continue reading How to inject EF Core DbContext in an Azure Function?

Entity Framework - am I right?

“Conversion overflow” when reading numeric data from MS SQL database using Entity Framework

This article explains how to fix a weird situation where your .NET application utilizing Entity Framework or Entity Framework Core simply crashes without any way to recover or catch the Exception. You only get errors somewhere along the lines of “conversion overflow”. Ah – what a fun little issue! Problem So when you’re trying to instantiate an entity with a property of type decimal, you’ll get one of the 2 following exceptions with varying Call Stacks: Conversion overflow or: Arithmetic overflow error converting numeric to data type numeric…Continue reading “Conversion overflow” when reading numeric data from MS SQL database using Entity Framework

Azure Functions CLI - such a pretty logo for such an awesome functionality

How to configure Azure Function’s startup?

Azure Functions use dependency injection, and that allows us to define all kinds of prebuilt or custom-built services as being available for our functions really easily. This is a really easy way to initialize scoped resources to be used in your different functions… But how do you actually configure them in an Azure Functions App? Problem Okay, a step back – there’s a bit of a problem that we need to resolve before we can proceed with the configuration. When you create a new Azure…Continue reading How to configure Azure Function’s startup?

git logo

How to list your git stashes?

Long story short, yes, I really had to google this, and since top results seemed to give pretty unclear (or even wrong) answers, I decided to document it for myself. Maybe it’ll be helpful to someone else too! And just to state the obvious: I’m using GitHub Desktop for most of my mandatory Git stuff, but for whenever I have to run any git commands, I run Windows PowerShell (git exe is added to PATH variable). Solution Well, it’s actually very, VERY simple. You can…Continue reading How to list your git stashes?

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. Luckily, like usual, there are a few ways to fix this! Solution

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?

Spotify Premium logo

Is Lifetime Spotify Premium a scam?

This article describes another fishy online offering, Spotify Premium Lifetime subscription. Long story short, it’s a scam, just not a very heinous one. Depending on the calibration of your moral compass, it might even be worth it, although definitely not recommended. Let’s take a closer look at what’s going on with this criminal affair, then! (If you’re in a hurry, check this out first: How to approach a Spotify Premium Lifetime upgrade safely) A while back, I wrote an article about cybercriminals stealing your money…Continue reading Is Lifetime Spotify Premium a scam?