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 

2 REPLIES 2
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
Jtaylor95
Helper I
Helper I

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

Helpful resources

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