Last video from the set of exclusive interviews at MSIgnite – don’t miss it

MSIgnite – final video from the set of exclusive interviews


MSIgnite Day 2 – part 2 – hear some of the most interesting event interviews you’ll ever see

MSIgnite Day 2 – part 2 – hear some of the most interesting event interviews you’ll ever see


Day 2 at MSIgnite – insightful interviews you won’t find anywhere else

Day 2 at MSIgnite – insightful interviews you won’t find anywhere else, for sure!


My first day at MS Ignite 2015

I thought I’d share how the first day looked like at ignite … more to come tomorrow with some fun interviews and more


What’s SharePoint Online Video Portal all about?


Important steps to take if you’re running multilingual variations in SharePoint Online

The other day I described an issue where all of your Web Designer Galleries disappear. That article also suggested how to address this issue but the solution was short terms for me as I got the same problem next morning exactly at 10AM, and the morning after, and after … luckily I was able to “fix” the issue with my handy PowerShell script I wrote in the previous post. But what is the root cause?!?!?!

Well, the root cause is this;

-My site is running English and French variations
-This created two sub sites under root, one for English and one for French

The key to further discovery was the fact that the issue occurred exactly at the same time, therefore it must be a timer job.

Then someone sent me this article: Turn scripting capabilities on and off

Which basically says that there is this new cool feature allowing you to disable whole bunch of authoring functionality on the site with a simple toggle. It also says that this runs as a scheduled process every 24 hours.

You guessed it … I went down and turned off the default setting and things didn’t break the next morning.

1. Go to Admin Center | Settings:


2. Next turn off the Self-Service-Created sites toggle to “Allow”

step 2

Turns out that variation sites are Self-Service-Created sites and this settings messes them up. So, we’re down to either not using this new setting or not using variations. Well there is always an option for MS to fix the issue – but I’m not going to hold my breath for that – however, I have reported the issue to Premier Support so we might be getting some action.



Want to update your SharePoint app site logo without code?

With SharePoint 2013 and SPO, you get apps and often apps have their app site.
When you update your site custom look – all the apps get the same look and feel, there is just one problem – the logo you update on the root site doesn’t get updated on the app site.

Here is my custom logo on the root site:

main site logo

Here is how does one of the app site look like:

app site logo

There is no settings menu to change that but here is what works:

1. Navigate to the root of your site and click on “Title, Logo ….” under “Look and Feel”
2. Copy the URL of the settings page (second part as shown below) … /_layouts/15/prjsetng.aspx

app url

3. Change the logo on the page there and save the settings, result ….

new logo on the app site

Now your apps match your site, duh 😉



Quickly turning your Content Query Web Part display into a jQuery tabs

In summary, the goal is to turn something that looks like this:

content query default display

to this:

jquery tab links

There are many ways to do it, and I very deliberately said “quickly” in the title of this post, implying that you won’t need to mock around XSL of the Content Query Web Part.

Here are the steps:

1. First we’ll create a list which is going to hold our data

The list data structure will be:

  • Title – Single line of text
  • Link Description – Single line of text
  • Link Grouping – Single line of text
  • Link – Hyperlink or Picture

Here is how this list looks like, hopefully yours is more useful than my list of cities:
list of cities

2. Next, we add a Content Query Web Part to the Page with the following configuration:

  • Source set to my list
  • link source

  • Grouping set of my special column which holds groups (countries)
  • link grouping

  • Display are defaults with few columns you may want to display
  • renderign columns

3. Save the configuration and verify that your display looks similar to this:

content query default display

4. Add a Script Editor Web Part on the page where your content query resides with the following code in it:

<link rel="stylesheet"

<script src=""></script>
<script src=""></script>
$(function() {
var tabCount = 0;
$(".dfwp-item div.groupheader").each(function() {
$("#tabs ul").append("<li><a href='#tabs-"+tabCount+"'>" + $(this).text

$("#tabs").append("<div id='tabs-"+tabCount+"'>"+"<p>"+$(this).parent

tabCount = tabCount+1;

<div id="tabs">

5. Save the web part and the page and ….

jquery tab links

6. If you want to be a good practices developer – you need to download jQuery tabs and upload jquery and jquery ui artifacts into the library on your SharePoint site rather than referencing them as I did from …

What the code above does is that it takes the content of the Content Query Web Part and wires it into tabs; then hides the original CQWP content.

There, wasn’t that easy?



Have your Web Designer Galleries been all of the sudden gone in SharePoint Online?

I ran into a really annoying issue recently, here were the symptoms:
-Users with full control and even site collection administrators were not able to add content editor web parts onto pages
-Administrators were not able to see “Web Designer Galleries” in their site collection settings


If you have publishing features enabled – then this section was showing up with the only option of “Master pages and page layouts”

I won’t spend much time explaining how I got to the solution – I will just give you the solution and then add some speculation at the end on what might have caused this.

If you’re using SharePoint Online as I was using run the following commands in SharePoint Online Management Shell:

$userName = ""
$password = "MyPassword"
$siteCollectionUrl = ""
$siteAdminUrl = ""
$securePassword = ConvertTo-SecureString $password -AsPlainText -force
$O365Credential = New-Object System.Management.Automation.PsCredential($username, $securePassword)
Connect-SPOService -url $siteAdminUrl -Credential $O365Credential

$rootsite = Get-SPOSite("")


If the response you get from the last command is “Unknown” or “true”
Then run this command:

Set-SPOSite -Identity "" -DenyAddAndCustomizePages $false

Here is a bit more details:
First off, this post ( sent to me by Fred Downing got me thinking … what if Microsoft intrioduced a new property on a site collection and didn’t set the default – so the code that runs and checks for property block update if the property is not set to $true.

After digging around and finding the undocumented property, I switched it’s value and it worked.

Hopefully it will save someone long hours, Enjoy!