Roland Oldengarm - Independent IT Contractor

Living in the coolest little capital Wellington, New Zealand!

Author: rolandoldengarm (page 1 of 6)

How we have made our Angular 2 website multi-language

I’m part of the startup YouJustGo and we are currently targeting the Chinese market. Our site is built in Angular 2 and we wanted to have our site in two languages, English and Chinese. I’ve done most of the technical work in this space, to get the site working in both languages, and I would like to share my experience.

Continue reading

Microsoft Teams: My experience so far

When I heard about Microsoft Teams, I was very excited from the start. I’m using Slack a lot for GitHub projects and for some internal projects, as there is no alternative in Microsoft. Teams is positioned as a Slack competitor, and when it was available as public beta, I immediately contacted our Office 365 admin to enable it. I’ve been using it for a couple of weeks now, and I want to share my experience with you!

Continue reading

Angular 2: Automated i18n workflow using gulp

Update: New post can be found here.

i18n (internationalization) support for Angular 2 is now built-in the framework. Previously we used ng2-translate, but I found it time-consuming to add all translations manually to the .json files. Since a week or so the documentation is also available at While useful, it did not provide information, it involves a lot of manual steps. I’m going to provide a set of Gulp tasks that will automate everything!

Continue reading

Part 3: How to embed a Power BI report in SharePoint with the SharePoint Framework

In this final post of the series “How to embed Power BI in SharePoint”, I’m going to show you how to embed a PowerBI report in SharePoint, using Power BI Embedded and the SharePoint Framework! All new technologies, so exciting times 🙂

Continue reading

A new era in SharePoint development: The SharePoint Framework (spfx)

Announced at the “Future of SharePoint” event, was the SharePoint Framework. And it is in public beta since this week! I was one of the lucky persons who had access to the internal repository, so I already had a play with it before. Unfortunately I could not blog about it, as it was under NDA. I will talk about how it will fit into the existing SharePoint development infrastructure, and start with some history 🙂

Continue reading

How to deploy your SharePoint artifacts like content types, site columns, lists, and much more

This blog post is aiming at developers that are looking for a solution to deploy SharePoint artifacts from code. Sure, you can do all of this by hand via the SharePoint user interface, but that is not repeatable.

In SharePoint 2007 the recommended solution was to use the feature framework. However, that had (and still has) one big disadvantage: It is hard to upgrade existing sites. FeatureUpgradeActions were introduced in SharePoint 2010, but it is still a manual job.

In 2016, the feature framework has been deprecated in favor of using CSOM / SSOM. I’m going to look at the framework we are using for most of our SharePoint projects to make this a breeze: SPMeta2.

Continue reading

How to know the sentiment of an email BEFORE reading it

Imagine you want to know the sentiment of an email without reading it. This can be useful if you want to ignore negative emails for certain parts of the day. I have built a solution for that, by integrating Azure Machine Learning in an Office Outlook Add-In. Every time you read an email, it processes the body, sends it to Azure, and displays if it is negative or positive Continue reading

How to: Send an email if a Salesforce opportunity is won using Microsoft Flow

After my blog post yesterday about Flow, I got a request from a user to build a Flow for Salesforce that does something when an Opportunity is closed, and checks if it was won or lost.

I love feedback, so I decided to build that flow. The result? Check out below email:

Continue reading

A first look at Microsoft Flow: IFTTT on steroids

If you’ve followed my blog, you know I’ve been looking at PowerApps. PowerApps consists of two parts: Flows (formerly Logic Flow App) and just Apps. Flows allowed you to do things like “If someone tweets about my company, send me an email”, or “When a record is added to SalesForce, add an item to a SharePoint List”. Microsoft has now taken out Flows / Logic Flow Apps, and released it as a separate product: Flow. I think this is a good step, PowerApps can then focus on enabling power users to create mobile apps. I will briefly discuss what Flow is, and show an example of an automated tweet translator emailer. Continue reading

Part 2: Embed a Power BI Report in a SharePoint Site

This is part 2 of the blog post series: How to embed a Power BI Report in SharePoint. Please check Part 1, where I’ve shown how to embed a Power BI report in a provider hosted add-in. In this part I will show you how this report can be added to SharePoint as a custom web part. I’ve also improved the solution I built in Part 1, for example it’s also possible to embed an entire report, and not only one tile. All source code is on GitHub.

Continue reading

Older posts