
@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.
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.