Using flow for a selective auto responder

Arjan Cornelissen
This week I got the question from my client that they wanted an autoresponder on one mailbox. This autoresponder should only send an email when certain criteria where met. After searching on the internet, they could not find a solution in Exchange, so they came to me if I could help them. My first response was that it should be possible, but the options in Exchange online are limited and responding was not an option.

Working with dates in Microsoft Flow

Arjan Cornelissen
In my journey of using Microsoft Flow, I had some frustration this week on working with dates. The problem we had is as follows, with the sending of the emails, the dates are in UTC. To make it usable, we needed to convert it to our time zone. Convert date and time to a time zone For this Microsoft has built-in functions like “convertFromUtc”, this function converts the input date from UTC like a SharePoint date to any time zone.

Creating standardized emails from flow

Arjan Cornelissen
This week I had to convert a few dozen Nintex workflows to Microsoft flow for a migration we are doing. Most of these workflows had some sort of email to a department or an external vendor. The default Exchange email connector can handle HTML but you need to add the HTML to the email body. Adding the header and footer to every email can be done, but maintaining this is a nightmare so we did some thinking and came up with this solution.