Send a Happy Birthday email to employees using Microsoft Flow in SharePoint Online

Send a Happy Birthday email to employees using Microsoft Flow

This Microsoft flow tutorial explains, how to send a Happy Birthday email to employees using Microsoft Flow in SharePoint Online Office 365. We will get to know how to use Microsoft flow template Send wishes to employees by email as per the birth date in SharePoint list.

Check Out Microsoft Flow and PowerApps Training Course (Lifetime Access)

Microsoft Flow: Send Happy BirthDay Email to Employees

In this particular example, we will maintain a SharePoint list to maintain employees information and then we will create a Microsoft flow to send happy birthday email using Microsoft flow.

SharePoint deveopment training course

Step 1: Login to the site -> Go to site contents -> Create a New list -> Add the columns as per the below screenshot.

send happy birthday email using microsoft flow
send happy birthday email using microsoft flow

Step 2: In top of the ribbon, click on Create a flow . You will redirect to flow template page.

Send wishes to employees by email as per the birth date in SharePoint list
Send wishes to employees by email as per the birth date in SharePoint list

Step 4: Choose the template ” Send wishes to employees by email as per the birth date in SharePoint“.

microsoft flow example Send wishes to employees by email as per the birth date in SharePoint list
microsoft flow example Send wishes to employees by email as per the birth date in SharePoint list

Step 5: Next it will verify your credential to go next page. Once it gets verified, click on the continue button to redirect next page.

microsoft flow send happy birthday email
microsoft flow send happy birthday email

Step 6: Here SharePoint will automatically create your template so we need to modify it as per the requirement. Before going anywhere, We need to set the Recurrence for a reminder.

First of creating a Recurrence action that will trigger an event to run at regular time intervals. In my case I want it to run once every day.

Send a Happy Birthday email to employees on their birthday microsoft flow
Send a Happy Birthday email to employees on their birthday microsoft flow

Step 7: Next I create a Compose that returns a function value “@adddays(utcnow(), 7, ‘yyyy-MM-dd07:00:00Z’)” (remember to put the function within quotes or else it won’t work).

Now that I have today’s date + 7 I can run Get items on the approved content SP List with an OData filter, which only returns items where NextReviewDate equals to the Compose Output (utcnow() + 7) and the Representative is not equal to null.

or

You can add the different function like “@equals(substring(item()?[‘DOB’], 0, 10),utcnow(‘yyyy-MM-dd’))’.

Automatically Send Greeting Email on Birthdays using Microsoft Flow
Automatically Send Greeting Email on Birthdays using Microsoft Flow

Step 8: Add the condition and put the Email ID inside TO field in Send an email.

Automatically Send Greeting Email on Birthdays using Microsoft Flow
Automatically Send Greeting Email on Birthdays using Microsoft Flow

Step 9: Test the flow and check the flow returns the value true or false. If it returns true then it will trigger an email otherwise it won’t trigger, you will get an error message on Send an email action.

Microsoft Flow: Send Happy BirthDay Email to Employees
Microsoft Flow: Send Happy BirthDay Email to Employees

Step 10: Now that you have the list items, add an Apply to each step which loops all the items in the Get Items step, and then runs the Send an email step which sends an email to the representative of each item. Below is the email I received as my DOB is same as system date.

Send Happy BirthDay Email to Employees using Microsoft Flow
Send Happy BirthDay Email to Employees using Microsoft Flow

You may like following Microsoft Flow:

Hope this SharePoint tutorial explains, how to use Send wishes to employees by email as per the birth date in SharePoint list Microsoft flow template. And also, we will see how to send a happy birthday email using Microsoft flow.

Check out Best Alternative to InfoPath -> Try Now

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

About Rajkiran Swain

Rajkiran is currently working as a SharePoint Consultant in QATAR . Rajkiran having 6 + years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).

View all posts by Rajkiran Swain →