Office 365, PowerShell

Flow and Azure automation working in harmony

Hi all, please see my latest blog post on Flow & Azure automation working in harmony. It’s truly awesome.

Office 365, PowerShell

Adding a user to a group in office 365 using PowerShell

This article will walk you through how to add your Office 365 Users to an Office 365 Group.

There are a few pre-requisites to do this. One of which is having ‘Windows Azure Active Directory Module’ installed on your machine. Second, that you are an Administrator.


I have 10 users who I would like each to be added to an Office 365 Group. I’m a little too lazy to add one by one so I’ll look to do this with Powershell.

So first up I’ll need to create the group to add my 10 test users into.

From the Office 365 admin centre click Groups, click the + for this demo. I’ve created a group called  ‘Test Security Group’ and as you can see from the screenshot below no users have been added.



Below is a screenshot of the users I will be adding to the security group.











OK so now we have our users & group we need to open up the Windows Azure Active Directory Module for Windows PowerShell

Once the powershell window is opened you will need to connect to your tenant. To do this type-


You will then be prompted to type in a tenant administrators username/password combination to proceed.

Once authenticated we need to get the ID of the group. Easy.

$groupid = Get-MsolGroup | Where-Object {$_.DisplayName -eq “Test Security Group”}

This line is finding a group that matches the Group Display Name of “Test Security Group” and putting it into the $groupid variable.

We can now leave the group for now. It’s time to start getting the users id’s in order to add to this group.

As I have a large number of users in my directory I conveniently named the users test1 to test10. Because of this I will get these users and put them to a variable so I can extract the information needed to add these users to a group.

$users = Get-MsolUser | Where-Object {$_.DisplayName -like ‘*Test*’}
It’s important to note that I am only filtering the users as I don’t want to add all users in the domain to this Active Directory. You can add and filter as you please.

It’s now time to add the users to the group. We are going to use the $users variable and run a foreach loop which will iterate through each user and grab it’s ObjectId and add to the security group.

$users | foreach {Add-MsolGroupMember -GroupObjectId $groupid.ObjectId -GroupMemberObjectId $_.ObjectId -GroupMemberType User} AddingUser

Depending on how many users you’re adding in bulk it may take a couple of minutes so be patient. Once it run’s, check back to your group and see if the users are added.



You can download the full script here

Office 365, SharePoint Online

Using Office 365 Video for the first Time

Microsoft Office 365 have recently added the Video Functionality to their subscriptions a cool new set of features indeed, but a new adventure of learning that is needed – hopefully this blog post can assist with the learning.

Depending on your Preview status options in your Microsoft Tenant you may not have the Video feature available to you:

To turn on the Preview option please follow this blog post:

Expand the new Top Nav display button and click Video , if you click the elipses button (…) you can pin to nav bar !



Your video page will start to load for the first time so this may take a while (Up to 10minutes)





Once Completed you will receive this nice Welcome Message , click Let’s go


One of the first things to note is the URL of the Video Portal



So let’s create our first Channel

Click the Create Channel Button , Give your channel a name and color:

Click Create


Once created you can now upload videos and share with your Security Groups, SharePoint Groups or even unauthenticated users(everyone)

Which I will take you through in my next blog post.


Additionally,  I found the below link an informative look into the new Video Portal


Office 365, SharePoint Online

Hide OneDrive link from Navigation

A common question that I am asked on a daily basis is how can we hide ‘One Drive’ or ‘Newsfeed’ from the Top Navigation bar?

Well Thanks to an update a few month’s back it’s now extremely simple to do so:

Browse to:



Scroll down to the bottom of your page  Save your changes and you are done

Office 365, SharePoint 2013, SharePoint Online, Uncategorized

Bulk updating a column in SharePoint Online

Ever had this situation where you need to bulk update a specific column in a list or library, you have 100’s or even 1000’s of items and need to set the same information for all the items, although rare I’ve seen it needed and while there may be a couple of way’s to do it here is a little application I have put together to do so.

I have this test library in my site collection, I’d like to update the title column to all be the same, let’s now use the Bulk Updating Column Console App to do so.

You can find the Application uploaded to the TechNet Gallery here , which has the source code for those wanting to see the nuts and bolts to it all ( there isn’t whole lot to it!

Please note you will need the SharePoint Online Management Pack installed or else the App will error




1. Open the Console Application Executable;

2. Enter in the following info:

  • Your site collection URL
  • Your username
  • Your Password
  • The List Title you would like to interact with
  • The Column Name you would like to update
  • The columns new valueConsoleFirstScreen

The App will begin to run and update the specified column for all List Items,


The Application will run and  update the Column accordingly –


And we’re done 🙂

Office 365, SharePoint, SharePoint Online, Uncategorized

Setting up Record Management in SharePoint Online Part 1


In order to setup records management and the ability to create send-to connection and rules there is a few steps you will need to follow, it can be confusing initially but once you wrap your head around the different configuration location it starts to make sense.


  1. Activate the Content Organizer site feature, the Content Organizer feature is a very important feature that should be enabled on any site where Send to connections are to be used, without this feature enabled any attempt to create the send to connection will fail with a correlation ID which on SharePoint Server is easy to work out but a little more difficult to work out in SharePoint Online.

Be sure to activate this feature not only at the from location but the destination as well as the send to connection will error if it is not enabled.


  1. Once the feature is activated you will need to head to your Site Admin page for those new to O365 and SharePoint online it’s


  1. Select Records


  2. Once you are on the Send to connection page you will need to fill in a few of the details necessary to start routing the documents


    Display Name – is the field that on the send to connection in the SharePoint ribbon this will be seen to the end user


    Send To URL – this field is very important to enter in correctly you must enter the site url along with “/_vti_bin/officialfile.asmx” or else the send to connection will error on creation.




  3. Click Add Connection


  4. Now when I select a document in my document library my newly created send-to connection comes available as shown below, so what happens if we try to move this document now?


    The Page will refresh with Operation completed successfully message along with the new url of the document, by default the documents are routed to the ‘Drop off library’ in Part 2 I will take you through setting up rules to have the documents moved to a specific document library at your selected destination site.


Office 365, SharePoint, SharePoint 2013, Uncategorized

A pat on my own back

Today I successfully passed the PRO: Microsoft SharePoint, Administrator (70-668) exam which gives me the fancy title of MCITP SharePoint 2010.. which I must admit I am more proud of then I let show…. although it’s taken me a few years to get the time to study and sit the exam it has been all worth it not only for the nice fancy new title but since I passed the SharePoint 2013  Core Solutions exams, I am now on an upgrade path to my MCSE leaving me two exams to go 🙂

Advice to all that are aiming to achieve the SharePoint Administrator PRO Certification before it’s discontinued… it’s worth it don’t let anyone stop you !