web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Birthday - Send a remi...
Power Automate
Unanswered

Birthday - Send a reminder 3 days before date of birth

(0) ShareShare
ReportReport
Posted on by

Hi there,

 

I hope my email finds you well.

I am trying to create a flow.

I want to send a reminder 3 days before the date of birth of an employee.

This flow should run everyday.

 

I have attached some screenshots for your review:

 
Compose1:
formatDateTime(outputs(
'Compose'),'dd-MM'😞
 
Delayuntil:
addDays(outputs('Compose_1'),-3,'2022-01-01 12:30:00Z')
 
Flow - Delay Notification Birthday 3 days before 5.pngFlow - Delay Notification Birthday 3 days before 4.pngFlow - Delay Notification Birthday 3 days before 3.pngFlow - Delay Notification Birthday 3 days before 2.pngFlow - Delay Notification Birthday 3 days before 1.png
Flow - Delay Notification Birthday 3 days before 5.png
Flow - Delay Notification Birthday 3 days before 3.png
Flow - Delay Notification Birthday 3 days before 4.png
Categories:
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Babac 

     

    Since you are running the flow everyday - why you need to do delay the flow until last 3 days - you can check whether the number of days b/w flow execution date and given date of birth of employee and see whether it is 3 days or not , if it is 3 days , Then send a email reminder to notify the flow.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • Srini007 Profile Picture
    3,490 Super User 2026 Season 1 on at

    Hi @Babac 

     

    For making it simpler, after getting the Items from Sharepoint list

    Format the date value as below by a compose action

    AddDays('YourDateOfBirthdayValue', 3, 'dd-MM')

    Above will convert your sharepoint list value of employee to Date and Month by adding 3 days to that

     

    Now place a condition and write as below

     

    Your compose Value is equal to formatDateTime(utcNow(), 'dd-MM')

     

    Now place a send mail action in Yes block

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Cheers,

    Srini

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @Babac 

    Instead of using the Apply to Each action to loop through all items in your SP list and run a condition check on each item to see if their anniversary date is today—it's much more efficient to use a Filter Array action. This way you can filter out the items returned from your SP list first before you loop through them. 

     

    I cover how to do that in this YT Tutorial: Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

     

    In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

     

    This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

    📅 Student Birthdays

    📅 Project Due Dates

    📅 Contract/Membership Renewals

    📅 License Expirations

    📅 Client Anniversaries


    IN THIS VIDEO:

    ✅ How to Send an Email based on a Date Column in SharePoint

    ✅ Using the Recurrence Trigger in Power Automate

    ✅How to Use the Filter Array Action with multiple conditions

    ✅ How to Get Dynamic Content from a Filter Array Action

    ✅How to Get a Date Three Days from Today

    ✅ How to Create a Dynamic Date Based on utcNow()

    ✅ How to Return a Count of Items

    ✅ How to initialize and set a variable

    ✅ How to use the Send an Email (V2) action

    ✅ How to send test emails

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard