In this article, we will discuss how to create and send birthday wishes emails to employees using Power Automate flow.
Microsoft Power Automate is a service that helps you create automated workflows between your favorite apps and services to synchronize files, get notifications, collect data, and more.
We are going to create an employee birthday record in SharePoint and then we will create a flow to automate the emails.
Steps to be Followed
Open your SharePoint web page and tap on “Create a new list”. Create columns as shown below and add Employee details.
![]()
Open the Power Automate on a new tab using https://make.powerautomate.com/ or you can directly open it through SharePoint by clicking on Integrate – Power Automate – Create a Flow
Once you open the Power Automate
1) Click on Scheduled Cloud flow
![]()
2) Now add the Flow name and make the setting according to your requirement about when the flow should be run.
![]()
Scheduled Cloud Flow has some predefined Settings which are
- Recurrence
- Apply to each
![]()
- Get items
![]()
In Compose you can write this expression
formatDateTime(utcNow(),'MM-dd')
Now you can add condition and Send an email options and complete the flow and save it.
Now click on Test and you can check if the flow is running successfully
![]()
You can check if your condition is true or false for the flow to be run successfully and get an email notification.
In this way, your employee will receive email notifications in Outlook
![]()
I hope this article helps, so this is how you can create a Birthday flow and you can use the flow to send many wishes or events.