I have a share point list "Employees" and I would like to send an email reminder 3 days before and event occur like the birthday or a contract renewal. Both dates are in the past so that is why is getting tricky to figure this thing. I mean for the birthday we are now interested in the year just to match mm/dd with today's mm/dd, and the same for the contract renewal.
So I have created this complicated SPL where basically I am extracting the MM/dd from the birthday and Hire date and the MM/dd from today's and comparing values making an IF Statement. The problem is Sharepoint doesn't update a calculate field so my Current date keeps in the date that was saved or updated. I have tried many ways and none of them works.
So, to summarize contract flow and BirthdayFlow will appear 4 days "Yes" until both days are exactly i.e 12/21 eq 12/21 that condition plus if active2 = Yes, will trigger the flow.
I can't get this to work for the SPL side, I have tested and I can get the email reminder but if I update the SPL.
Someone could point me in the right direction?
Thanks in advance,
First, if your TodayMD column is a calculated column, it won't get updated unless you edit and save each individual item.
There are a number of different solutions to your issue. Can you tell me how many items are in your list so that I might suggest the appropriate solution?
Hi @ScottShearer , I have changed the structure a little bit, and I am getting an email reminder but only in the day of the event.
So, could you please advise how can I add a condition to check 3 days in advance?
DOBMD = 12-22
Returns an integer, 1 to 366, that represents the sequential day of the year in datetime or expression. The DAYOFYEAR function uses the Gregorian calendar.
So, to check if DOB is 3 days ahead do this:
This will probably be 1 day off in leap years, but you can adjust your flow those years if you want to :).
the way I implement to sent a birthday reminder is the following:
* I have a sharepoint list where the birthdate is kept in text format
* every day I run a flow that takes this birthdate minus the year, so I only keep mm/dd
* this is evaluated with today() + 5 (send a reminder 5 days in advance)
*if this is true I add the first and last name to a variable
* later on I check if this variable contains any characters, if not it's nobody's birthday in the next 5 days and I terminate the flow. If yes, an email is send to the rest of the team informing them of a birthday coming up
Flow 1 = Send an email reminder for Birthday \ Not working!
Flow 2= Send an email reminder for Contract Renewal \ Not working!
Flow 3= Send a Birthday Card. | Working !!!!
The send an email reminder for a birthday and contract renewal I would like to happens 3 days before the day of the event, 2 days and the day of the event.
And also I have changed my SPL to get both values DOB and HireDate with this format MM-dd. don't know if this helps but having the format MM/dd flow was complaining.
Now I am stuck again don't know how to add that condition for the birthday reminder and the contract renewal.
Thanks in advance for any help.
Hello @KoenM ,
Related to your message in this topic. Could you please be so kind and describe a little more specific the last point "send to the rest of the team...". I have very simillar situation but i can't handle how to exclude the birthday celebrant from recipient list.
I use a double condition to check if the member of my list has a birthday, else he's on the "others" list.
condition birthdayboy: if today() = DOB
condition others: if today() != DOB
you can change today() to today()+5 if you want a 5 day advance notice
if condition birthdayboy = true --> append email address to varBirthdayboy
if condition others = true --> append email address to varOthers
ultimately check if varBirthdayboy != empty, then send the email to varOthers
Loop this every day for every member and you will have to variables when someone's birthday is coming up. Only send a warning to the others list, the birthdayboy will probably know his birthday is coming up 😉
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.