web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send email for Work An...
Power Automate
Unanswered

Send email for Work Anniversary

(0) ShareShare
ReportReport
Posted on by 93
Hi
 
I have a list that contains a column for entry of duty for the employee.
 
I need a flow that send an email to employee when he/she has 5 years, 10 years, 15 years and 20 years Work Anniversary.
 
This flow should be worked on daily basis 
Thank you
Liquid error: Exception has been thrown by the target of an invocation.Liquid error: Exception has been thrown by the target of an invocation.Liquid error: Exception has been thrown by the target of an invocation.
Categories:
  • jinivthakkar Profile Picture
    4,187 on at

    @alhilo This is what I would try, create 4 more columns lets say 5years,10years,15years,20years.

     

    One time activity - Then run a flow which will iterate through each entry and calculate the dates for 5,10,15,20 years and update values in the 4 columns created earlier.

     

    Use add to time action and you select years as required.

     

    jinivthakkar_0-1611220485173.png

     

    and we would have one more flow which would do the same when a new entry is created, so this would take care of future entries.

     

    Next, have 4 schedulers flows for each anniversary(making it separate so it is easy to debug/troubleshoot) which would run daily and simply check if todays date match date with dates in 5,10,15,20 column values.

     

    If it matches then send email to the specific associate.

     

     

    /*gets today's date */
    formatDateTime(utcNow(),'yyyy-MM-dd') /*gets formats UTC*/
    
    /*get dates from anniversary column and format */
    formatDateTime(outputs('Get_item')?['body/MeetingTime'],'yyyy-MM-dd') /*formats dynamic date*/

     

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

     

    Liquid error: Exception has been thrown by the target of an invocation.Liquid error: Exception has been thrown by the target of an invocation.Liquid error: Exception has been thrown by the target of an invocation.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard