Send Birthday Wishes Using Power Automate

Introduction

 
In this article we will learn about automating birthday wishes via email through Power Automate.
 
Step 1
 
Create a list called "Birthdays" 
 
Step 2
 
Inside the list create the columns as follows,
 
Send Birthday Wishes Using Power Automated
 
Step 3
 
Go to https://flow.microsoft.com/
 
Click on Scheduled--from blank
 
Send Birthday Wishes Using Power Automated
 
Step 4
 
After clicking a pop up will appear, click skip
 
Send Birthday Wishes Using Power Automated
Step 5
 
In the search box, search for recurrence and select recurrence
 
Send Birthday Wishes Using Power Automated
 
Step 6
 
In the Recurrence box set interval to "1" and Frequency to "Day" and fill in other choices as per your need, but I am making all other fields as blank
 
Send Birthday Wishes Using Power Automated
 
 
Step 6
 
Click on next, find and select the “Get Items” action.
 
Send Birthday Wishes Using Power Automated
 
Step 7
 
In the get items box provide the site url and select list name as "Birthdays"
 
In the filter query
  1. DOB ge datetime'@{concat(formatDateTime(utcNow(),'yyyy-MM-dd'),'T00:00:01Z')}' and DOB le datetime'@{concat(formatDateTime(utcNow(),'yyyy-MM-dd'),'T23:59:59Z')}'
Where inside datetime contents are added in (add dynamic content--->Expression)
 
Send Birthday Wishes Using Power Automated
 
Step 8
 
Click on Next Step and find and select the “Apply to Each” action.
 
Send Birthday Wishes Using Power Automated
 
Step 9
 
In "Apply to Each" box set value from previous output
 
Send Birthday Wishes Using Power Automated
 
Step 10
 
Inside "Apply to Each" box Click on Next Step and find select the “Send an Email V2” action.
 
Send Birthday Wishes Using Power Automated
 
Step 11
 
Set the email address from the output of "apply to each" Email Column and set the subject and email formatting as per your needs.
 
Send Birthday Wishes Using Power Automated
 
Step 12
 
Click on Save Flow.
 
Step 13
 
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 (however it automatically works on a daily basis).
 
Step 14
 
Expected output
 
Send Birthday Wishes Using Power Automated
 

Conclusion

 
Hence we learned about how to automate birthday wishes using power automate (Formerly MS Flow). I hope this helps someone, and happy coding.