I secretly automated my whole job with PowerShell

How to use Microsoft.Online.SharePoint.PowerShell with PowerShell 7?

This article explains an annoying extra step (or a really nifty trick – depending on how you choose to look at it!) you can take to make sure your PowerShell 7 is able to import a module that was developed for .NET Framework, instead of .NET Core. This is super helpful when you run into weirdness with some of the more, let’s call them CLASSICAL, PowerShell modules. Such as Microsoft.Online.SharePoint.PowerShell. Problem I use PowerShell 7 as the default shell in my Windows Terminal. It doesn’t…Continue reading How to use Microsoft.Online.SharePoint.PowerShell with PowerShell 7?

SharePoint is not broken - it just does't work

How to fix “The website does not support SharePoint Online credentials. The response status code is ‘Unauthorized'”

While running some SharePoint Online -PowerShell commandlets, or connecting to a SharePoint Online site from your app, you get the following (or similar) error about your SharePoint Online credentials being unauthorized for something you should definitely be authorized to do: Cannot contact web site ‘https://[tenant]-admin.sharepoint.com/’ or the web site does not support SharePoint Online credentials. The response status code is ‘Unauthorized’. And that’s not all – by digging into the full error message, you find the underlying internal error: MSDAVEXT_Error=917656; Access+denied.+Before+opening+files+in+this+location%2c+you+must+first+browse+to+the+web+site+and+select+the+option+to+login+automatically. What awakens my curiosity,…Continue reading How to fix “The website does not support SharePoint Online credentials. The response status code is ‘Unauthorized’”

Microsoft Azure logo

How to refresh all Az CLI subscriptions?

This article explains how to “reactivate” all of your accounts stored in your az account by refreshing your sessions. You might need this if you suddenly run into a script that needs to iterate all of your subscriptions without you being there to sign in to each one of them. Having a recently active session for each will help, and you can run your massive script unattended overnight or something like that :) But let’s take a step back – what’s the issue we’re dealing…Continue reading How to refresh all Az CLI subscriptions?