Flow: Send A Happy Birthday Email Message To Everyone In Your Organisation

Quite regularly I hear requests that centre around wishing users a Happy Birthday within an organisation. There is an extremely popular template within the Flow template gallery that does just that, it is called "Send a Happy Birthday email to employees on their birthday" and it uses a SharePoint list. It work's really well, although sometimes date formats can become an issue for the Flow implementer when they are imported from the list. Also, the organisation's users need to be added to the list itself in advance. Whilst that isn't a huge chore for most people, below is a process that requires no list and will send an email to every enabled user in your O365 tenant at 9am on the day of their birthday.

Sound, interesting?

Well, read on and follow the steps and you too will be able to implement this process.

Your email will look like this.

Pre-requisites: You will need a suitable Office 365 group. This may be an "All Users" group or a segmented group that only has users who have agreed to recieve such an email. Maybe it's a group that omits the CEO or those who may not celebrate their birthday. I will leave that to you to decide, but in this example a pre-configured "All Users" group is in use.

Here is the complete Flow.

Read More

Flow: WDL – Use Multiple Functions to Make Interesting Expressions

In this post, we will once again reference back to part 8 – Call O365 Roadmap Web Service Weekly Digest where we have sent Microsoft 365 Roadmap updates via email.

The email body contains some interesting expressions and use of several nested functions using WDL, Workflow Definition Language.

A full reference on WDL can be found at this link.

Here is the section of the Flow that I am referring to:

Firstly, let's break down the expressions in the second row of the table, the one that looks like this:

And here is the code …

Read More

Flow: HTML Email Customisation with CSS

Back in part 8 – Call O365 Roadmap Web Service Weekly Digest you will see that we are generating the last 7 days worth of updates from the Microsoft 365 Roadmap and we are sending them as a weekly digest. The emails look like below:

I like them, they are well laid out and mostly readable but there are some values missing so once I got to adding them I realised the lay out and the styling required some thought. So now I am working with an output that looks like this:

Whether or not one is better than another is elementary in this post. I am going to show you the changes I had made in order to present the email in this way.

Here is a look at the relevant completed section now that the changes to the HTML & CSS have been made:

Read More

Call Office 365 Service Communications API and Return New Service Health Notices – Part 3

Here is how I have managed to return the latest Service Health alert (only) from Office 365 "Office 365 Service Communications API".

Office 365 New Service Alert Email

As any O365 admin will know, Microsoft won't offer an inbuilt alert that will notify you by email when a new Incident arises so here is how I have chosen to get round that and here is a sneak peek of the output:

Firstly, we will need to register an app in Azure AD. Please see Register an App in the Azure Active Directory for instructions on how to do that.

Read More