Skip to main content


Top 8 things to do in Sydney for travellers on a budget

Recent posts

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 onThe manager of the user specified in the employee controlNote: Whilst this solution makes it difficult for …

An intro to conditional validation and formatting in PowerApps (using SharePoint as a data source)

The Problem What if we need to create a form that changes it's behaviour based on the answer entered by the user.

For example, we need to build a leave request form that: Shows the comment field if applying for a sick leave, but hides the comment field if applying for a annual leaveRequires the requestor to write a comment if their sick leave is more than 1 day, but is optional if sick for just 1 day.  The default form interface for custom lists in SharePoint Online can be used for basic scenarios, but doesn't provide an easy way to add business logic described above (unless you want to write some javascript)

In the past InfoPath would have been the tool of choice for many, however this tool is now in maintenance mode and whilst it will still be supported for a wee while there will be no improvements or enhancements to the platform.

The Solution This is where PowerApps come in. PowerApps is now the platform that is recommended by Microsoft as a way for business users to create…

Hiking around Rotoroa Island - stunning day trip from Auckland

Summary: Feeling the need to get away from the hustle and bustle of the city life? Rotoroa Island is a small island that is just over an hour's ferry ride away from the Auckland CBD, and is a perfect getaway offering picturesque beaches, walking trails and native animals.

The island is less popular compared to it's cousin and as such in a lot of cases it feels like you are in your own beautiful private island in the middle of nowhere.

Play the video above to get a preview of the island
Rating: 5/5 - One of Auckland's best kept secrets

Getting there: 75 minute ferry ride from Auckland's Ferry Terminal. A morning ferry drops passengers off and picks them up at the end of the day.

Time: 3 -5 hours worth of walking tracks + a few hours of lazing/swimming in the beaches.

Distance: 10km

Difficulty: Easy. (Some steepish inclines and/or slippery gravel terrain so bring shoes with good grip)

Facilities: Toilet, barbecue, drinking water and mobile phone coverage are available. However …

Travel tips - Sydney on a budget

Travelling in Sydney can be expensive, here are some tips that have really helped keep the cost of my trip low.
Sydney Harbour YHA - The Rocks is one of the best hostels I've ever stayed at, especially in terms of it's location in a prime neighborhood and the views that are on offer from it's deck.

Cost: Approx $40 - 50 AUD per night
Distance from public transportation: Approximately 10 minutes walk to Wynard station
Wi-Fi: Free in common area

Tip: You can reduce your per night cost to as little as $23 AUD per night by buying in bulk (via the YHA ePack). It is worth noting that you can stay a maximum of 3 nights at each hostel. I personally liked the hostel so much that I was willing to pay the normal price so that i can stay there for the whole week.

It is recommended that you buy an Opal Card because: There is a daily cap on the maximum you will be charged (as of today this is set to $15 per day maximum between Monday to Saturday, $2 per day on…

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 neededUpload 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 Network (CDN) capab…