Requirement: To create a send Happy Birthday email to employees maintain a SharePoint List to maintain employees information, and then create a Microsoft flow.
Create a new list “Birthday Wishes” add columns as per the below screenshot.
send happy birthday email using microsoft flow
Send wishes to employees by email as per the birth date in SharePoint list
Create a Power Automate flow
+Create> schedule flow > provide name> create button
Click on next, select the “Get Items” action.
In the get items box provide the site url and select list name as “Birthday Wishes”
eq = equals
ne = not equal to
lt = less than
le = less than or equal to
gt = greater than
ge = greater than or equal to
In the filter query :
DOB ge ‘ concat(formatDateTime(utcNow(),'1993-01-16'),'T00:00:00Z')’ and DOB le ‘concat(formatDateTime(utcNow(),'1993-01-16'),'T23:59:59Z')’
Click on Next Step and find and select the “Apply to Each” action.
In “Apply to Each” box set value from previous output
Inside “Apply to Each” box Click on Next Step and find select the “Send an Email V2” action.
Set the email address from the output of “apply to each” Email Column and set the subject and email formatting as per your needs.
Click on Save and Run the Flow
To test the flow, click on the Test button from the right side of the top menu and click the Run flow button. Then click the done button and verify the email
Expected output
