SharePoint PnP logo

How to fix Add-PnPApp failing with an Access Denied error

Reading Time: 3 minutes. This was a peculiar case! An issue I hadn’t run into before, and luckily a disturbingly simple fix. But first, let’s set up the scene. We were running a long-ish PowerShell script using a Global Administrator account. One part of the script was supposed to add and deploy a couple of SharePoint apps. But while running Add-PNPApp, we ran into errors: Add-PnPApp -Path $path -Scope $app.Scope -ErrorAc… , Error: {"error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access denied. You do not have permission to perform this action or access this resource."}}} Oh. That’s… A bit surprising for a Global Administrator, right? What’s causing this? Posts Related […]

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 […]

In other news in Simpsons: SharePoint Search stopped indexing some properties again.

Issues with User Profile Property visibility in Search-powered functionalities

Reading Time: 3 minutes. This article applies to a lot of different issues you might be having with your SharePoint-powered site, or even custom functionality like mobile apps using SharePoint’s search index. I’ll list a few of the situations, which could be caused by these issues, below: You’re using Search to show a list of User Profiles with their properties, but it’s showing outdated or missing information Your intranet has the classic “Upcoming Birthdays” -webpart (only weather and lunch lists are more classic than that!) This webpart is not showing some of the organization members at all. The aforementioned webpart might also show nobody […]

"PictureThumbnailURL" configuration in SharePoint Online Search Schema

“PictureThumbnailURL” always null in SharePoint Online Search results

Reading Time: 2 minutes. This post was most recently updated on November 23rd, 2018.We’ve been observing an issue in SharePoint Online’s Search Index, where the Managed Property “PictureThumbnailURL” is always null, no matter what values the crawled properties it’s mapped to might contain. The issue seems to have first appeared a few months ago. The first time we encountered it was maybe around July, 2018. Microsoft probably made some changes in SharePoint Search schema, and the property “PictureThumbnailURL” wouldn’t get values anymore. Pre-existing values were conserved, though. All things considered, this does not seem like an intentional change. Posts Related to “”PictureThumbnailURL” always null […]

"Get-UnifiedGroup" cmdlet produces a list of your Office 365 Groups with some default properties shown

How to fix an Office Group with no Owners

Reading Time: 6 minutes. This post explains how to add new Owners to your Office Groups using PowerShell. If your group has ended up without any owners, PowerShell might even be the only option, since the graphical user interfaces for Office Groups management are not that good.  Background The hype around Office Groups kind of died down a little bit a while back, since their role wasn’t that clear – they didn’t really do much, and were confusing for end users. Back then, I posted about them replacing Site Mailboxes in SharePoint Online – because that was the first very visible and kind of […]

SharePoint is not broken - it just does't work

Help! My “Content and Structure” page in SharePoint Online is gone!

Reading Time: 5 minutes. This post was most recently updated on November 27th, 2018.First of all: you’re right and your eyes are serving you well. It has indeed disappeared. Starting in October, it’ll be hidden from end users. Microsoft is retiring the “Site Content and Structure” tool in SharePoint Online. Which kind of makes sense, since it’s quite an old feature – albeit, a very useful one. How to access “Content and Structure”? Even though Microsoft is retiring the Content and Structure tool, and has already hidden it from the UI, it’s still accessible. That’s supposing you had access to it in the first place […]

Antti K. Koskela's session at SharePoint Saturday New England - thanks for the photo, https://twitter.com/kkhipple !

Thanks for coming to my session at SPS New England 10/20 !

Reading Time: 2 minutes. This post was most recently updated on November 20th, 2018.I had the privilege of speaking at SharePoint Saturday New England in Burlington (near Boston) on 20. of October. Thanks for the super active crowd! A lot of difficult (e.g. good) questions and great conversations. Posts Related to “Thanks for coming to my session at SharePoint Saturday New England 10/20 !”:Thanks for coming to my session in SPS Nashville!Materials for my SPS TC session: “Citizen Developer Tools are not just for Citizen Developers” now…Thanks for coming to SPS Houston! Check out the slides and demos 🙂

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

Ignite 2018 recap: What’s new for Azure Functions?

Reading Time: 4 minutes. Ignite 2018 is done and dusted, and it’s a good time to quickly recap what’s new for Azure Functions in the coming months. They’ve certainly been getting a lot of love from Microsoft, which is GREAT! New features for Azure Functions There was a bunch of exciting new things announced! Not all of the things in this blog post are necessarily completely new – but rather reached General Availability. Let’s go through them one by one… Posts Related to “Ignite 2018 recap: What’s new for Azure Functions?”:SharePoint-Teams -integration using a tabGetting Connect-MsolService (and other Azure Active Directory PowerShell cmdlets) to […]

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

The following functions are in error... And that's about it.

Fixing “The following functions are in error: Object reference not set to an instance of an object.” error in Azure Functions

Reading Time: 3 minutes. Let me start this article, by reminding everyone that Azure Functions are awesome, and you should use them despite some hiccups. Having said that, let’s fix some errors! In the beginning of September 2018, Microsoft started pushing out breaking changes to Azure Functions 2.x. They had announced this a full month in advance, so they expected everyone in the world to update their Azure Functions to avoid the functions from breaking. I guess, however, that in real life, a month is not that much. Me, and a bunch of other people on the internet, ran into some issues with our […]

Azure Functions SDK 2.0 settings in accessed in C# code

How to access Azure Function App’s settings from C#?

Reading Time: 4 minutes. This post was most recently updated on November 19th, 2018.Different versions of Azure Functions have different ways to access the Azure Function settings. This is another little thing, that I always forget – so better document it somewhere! So, this post describes, how you can access the function’s Application/Environmental settings/variables from your C# code. Posts Related to “How to access Azure Function App’s settings from C#?”:SharePoint Localization – a (somewhat) comprehensive how-to!SharePoint-Teams -integration using a tabPrivacy Policy

Let's fix SharePoint Search together!

How to interpret SharePoint’s view count managed properties (like “ViewsLast1Days”)?

Reading Time: 6 minutes. Have you ever wondered, how SharePoint’s Managed Properties for Usage & Analytics info actually work? There are all these nice properties available for getting view counts for different items in SharePoint’s search index, but they all seem to act like crazy. And they are pretty nonsensical… And not very well documented! In this post I’ll try to make some sense on how you can use them in programmatic scenarios. Read on… Posts Related to “How to interpret SharePoint’s view count managed properties (like “ViewsLast1Days”)?”:SharePoint Localization – a (somewhat) comprehensive how-to!Privacy PolicyGetting Connect-MsolService (and other Azure Active Directory PowerShell cmdlets) to […]

PowerShell header

Properly checking if an item in a folder is a Directory or not in PowerShell

Reading Time: 4 minutes. Got a great tip from a colleague, on how to properly check if an item is a file or a directory. In one case, we weren’t really ever sure, if another script had finished its running and unzipped a certain zip package into a folder – and we had to verify it had, before continuing the execution. Our initial implementation worked most of the time… But not quite always. The purpose of this blog post is to explain how we found a pretty well working and elegant solution! Problem In this particular case, we were testing items for being directories […]

Requests to WsaUpload.ashx showing up on the Network -tab of your browser

Disabling requests to WsaUpload.ashx (Customer Experience Improvement Program)

Reading Time: 7 minutes. This post was most recently updated on September 17th, 2018.So, I’ve gotten this question from a lot of customers and partners, and I thought it’s worth clarifying the case a bit. “I’m seeing a lot of requests these requests to WsaUpload.ashx. What do they matter? They seem to degrade the performance – so what can I do about them?” That’s a great question! Let’s see what it is, why it exists, and what we can do about it! Posts Related to “Disabling requests to WsaUpload.ashx (Customer Experience Improvement Program)”:SharePoint Localization – a (somewhat) comprehensive how-to!A cautionary tale of relying on […]

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. […]

Get-MsolServicePrincipalCredential - how to get the expiration date for a clientId

Fastest way to verify your Client Id and Client Secret are valid with PowerShell

Reading Time: 3 minutes. This post was most recently updated on August 13th, 2018.So, you have a Client Id and a Client Secret, but don’t know if they work anymore? Maybe they are expired? Maybe someone removed them? No worries! We can use PowerShell to validate them easily! Solution By using PowerShell, it’s fairly straightforward to verify, that your Client Id and Client Secret work. See the snippets below for 2 different steps: First we validate, that the values work. If they don’t, let’s run another script to see if the Client Id exists but has expired. Validate your Client Id by trying to […]

PowerShell header

How to get the user count for Azure AD Enterprise Application

Reading Time: 3 minutes. This post was most recently updated on October 9th, 2018.Have you ever tried to find out the number of users of an enterprise application in your Office 365 tenant? This could be needed for multiple different reasons: maybe your organization is paying for the app and you want to know who’s actually using it, maybe the usage is required by a company policy and it’s useful to know if organization’s members are actually using it, or maybe you just want to know about the user adoption of an app. For apps with under 100 users it’s easy – just open […]

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 […]