Skip to main content


About me

Hi there, I'm John - a technology nerd, travel enthusiast and amateur photographer (translation: I like taking photos of landscapes and nature but not very good at it yet).

I'm lucky enough to be able to wake up each morning, go to work and be part of a team that helps make people's life easier through the use of technology like Azure, Office 365 and SharePoint. As a business analyst, my role is to understand the needs of a business and it's users in order to help address a business objective or pain point through the use of technology.

When not working, I like to travel (or plan/dream about my next trip if I'm not already travelling) and experience new places and cultures around the world. My travel style at the moment is to try and get the most out of the limited budget and time by travelling as smartly as possible whilst attempting  experience the best each place has to offer.

About this blog

I'm new to the world of blogging, but created this blog as a place for me to write about things that I'm passionate about ... technology and travel.

I want to use this blog to share things I've learnt throughout my journey in life from little gotchas from technologies that I'm currently using or tips and lessons I've learnt from my travels. I hope it helps you in some way or another whether you came here for technology, travel or both.

I also want to use this blog as an opportunity to improve my writing skills, so any feedback and suggestions.

Feel free to contact me if you have any questions or feedback.

The not so small prints:

  • The views and opinions expressed in my posts are my personal views alone and not that of any other organisations that I may be associated with.
  • If you would like to use content from this blog (full blog posts or photos), please contact me to ask for permission first. Alternatively, sharing or excerpts of content can be used if it is clearly attributed to this blog (via a link to

Affiliate, sponsored links or contents

For the most part this blog will be paid for using my own money. However from time to time, I may add an affiliate or sponsored link/content into this blog to help subsidize the cost of running this blog (expenses either related to keeping this blog online and costs associated with putting content together).

However be rest assured that any sponsored or affiliate content/link that I place in this blog are here because I:
  • have personally seen, used or experienced the product/service and/or
  • really like using the product and/or 
  • think it will bring value to people reading this blog
In the interest of transparency I will be clear inside any page or posts that contain links or content that contains perks or benefits to me. These will either be identified beside the link and/or flagged at the beggining or end of the post.

My current affiliate channels are:

  • is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon offers a small commission on products sold through their affiliate links. Each of your purchases via our Amazon Affiliate link supports our cause at no additional cost to you.

Popular posts from this blog

SharePoint | Set default value of date field to last day of the month

One of the things, that I needed to do recently is find a way to set the default value of a date field to the last day of the month. Though some content were really helpful in getting me on the way to solving the problem, I thought I'd post the formula required to make it easier for others looking to do the same in the future. What I wanted to do  The steps below describe what I wanted to achieve: User uploads a file into a document library A date column will automatically be populated with the date representing the end of the month (calculated based on the date the file was uploaded) How do we do this? Open your column settings for your date field Under the Additional Column Settings, set the default value option to Calculated Value Enter the the formula below: =(DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY("1-Apr-2008"))) - (1) Click save and that's all you need to do What does the formula above do? The formula above is quite simple.

Uploading a file from a SharePoint document library into an Azure Blob Storage with Microsoft Flow (or Logic App)

The Problem One of the things that I've been experimenting with lately is Microsoft Flow . The service allows you to build process automation to facilitate transfer of information from one system to another easily. One scenario I wanted to try out is to be able to copy/move a file from SharePoint to an Azure Blob Storage. There are a number of reasons that you may want to do this: Archive files that are no longer needed Upload a copy of a file (usually an image) into a Blob Storage so that images can be hosted in a CDN to optimize page load performance In the past doing something like this would have required some form of custom development e.g. a remote event receiver. However the introduction of Microsoft Flow and Logic Apps has created another alternative that is worth exploring.... Update 30/09/16:  If you are looking to put your assets into a CDN to make it load faster, then it's worth checking out the new Preview Release  Office 365 Public Content Delivery

Only show a control to an employee's manager in PowerApps (using SharePoint as a data source)

The Problem In my previous blog post , I wrote a basic tutorial on configuring PowerApps to conditionally show/hide and make mandatory/optional a control based on the answer provided in a previous control. In this blog post we will expand on that scenario to create a form that only shows a control called approval status to a user if that logged in user is the manager of the user specified in the employee control. This means when the manager is using the application, they can change the status to approved. Meanwhile, a user that is not a manager of the person specified in the employee cannot change the status to approved. The Solution Aside from containing a variety of native functions, PowerApps also allow us to add connections to add functionalities into our app. In this case we will add the Office 365 Users connection so that we can get information on: The user that is logged on The manager of the user specified in the employee control Note: Whilst this soluti