Report of All Taxonomy Fields containing a term in SharePoint Tenancy

24th of April, 2018 / / 1 Comment

Recently we had a request to find fields/columns in all lists across the tenancy which have a specific Taxonomy term because we needed to report on field usage across all site collections. However, we found that getting a report of all Taxonomy fields in your SharePoint tenancy that is linked to a specific Term Set can get quite daunting because there is no direct SharePoint Query to fetch the associations.
The technical challenge is that using PnP PowerShell, the Taxonomy fields are returned as a generic SP.Field… [Keep reading] “Report of All Taxonomy Fields containing a term in SharePoint Tenancy”

Promoting and Demoting Site pages to News in Modern SharePoint Sites using SPFx extension and Azure Function

23rd of April, 2018 / / No Comments

The requirement that I will be addressing in this blog is how to Promote and Demote site pages to news articles in Modern SharePoint sites. This approach allows us to promote any site page to News, add approval steps and demote news articles to site pages if the news need to be updated. The news also shows in the modern news web part when the site page is promoted.
Solution Approach:
To start with, create a site page.… [Keep reading] “Promoting and Demoting Site pages to News in Modern SharePoint Sites using SPFx extension and Azure Function”

Creating SharePoint Modern Team sites using Site Scripts, Flow and Azure Function

16th of March, 2018 / / No Comments

With Site Scripts and Site design, it is possible to invoke custom PnP Provisioning for Modern Team Sites from a Site Script. In the previous blog, we saw how we can provision Simple modern sites using Site Scripts JSON. However, there are some scenarios where we would need a custom provisioning template or process such as listed below:

  • Auto deploy custom web components such as SPFx extension apps
  • Complex Site Templates which couldn’t be configured
  • Complex Document libs, content types that are provided by JSON schema.
… [Keep reading] “Creating SharePoint Modern Team sites using Site Scripts, Flow and Azure Function”

Microsoft Teams Q&A

15th of March, 2018 / / No Comments

This page is a collection of Microsoft Teams and Skype for Business related questions and answers. It’s regularly updated as more information becomes available.
Microsoft Teams Q&A – Last Updated: 15th March 2018
Q: What is Microsoft Teams?
A: Microsoft Teams is a complete communications platform, that takes the best bits of Skype for Business, Yammer, SharePoint, Email and other web sources and presents them in one easy to use application. You can send IM’s, make voice and video calls, phone calls, Share documents, and collaborate all from within the one application.… [Keep reading] “Microsoft Teams Q&A”

Create Modern Pages and update metadata using SPFx Extensions, SP PnP JS and Azure Functions

13th of March, 2018 / / 3 Comments

Modern Site Pages (Site Page content type) have a constraint to associate custom metadata with it. In other words, the “Site Page” content type cannot have other site columns added to it as can be seen below.
SitePageContentTypeMissing
On another note, even though we can create a child content types from Site Page content type, the New Site page creation (screenshot below) process doesn’t associate the new content type when the Page is created. So, the fields from the child content type couldn’t be associated.… [Keep reading] “Create Modern Pages and update metadata using SPFx Extensions, SP PnP JS and Azure Functions”

Update Managed Metadata and Hyperlink column in a SharePoint list using PnP PowerShell

7th of March, 2018 / / No Comments

If you are trying to update a Managed Metadata and Hyperlink column in SharePoint online using PnP PowerShell and it is not getting updated, then this blog might be of help.
I had been working on a quick requirement for updating Managed Metadata columns using a PowerShell script for a bulk update requirement and it was not working as planned. The managed metadata column we were updating didn’t have the right format of Term store hierarchy and this was the cause of the issue.… [Keep reading] “Update Managed Metadata and Hyperlink column in a SharePoint list using PnP PowerShell”

Intro to Site Scripts and Site Designs with a Simple SharePoint Modern Site provisioning

6th of March, 2018 / / No Comments

Microsoft announced Site Scripts and Site Designs in late 2017 which became available for Targeted release in Jan 2018, and released to general use recently. It is a quick way to allow users to create custom modern sites, without using any scripting hacks. Hence, in this blog we will go through the steps of Site Scripts and Site design for a Simple SharePoint Modern Site Creation.
Before we get into detailed steps, lets’ get a brief overview about Site Designs and Site Scripts.… [Keep reading] “Intro to Site Scripts and Site Designs with a Simple SharePoint Modern Site provisioning”

Migrate SharePoint contents using ShareGate

27th of February, 2018 / / No Comments

Background

The first step in any migration project is to do the inventory and see what is the size of the data you have got which you are looking to migrate. For the simplicity, this post assumes you have already done this activity and have already planned new destination sites for your existing content. This means you have some excel sheet somewhere to identify where your content is going to reside in your migrated site and every existing site (in scope) have got at least a new home pointer if it qualifies for migration.… [Keep reading] “Migrate SharePoint contents using ShareGate”

Writing for the Web – that includes your company intranet!

20th of February, 2018 / / No Comments

You can have a pool made out of gold – if the water in it is as dirty and old as a swamp- no one will swim in it!

The same can be said about the content of an intranet. You can have the best design, the best developers and the most carefully planned out navigation and taxonomy but if the content and documents are outdated and hard to read, staff will lose confidence in its authority and relevance and start to look elsewhere – or use it as an excuse to get a coffee.… [Keep reading] “Writing for the Web – that includes your company intranet!”

Quick start guide for PnP PowerShell

1st of February, 2018 / / 2 Comments

It is quite easy and quick to set up PnP PowerShell on a local system and start using it. Considering that PnP PowerShell has been gaining a lot of momentum among Devs and Admins, I thought it would be good to have a post for everyone’s reference.
So why PnP PowerShell? Because it is the recommended and most updated PowerShell module for IT Pros to work on SharePoint Online, SharePoint on-premise and Office 365 Groups. It allows us to remotely maintain a SharePoint Online and Office 365 tenancy as we will see below.… [Keep reading] “Quick start guide for PnP PowerShell”