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”

Automating the submission of WordPress Blog Posts to your Microsoft MVP Community Activities Profile using PowerShell

13th of February, 2018 / / No Comments

Introduction

In November last year (2017) I was honored to be awarded Microsoft MVP Status for Enterprise Mobility – Identity and Access. MVP Status is awarded based on community activities and even once you’ve attained MVP Status you need to keep your community activity contributions updated on your profile.
Up until recently this was done by accessing the portal and updating your profile, however mid last year a MVP PowerShell Module (big thanks to Francois-Xavier Cat and Emin Atac) was released that allows for some automation.… [Keep reading] “Automating the submission of WordPress Blog Posts to your Microsoft MVP Community Activities Profile using PowerShell”

How to set Property Bag values in SharePoint Modern Sites using SharePoint Online .Net CSOM

8th of February, 2018 / / 1 Comment

If you think setting Property Bag values programmatically for Modern SharePoint sites using CSOM would be as straight forward as in the Old Classic SharePoint sites, then there is a surprise waiting for you.
As you can see below, in the old C# CSOM this code would set the Property Bag values as follows:

The challenge with the above method is that the PropertyBag values are not persisted after saving.… [Keep reading] “How to set Property Bag values in SharePoint Modern Sites using SharePoint Online .Net CSOM”

Automating the creation of Azure IoT Hubs and the registration of IoT Devices with PowerShell and VS Code

5th of February, 2018 / / No Comments

The creation of an Azure IoT Hub is quick and simple, either through the Azure Portal or using PowerShell. But what can get more time-consuming is the registration of IoT Devices with the IoT Hub and generation of SAS Tokens for them for authentication.
In my experiments with micro-controllers and their integration with Azure IoT Services I often find I keep having to manually do tasks that should have just been automated. So I did. In this post I’ll cover using PowerShell to;

  • create an Azure IoT Hub
  • register an Azure IoT Device
  • generate a SAS Token for the IoT Device to use for authentication to an Azure IoT Hub from a Mongoose OS enabled ESP8266 micro controller

IoT Integration

Prerequisites

In order to fully test this, ideally you will have a micro-controller.… [Keep reading] “Automating the creation of Azure IoT Hubs and the registration of IoT Devices with PowerShell and VS Code”

On-demand, Scaleable VPN Access to AWS

3rd of February, 2018 / / No Comments

Recent growth in our Managed Services business (driven in part by our acquisition by Telstra) has meant that a number of tools and processes that we have previously taken for granted have had to be re-assessed and re-architected to allow us to scale and maintain the same level of service at low costs.
One particular area that we’ve recently reworked is how we remotely access and administer workloads within customer’s AWS environments. Previous methods of access leveraged either static bastion hosts or VPN endpoints and they worked well up until a point, but after analysing at the overall footprint of resources used and costs incurred by doing so, it became clear to us that we needed to find a better way.… [Keep reading] “On-demand, Scaleable VPN Access to AWS”

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”

Export/Import SharePoint Designer Workflows using PowerShell

24th of January, 2018 / / 3 Comments

Background

Your organisation is using SharePoint as a collaboration and productivity platform, and your business units have built their solutions on it. As part of business solutions, IT teams have built workflows using SharePoint designer to cater business needs. One of the challenges developers or IT professionals used to have is how to export and import this workflow to other SharePoint sites in case if you are having multiple environments like Dev, Test, UAT and Prod.… [Keep reading] “Export/Import SharePoint Designer Workflows using PowerShell”

A modern way to track FIM/MIM Attribute Value History utilizing Power BI

20th of November, 2017 / / No Comments

Introduction

Microsoft Identity Manager is fantastic for keeping data consistent between connected systems. Often however you want to know what a previous value of an attribute was. FIM/MIM however can only tell you the current value and the Management Agent it was received on and when.
In the past where I’ve had to provide a solution to either make sure an attribute has a unique value forever (e.g email address or loginID (don’t reuse email addresses or loginID)) or just attribute value history I’ve used two different approaches;

  • Store previous values in an SQL Table and have an SQL MA that flows out the values
  • Store historical values in a Multi-Valued attribute on the user object in the Metaverse

Both are valid approaches but often fall down when you want to quickly get a report on that metadata.… [Keep reading] “A modern way to track FIM/MIM Attribute Value History utilizing Power BI”