Sending Birthday and Work Anniversary Emails to employees - Issue with dates

[leeleeisfree]

Hello, 

I have successfully created both a birthday and anniversary flow to be emailed to employees on their birthday and work anniversary. However, the flow is also sending it to individuals who have similar but not exact dates. 

For example:

John Doe's birthday is today 1/5 (January 5th) the flow emailed him as well as Mary Smith who's birthday is 5/1 (May 5th) how do I keep it from doing that? 

I've attached how I've set my date format up as well as my condition. The first output in the condition step is "set month" and the second is "set date" 

Thank you!! 

Date FormatSplitSet MonthSet DayCondition

[Expiscornovus · Accepted solution]

Hi @leeleeisfree,

My guess is that you need to apply some datetime formatting to the birthday values. Can you show a bit more details of your flow. For instance a screenshot of your condition action?

Btw, this Power Automate blog from @AlanPs1 has some good expression examples on how to use formatting with birthday fields.

The approach is basically:

formatDateTime(body('Get_user_profile_(V2)')?['birthday'], 'MM-dd')

equals

formatDateTime(utcNow(), 'MM-dd')

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Send-A-Happy-Birthday-Email-Messag...

[annajhaveri]

@leeleeisfree can you please share the screenshot of the flow to see where exactly the issue is, there must be something wrong related to data you are fetching for birthdays/anniversaries.

[leeleeisfree]

I have edited my post to include screenshots. Thank you so much!!! 

[leeleeisfree]

I have edited my post to include screenshots. Thank you!!!! 🙂 

[annajhaveri · Accepted solution]

@leeleeisfree , as @Expiscornovus  has suggested, please modify your condition as follows:

on left side

formatDateTime(items('Apply_to_each')?['DOB'], 'MM-dd')

on right side

formatDateTime(utcNow(), 'MM-dd')

so your condition will look as follows: