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.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,979)