SharePoint cat fixing them errors

Subsite creation in SharePoint fails with error 0x80070005 for any user (even global/farm admins!)

Reading Time: 5 minutes. This issue seems to pop up bafflingly often, so I thought it’s finally time to document it for future generations. Granted, it mainly considers Classic SharePoint (which is very tightly built around Publishing features) – but Classic is going to be part of our lives for quite a while still, especially for those of us still primarily on SharePoint Server! While trying to provision subsites to your SharePoint Publishing intranet you encounter either a generic “Access Denied” -error, or any error with 0x80070005 as the underlying error code. Your subsite is not created. This error might surface via the GUI, via PowerShell, […]

SharePoint PnP logo

New-PnPSite fails with “SiteStatus” : 3

Reading Time: 3 minutes. This post was most recently updated on December 4th, 2018.While running “New-PnPSite” or actually any other site creation, method in PowerShell or programmatically, the site creation fails and you get an error like the one below back: New-PnPSite : {"d":{"Create":{"__metadata":{"type":"SP.Publishing.CommunicationSiteCreationResponse"},"SiteStatus":3,"SiteUrl":""}}} Ouch! Where does this come from? In the code of New-PnPSite, the actual function call is shown below: var results = ClientContext.CreateSiteAsync(creationInformation); var returnedContext = results.GetAwaiter().GetResult(); (Source) So, the error is not thrown by PnP cmdlet, but rather comes from SharePoint CSOM. This is pretty normal and not surprising, but means we can’t debug it that much, as CSOM is […]

Broken SharePoint - it's basically an art form

Problematic behavior of web.AddSupportedUILanguage(int lcid) in SharePoint 2013 and 2016

Reading Time: 4 minutes. Every now and then, an API or a method call comes along, that you need to be very careful with. “Microsoft.SharePoint.Client.Web.AddSupportedUILanguage()” seems to be one of them. In this post, I’ll try and document my findings and workarounds for said method!  Issues and solutions Posts Related to “Problematic behavior of web.AddSupportedUILanguage(int lcid) in SharePoint 2013 and 2016”:SharePoint Localization – a (somewhat) comprehensive how-to!SharePoint-Teams -integration using a tabA cautionary tale of relying on the automatic backups in SharePoint Online

Brace yourselves! Notification emails from SharePoint are coming.

Create a new Alert to a SharePoint list

Reading Time: 4 minutes. This post was most recently updated on October 3rd, 2018.Alerts. That magnificent functionality in SharePoint, that let’s you get a heads-up anytime someone touches your precious documents (so you can go and revert the changes), or changes files in Style Library (so you can go and remove that pink custom CSS they tried to add). They are ancient, quite cumbersome and CERTAINLY not pretty, but quite reliable (and despite my expectations – they were included in Modern SharePoint, too!), so there’s really no reason to still keep using them. However, every now and then, they’re quite hidden from the GUI. […]

Something went wrong in SharePoint

Solving “Tenant app deployment is only supported in the app catalog site.” -error

Reading Time: 3 minutes. This post was most recently updated on September 3rd, 2018.Got an error “Tenant app deployment is only supported in the app catalog site. The current site is not the app catalog site.”, even if the current site very much IS an app catalog site? There might be an easy fix! Problem Imagine this: you browse into your fresh SharePoint tenant, open the app catalog, click on an app, try to deploy it, and out comes this error. Tenant app deployment is only supported in the app catalog site. The current site is not the app catalog site. Yes, while trying […]

SharePoint cat fixing them errors

Solving “Sorry, your files couldn’t be uploaded. The upload might be too large or the server might be experiencing high network traffic.” in SharePoint

Reading Time: 4 minutes. This post was most recently updated on October 7th, 2018.This is one of the kind of weird issues that you don’t really run into in your own development environments, but that you more often run into when you actually have non-godlike permissions. Oh, the woes of trying to use SharePoint with anything less than farm/global administrator… 🙂 Anyway, in this post, I’ll describe a couple of solutions to an error: “Sorry, your files couldn’t be uploaded. The upload might be too large or the server might be experiencing high network traffic” You might encounter this issue, when uploading pretty much […]

Let me explain SharePoint

SharePoint Localization – a (somewhat) comprehensive how-to!

Reading Time: 14 minutes. This post was most recently updated on October 6th, 2018.Localization – or showing users with different language preferences content in their preferred language – is not SharePoint’s strongest suite. It never was, and probably will never be, unless Microsoft perfects Machine Translation at some point. And even then it would probably require extra subscription, as Cognitive Services APIs are not available (above the peasant-tier) for free now either. In this article I’ll go through a few survival strategies for multilingual organizations – and I’ll try to expand the content as more options pop up! Please note, that this article revolves […]

SharePoint's broken as usual

How to enable custom scripts for a SharePoint site collection?

Reading Time: 6 minutes. This post was most recently updated on December 4th, 2018.This article explains how to enable custom scripts for any SharePoint site collection. Different instructions and solutions apply to SharePoint Online, and on-premises scenarios (SharePoint 2013, 2016 and probably 2019). Different solutions resolve the issue for different target sites: Modern SharePoint Team Sites (attached to Office Groups) SharePoint MySites Personal OneDrive sites Any SharePoint site collection created based on self-service site creation SharePoint Online tenant root site collection Any Classic SharePoint site collection Errors and causes Most typically I run into this when trying to insert a script web part with […]

SharePoint doesn't work as intended

How to show more than 30 categories in SharePoint blog/news sites?

Reading Time: 4 minutes. Imagine this: you’re using a good old SharePoint blog site, and have a bunch of categories in use. That’s nice and easy – SharePoint offers the categorization functionality natively, and it works decently. Problems arise when you have a lot of categories, though – not all of them will be shown. Even if you tweak the web part to show more items on a page, this isn’t reflected on the whole blog site! This post article explains how to fix this. Problem For background info – the category listing is actually an XSLT list view web part. It’s not obvious […]

SharePoint doesn't work as intended

Opening a web part page in maintenance mode

Reading Time: 3 minutes. This post was most recently updated on July 4th, 2018.Can’t access a web part page because of a broken web part? Yeah, that’s a classic issue – and it’s nicely ported into Modern world, too! In these cases, web part page maintenance mode comes in handy! There’s a query parameter available for accessing it. For whatever reasons, it’s different for Classic and Modern mode, though. Why make things easy if you can make them dificult, right? 🙂  Posts Related to “Opening a web part page in maintenance mode”:SharePoint-Teams -integration using a tabSharePoint Localization – a (somewhat) comprehensive how-to!The effect of […]

Won my first hackathon!

Hackathon win: Resolving Managed Metadata Madness

Reading Time: 6 minutes. This post was most recently updated on March 29th, 2018.I won a hackathon! They had fun topics, it was a cool challenge, a well organized event, and had cool prizes. Since this is the first hackathon I ever took part in, I thought I’d post something about my experience and the solution(s) I figured out. Posts Related to “Hackathon win: Resolving Managed Metadata Madness”:SharePoint-Teams -integration using a tabA cautionary tale of relying on the automatic backups in SharePoint OnlineSharePoint Localization – a (somewhat) comprehensive how-to!

Let me explain SharePoint

How to show a Classic SharePoint page in dialog mode (without SharePoint’s full-blown chrome)

Reading Time: 2 minutes. Classic SharePoint actually has a very handy piece of functionality, using which you can hide most of the SharePoint chrome (like header and navigation), and hence make the page a lot more sleek. This is especially useful for showing the contents in a dialog window – which SharePoint also supports natively through JavaScript! This post describes how. How to show any (classic) SharePoint page in dialog mode? Pretty easy – it’s handled via a url parameter!  Posts Related to “How to show a Classic SharePoint page in dialog mode (without SharePoint’s full-blown chrome)”:SharePoint Localization – a (somewhat) comprehensive how-to!How to […]

How to SharePoint?

Using “DetectedLanguage” to return only localized results from SharePoint Search index

Reading Time: 5 minutes. Localization and targeting of content in multilingual SharePoint installations is always an issue. SharePoint offers a multitude of ways profile content based on user language (or other properties), but none of the solutions are fool proof. This post describes how to fetch only localized results from SharePoint Search index, which solves at least some of the issues. Description  SharePoint Search index can be used in quite a few different ways. Probably the most typical way is by searching on SharePoint, or using webparts like Content Search or Content Results. However, one can also build custom functionality, custom client-side liftups, webjobs, […]

SharePoint is not broken - it just does't work

Web part title changes not reflected to some users in multilingual SharePoint environment

Reading Time: 3 minutes. This post was most recently updated on May 19th, 2018.I encountered another, interesting issue – this time in a SharePoint environment, where multiple display languages were in use. When changing the web part title on a web part on a classic SharePoint page, it seems like SharePoint saves the changes for you. In reality, only some users see the changes. So, in short: Some other users, on some devices, see the old title, whereas some see the new one. It’s a confusing situation and difficult to debug. Why do web part titles get changed seemingly randomly? Imagine this: You have […]

SharePoint PnP logo

How to solve errors about missing PnP Cmdlets on PowerShell

Reading Time: 3 minutes. This post was most recently updated on November 25th, 2018.This blog posts briefly describes how to solve some of the most typical errors about missing PnP Cmdlets when using Windows Powershell (or SharePoint Online Management Shell). Symptoms When trying to run some PnP-related cmdlet, you get an error similar to ones below: Connect-PnPOnline : The term ‘Connect-PnPOnline’ is not recognized as the name of a cmdlet, function, script file, or o perable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try aga in. At C:\Users\koskela\Downloads\Import-Valo-With-Content\Import\New-Valo.ps1:46 char:5 + Connect-PnPOnline […]

Office Group

Site Mailboxes deprecated on SharePoint Online – use Office Groups instead

Reading Time: 2 minutes. This post was most recently updated on October 9th, 2018.Microsoft is deprecating, or even removing one of the widely used features in SharePoint sites – Site Mailboxes. For the end-user this might no mean much, but still requires some additional work from the administration side. In this post, I’m trying to give a rough outline, on what you (as an administrator/content producer) should do. So, what exactly is happening? Posts Related to “Site Mailboxes deprecated on SharePoint Online – use Office Groups instead”:SharePoint-Teams -integration using a tabSharePoint Localization – a (somewhat) comprehensive how-to!A cautionary tale of relying on the automatic […]