cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarkH1
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 

1 REPLY 1
ScottShearer
Super User
Super User

@MarkH1 

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.

Scott

Helpful resources

Announcements
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)