Export and Import Site Collection Term Groups using PnP PowerShell

Managed metadata allows the creation of central managed term sets that can be used as attributes in SharePoint sites, term sets can be created globally and shared across site collections or can be created locally to the site collection.

The PnP PowerShell includes commands to export and import terms groups but unfortunately the site collection term group is not exported automatically, this article provides a workaround to get all the site collection term sets into an xml ready to import into other site collections.

(more…)

Fix most common issues with SharePoint Import Spreadsheet functionality

Every once in a while, I stumble across SharePoint functionalities that are only available when using Internet Explorer, on this post I’ll explain you how to overcome two common issues when trying to import a spreadsheet into a SharePoint list.

If you are dealing with the error messages below this post is for you.

Save Site as Template - SharePoint

(more…)

What’s new for SharePoint from Microsoft Ignite

The third edition of Microsoft Ignite occurred from 25 to 29 of September in Orlando, Florida and had 26 000 attendees, for SharePoint it was an amazing week with a lot of new features being announced, if you hadn’t the opportunity to attend the event in this article you will find a resume of the announcements.

SharePoint is growing more than ever and Jeff Teper made it clear with the announced numbers, over the last 12 months the number of users and organizations that joined SharePoint is higher than the last 12 years. Check down below what will be the features that will continue to bring more users to get on board with the platform.

(more…)

How to add Google Analytics to SharePoint without modifying the master page

Google Analytics is the most widely used web analytics service in the internet, it provides a concise analysis with reports of everything that happens in your site as well as real time reports, mostly targeted for public sites it also works on intranets.

Intranet portals are the central hub of companies; important information is communicated to employees through these portals and you need to make sure that everyone can access to it no matter the device or technologies used.

Analyzing your intranet portal will help you to understand how users interact with it, what are the most viewed sites and what sites do you need to improve.

Add JavaScript File

(more…)

Customize SharePoint from Mac OS

Create and edit SharePoint files form Windows is simple with SharePoint Designer but if you are a Mac user, you are in though spot!

You can do pretty much everything from the browser but upload a file every time you want to change CSS is a tedious process.

In this article, I’ll explain how you can save time and how you can get access to all the files and folders needed to customize SharePoint sites from your Mac.

Open SPD folder

(more…)

Can you still use sandbox solutions in 2017?

The answer to this question is yes, but… not for all situations and not all types of sandbox solutions.

SharePoint sandbox solutions were introduced with SharePoint 2010 and provided a mechanism to execute code outside of the ISS worker process. The sandbox solutions do not affect the entire farm; they are installed per site collection and they can be installed by the site collection administrator.

Every day I deal with SharePoint users that are extremely afraid of using sandbox solutions mainly because the message about this type of solutions being deprecated was not properly communicated by Microsoft.

sandbox solutions in 2017

(more…)

Create a modern breadcrumb navigation on SharePoint

Breadcrumb navigation was available by default on SharePoint 2007 and 2010 but with the introduction of SharePoint 2013 it was removed and until today it wasn’t reintroduced.

Today I’m revisiting one my most read articles, back in 2013 I wrote an article to explain how this functionality can be added again to SharePoint and judging by the number of views this article still has there’s a lot of people trying to get the breadcrumb back.

The method from the previous article is still valid but it requires you to manually modify the master page, if you are not going to customize the layout of your site there’s no need to mess with it.

SharePoint Breadcrumb

(more…)

How to solve the most common issues on SharePoint Designer

If you work with SharePoint at this point you’ve probably realized that SharePoint Designer is one of your best allies but still is a bit temperamental and sometimes it just refuses to work properly.

In this article, I’ll cover the most common issues and how to fix them.

Fix SPD issues

(more…)

Fix publishing pages with custom page layouts created from template

This article is a continuation of my previous article that explains how to save publishing sites as templates.

Per the feedback received some people was not able to access the sites created with the template, this happens with sites that include pages with custom page layouts.

Before getting into details about how to fix this please notice that the previous article is a hack to save the site as a template, save site as a template is disabled in all Publishing sites and other type of sites with publishing features active, this means that the hack may not work in all SharePoint scenarios.

Page layout template error

(more…)

How to fix 401 error after applying a custom master page to SharePoint

This is a short article but it can save you precious time when you apply a custom banding to your SharePoint site.

After applying a custom master page to the site some pages or all of them may start displaying a 401 error, this happens on collaboration sites and system pages namely Team Sites where you have minimal download strategy feature activated.

Fix SharePoint 401 error

(more…)


I've been working with Microsoft Technologies over the last ten years, mainly focused on creating collaboration and productivity solutions that drive the adoption of Microsoft Modern Workplace.