Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Anniversary emails | How to calculate date

Hi folks,

I need to send an e-mail when an employee has reached a 1, 3, 5, 7 and 10 year anniversary.

Can someone help me work out how to calculate this based on sample data below? Hire date is available.

Sample data 

Super User
Super User


You'll start with a recurrence trigger.  The Flow should run once a day and check for any entries that meet your criteria.  The rest depends on where you data is stored.  You may end up with a Flow for each of your criteria (1 tear, 3 year, etc.) or you may end up with a single Flow.

If you can tell me where you data will be stored I can be more specific.



If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helper I
Helper I

Hi Mark I have the same problem. Data source is Sharepoint list. Can you help?

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,591)