Forum Discussion

Sophielamp's avatar
Sophielamp
Copper Contributor
Oct 13, 2020

Create birthday reminders from Sharepoint List

Hi there,   I am trying to create reminders for staff birthdays and work anniversary's two weeks before they are due. I have tried using the reminders feature however I understand this will only tr...
Microsoft Flow
PowerApps
sharepoint
  • Kelly_Edinger's avatar
    Kelly_Edinger
    Oct 13, 2020

    Hi Sophielamp - you may want to start with a SharePoint calculated column to get the 2 week reminder date - less coding in the flow.

     

    Then I'd do a scheduled flow that runs daily to see if that column = today, if true, send email. You may want to consider adding a variable so that the birthday only gets sent as day/month as the year may add some PII legal implications or just have everyone born in 1999 🙂

     

    Hope that helps!

VipassanaMahale's avatar
VipassanaMahale
Copper Contributor
May 19, 2022

Hello, Sophielamp You can try AnnounceBot which is available in MS Teams. It's a trending and useful app to onboard new team members and wishes them on their birthdays, anniversaries, and special occasions. Get automated reminders of birthdays and send wishes with one click
Here is their website link if you wish to know more about he bot >> https://announcebot.in/ 

I hope this is helpful 🙂

 

Resources