Send wishes to employee on birthday flow

[Abrahams1]

Hi, my flow runs successfully but does not send mail. Any help?

[RobElliott]

Hi @Abrahams1 I think you should be comparing today's date utcNow() with the actual birthdate in the SharePoint list. If they are the same then send the email. But you don't seem to be doing that. Have a look at the blog post at https://www.enjoysharepoint.com/send-happy-birthday-email-to-employees-using-microsoft-flow/ which might help you.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[ScottShearer]

@Abrahams1 

I agree with the commenst made by @RobElliott 

In addition, you might try looking at the output of Get items in one of your runs.  Scroll down and take a look at the actual data returned for the calcBday column.  Make sure what is returned matches the value to which you are comparing.  In other words, do the formats match?

[v-bacao-msft]

Hi @Abrahams1 ,

If the employee's birthday recorded in the list contains the year, then you also need to format the date into a consistent format.

Like:

Best Regards,

[Abrahams1]

Thank you all for your help so far. Currently, the flow sends mail to the recipient but picks everybody in that month and not the day.

A formatting error?sharepoint column

[AKRogers]

@Abrahams1,

That error on the condition in your screenshot is happening because, for some of the items, there isn't an actual value.  You can avoid this by adding more conditions to handle nulls, something like this: 

 In my example, the condition I care about is the first line and the second line is simply there to make sure I'm only checking the condition where that particular field isn't empty.

Ashley

If you found this helpful, consider giving it a thumbs up!

[v-bacao-msft · Accepted solution]

Hi @Abrahams1 ,

First, we can ignore the error that appears in Flow. That is because the specified field value is empty, so the formatDateTime() function cannot be executed, but it does not affect the filtering of the correct items.

Try changing MM-DD-YYYY to MM-dd, or you can refer directly to the screenshot in my previous post.

Best Regards,