All Posts

All Posts (569)

• 

  Published on

  2019-04-25 1:14 p.m.

  Authors

  koskila

  Tags

  SharePointSharePointSearch

  How to add multiple aliases to a Managed Property in SharePoint Search?

  This article explains how to add multiple aliases to one managed property in SharePoint Search Schema Management. Yes, it's possible, just a bit unintuitive! I'll explain the process below. Solution This seems to be another "gotcha", that's missing from the official documentation, but is super helpful to know when you happen to need it!

  Read more →
• 

  Published on

  2019-04-23 8:09 a.m.

  Authors

  koskila

  Tags

  ClassicSharePointPnPPowerShellSharePoint

  How to fix "Access denied" errors when running "Set-PnPAvailablePageLayouts"?

  This article describes one way how to fix seemingly non-sensical " Access denied " errors, that you get when running Set-PnPAvailablePageLayouts . Problem While running the PnP cmdlet for enabling or selecting the available publishing page layouts for a web, you run into this, fairly generic error: Access denied. You do not have permission to perform this action or access this resource.

  Read more →
• 

  Published on

  2019-04-15 11:31 a.m.

  Authors

  koskila

  Tags

  AzureAzureFunctionsEntityFrameworkCoreEFCore

  How to access Entity Framework Core's DbContext in an Azure Function?

  This post describes how you can access your Entity Framework Core model classes and the database context in your Azure Functions. In my example I'm using EF Core 2.1, but the main principle should be the same for later versions as well. Please note, that I use Azure functions runtime v2 (but it should work the same in v3 !) Another easy one, that I was unable to find much guidance on! But first, let's start with the basics. Why would you want to have this setup?

  Read more →
• 

  Published on

  2019-04-11 10:35 a.m.

  Authors

  koskila

  Tags

  PowerShellSharePointSharePointOnline

  Another fix to the "Connect-PnPOnline : The sign-in name or password does not match one in the Microsoft account system." error.

  This post describes a simple way to get around the following error while running Connect-PnPOnline: "The sign-in name or password does not match one in the Microsoft account system." Truthfully, this one is kind of simple and stupid - but as I've seen before, it's surely worth documenting anyway! Below is an example of such an error. PS C:\> Connect-PnPOnline https://contoso.sharepoint.

  Read more →
• 

  Published on

  2019-04-02 12:17 p.m.

  Authors

  koskila

  Tags

  AzureAzureFunctions

  Sudden "Function compilation error" for an Azure Function

  Welp - another interesting error encountered while deploying Azure Functions to Azure. So, everything runs nicely locally, but when you deploy your well-tested, functional and pretty code to run them in the cloud, you'll just get these ugly and unfriendly errors. Long story short, " Function compilation error " is what you're faced with. Example error below: Function compilation error Microsoft.CodeAnalysis.Scripting.CompilationErrorException : Script compilation failed.

  Read more →
• 

  Published on

  2019-03-28 9:27 a.m.

  Authors

  koskila

  Tags

  AspNetCoreBlazorCSharpEFCore

  Current User in ASP.NET Core

  This post describes how to get the currently logged-in user using ASP.NET Core. This is compared with how it's done in ASP.NET Framework. Background In ASP.NET Core (and .NET Core in general), a lot of things are done a bit differently than what you might be used to if you're coming from the .NET Framework world. That's what I've been learning building more and more stuff with it, instead of good old .NET Framework.

  Read more →
• 

  Published on

  2019-03-28 1:12 a.m.

  Authors

  koskila

  How to disable the footer in Modern SharePoint?

  Modern SharePoint Online recently got a new, super useful and much-requested new feature: a site footer. This little buddy now makes it possible to create informative, stylish and useful footer areas for your intranet sites. But what if you already implemented such a solution based on, say SPFx extensions, and now you've got 2 footers? Well, you might want to disable one of those two.

  Read more →
• 

  Published on

  2019-03-27 10:31 a.m.

  Authors

  koskila

  Tags

  ClassicSharePointModernSharePointPowerShellSharePoint

  How to revert Modern view back to Classic for SharePoint libraries using PowerShell

  If your customers are anything like ours, some of them love the new modern library view, some will adjust and some just hate it and want to get as far away from it as possible. While embracing the new stuff is usually smart, there's some value to sticking to what works as well. The Modern view is going to be the superior choice of the two (if it isn't already!

  Read more →
• 

  Published on

  2019-03-21 1:52 a.m.

  Authors

  koskila

  Tags

  LocalizationSharePoint

  SharePoint linguistic search features

  I've been posting about different localization/globalization / multilingual options of SharePoint for quite some time. It's a topic that's kind of close to my heart, being a non-English speaker with a really difficult native language - one, that Microsoft always gets wrong even though it's not for the lack of trying! Weirdly enough, while Microsoft messes up the Finnish translation and localization all the time, they do detect and recognize the language surprisingly well.

  Read more →
• 

  Published on

  2019-03-20 9:31 a.m.

  Authors

  koskila

  Tags

  AzureAzureFunctionsAzurePortal

  How to remove Azure Functions without deleting the Functions App?

  Have you ever run into a situation, where you just wanted to remove the currently standing function definitions from your app service without actually nuking the whole Functions app? I have! App Service configuration is usually easy to manage programmatically or by scripting, so even if you need to redo the deployment, it should be fairly straightforward.

  Read more →
• 

  Published on

  2019-03-19 11:13 a.m.

  Authors

  koskila

  Tags

  AspNetCoreEntityFrameworkCorePowerShell

  EntityFramework Core - Update-Database error “The EntityFramework package is not installed”

  Another weird, but simple issue I ran into when building a simple .NET Core application. The article should apply to pretty much any .NET Core version, but the version I was on was 2.2. I was just minding my own business, crafting bits of code into something remotely functional, when I ran into an issue. While trying to apply my changes to the database using .

  Read more →
• 

  Published on

  2019-03-11 10:38 a.m.

  Authors

  koskila

  Tags

  AzureAzureAD

  How to fix "AADSTS90008: The user or administrator has not consented to use the application"?

  A couple of days ago, I got a comment asking how to fix error AADSTS90008 when developing an application using Azure Active Directory The error in question was this: AADSTS90008: The user or administrator has not consented to use the application with ID ‘[guid]’. This happened because application is misconfigured: it must require access to Windows Azure Active Directory by specifying at least ‘Sign in and read user profile’ permission.

  Read more →
• 

  Published on

  2019-03-06 12:50 p.m.

  Authors

  koskila

  Tags

  EFMVCMVC5AspNet

  How to format DateTimes in ASP.NET Core?

  Have you ever struggled to make your ASP.NET MVC views format your properties of type DateTime correctly? I have. And I've been shot in the leg by weird hacks made by both myself (just 6 months earlier) and someone else. .NET Date/DateTime formatting is an endless bag of funsies in general . So I thought I'd finally document the different ways one can set up the formatting of DateTime fields in ASP.NET Core projects specifically. Or at least all the ways I've found so far!

  Read more →
• 

  Published on

  2019-02-27 10:38 a.m.

  Authors

  koskila

  Tags

  ChromeSPEditorGoogleChromeSharePointSharePointSearchQueryTool

  SharePoint Search Console - Now available inside Chrome SP Editor!

  This post is about two of my favorite tools: Chrome SP Editor, and SharePoint Search Query tool. Or maybe better yet, an amalgamation of the two! Description I've mentioned the Chrome SP Editor before, and for a good reason. It's a great tool for any IT Pro or Dev working with SharePoint on a daily basis. It's maintained by a very talented developer, one of the people behind Valo Intranet, Tomi Tavela . If you're using the tool, [let him know on Twitter!]( https://twitter.com/intent/tweet?

  Read more →
• 

  Published on

  2019-02-21 2:22 p.m.

  Authors

  koskila

  Tags

  AspNetCoreNuGetVisualStudio

  Resolving the Version conflicts for a downgraded .NET Core 2.1/2.2 web app project

  I ran into compatibility issues with .NET Core 2.2 on my Azure Functions projects, so I downgraded my whole solution (an Azure Functions project, a helpers library, and a web application project) to 2.1, and got rid of that particular nuisance. This introduced a few new issues, though - namely, I started getting this error whenever trying to restore nuget packages or build the project: NU1107 Version conflict detected for Microsoft.AspNetCore.Razor.Language. Install/reference Microsoft.

  Read more →
• 

  Published on

  2019-02-20 11:21 a.m.

  Authors

  koskila

  Tags

  MsSqlServerSqlQuery

  Easily querying all the database and log file sizes on SQL Server

  Quite often you get the need to simply quickly query all the database sizes on MS SQL Server. Most typically, for me, this need arises when a development machine gets low on disk space, and I need to check if some database's log size has been growing, or if something else is wrong. In my daily work, I rarely encounter this requirement anymore. Azure has almost entirely obliterated the need for such diagnostics, since it's so easy to spin up or scale up new development resources when need be.

  Read more →
• 

  Published on

  2019-02-13 10:18 p.m.

  Authors

  koskila

  Tags

  AspNetCoreEntityFrameworkCore

  Fixing "An assembly specified in the application dependencies manifest [projectname].deps.json was not found"

  This post describes one no-brainer fix to the error "An assembly specified in the application dependencies manifest [projectname].deps.json was not found." I ran into this while running Update-Database for my ASP.NET Core web project , that's using EntityFrameworkCore 2.1.1 . I hadn't seen this one before, but the error was quite interesting: Error: An assembly specified in the application dependencies manifest (Koskila.[projectname].AzureFunctions.deps.

  Read more →
• 

  Published on

  2019-02-06 1:10 p.m.

  Authors

  koskila

  Tags

  ModernSharePointSharePointTelemetrySharePointOnline

  What is "fp.js" - and why is it snooping on your SharePoint usage?

  Microsoft is gathering all kinds of telemetric data out of the usage of SharePoint. I ran into an interesting JavaScript file, fp.js , on SharePoint Online doing just that and gathering data. It loads on pretty much every single page request, so it's something you'll bump into any time you open your developer tools! Your customer's IT might even inquire about it - perhaps wanting to disable it for performance or information security gains. But what is fp.js and what does it do?

  Read more →
• 

  Published on

  2019-02-04 11:59 a.m.

  Authors

  koskila

  Tags

  AspNetCoreGoogleoauthOAuthAspNet

  Google Plus is shutting down - fix your .NET OAuth flow!

  Google is shutting down their Facebook killer, Google+. While I'm sure there are at least 10 end-users that are sad to see the ill-fated not-that-social-medium go, the implications for Software Developers actually could be far more far-reaching. A lot of implementations of Google's OAuth seem to rely on Google Plus's APIs to get gather information about the user. When Google Plus goes down, so will the APIs .

  Read more →
• 

  Published on

  2019-01-29 12:45 p.m.

  Authors

  koskila

  Tags

  PowerShellSharePointSharePointOnline

  Solving yet another "Microsoft.SharePoint.Client.ServerException: Unknown Error"

  There are a thousand possible things that can throw a "Microsoft.SharePoint.Client.ServerException", but fewer things, that are ambiguous enough to be called "Unknown error". This post describes one fairly usual fix for this issue! But let's get back to the beginning for a second - you get what and when now? When running any code, that provisions new sites (much like https://www.koskila.

  Read more →
• 

  Published on

  2019-01-28 10:44 a.m.

  Authors

  koskila

  Tags

  ChromeSPEditorHacktoberfest

  #Hacktoberfest 2018 - a fun way to encourage Open Source contributions!

  This post is about the Hacktoberfest event in 2018. I contributed to Microsoft's repositories and a couple of other ones - and it was a lot of fun! Wow - I'm quite behind on this post, but thought it's worthwhile to give credit where credit is due. Even if that credit comes woefully slowly! In 2018, Microsoft took part in DigitalOcean's Hacktoberfest -challenge.

  Read more →
• 

  Published on

  2019-01-24 11:54 a.m.

  Authors

  koskila

  Tags

  AzureAzureRMPowerShell

  Oh no! PowerShell cached my Azure credentials and I messed up wrong customer's environment!

  Whoops. This could happen to anyone since the Azure PowerShell (approximately) version 6.3.0 will cache your credentials between sessions without warning you. It's really easy to run your commands with cached accounts and end up executing your scripts against the wrong environment. In less serious cases, this means that you'll end up running commandlets twice against the test environment, while you think you're running them first against the test, and then production.

  Read more →
• 

  Published on

  2019-01-17 11:48 a.m.

  Authors

  koskila

  Tags

  PowerShellSharePointSharePointWebServicesSoap

  Fixing "-2147024891, System.UnauthorizedAccessException" when accessing SharePoint SOAP Web Services

  This article explains how to fix error 2147024891 (or sometimes -2147024891), "System.UnauthorizedAccessException" when accessing functionality in SharePoint that's built on top of SOAP Web Services. In a sense, we're delving into some legacy stuff - Microsoft has still kept SOAP-based SharePoint Web Services included in the product, since a lot of functionality has been built on top of them.

  Read more →
• 

  Published on

  2019-01-15 9:26 a.m.

  Authors

  koskila

  Tags

  PHPWordPress

  "500 Internal Server Error" after updating a WordPress site to PHP 7.3

  Now for something totally different - for a change, I got to fix an issue with my own blog, so I had the chance to delve into PHP and WordPress configurations... :) PHP is an ever-evolving language - even if it might not always feel that way. The old workhorse has been powering most of the internet for a couple of decades, and weirdly enough, doesn't really show signs of going anywhere.

  Read more →
• 

  Published on

  2019-01-09 8:52 a.m.

  Authors

  koskila

  Tags

  AzureAzureFunctionsDevEnvironment

  Azure Functions failing on "OPTIONS" call? Quick fix!

  I recently ran into an issue when developing Azure Functions locally. My SPFx webpart was configured to request information from my locally running Azure Function but suddenly started ending up in error. Browser only showed 404 for the first request (OPTIONS) the SPFx webpart was sending - although I knew the function was up and running! So what to do?

  Read more →