Unanswered

Happy Birthday Email

(0) Share

Report

Posted on by dger

Hello,

I'm trying to create a simple list with name, birthday, and email, that will automatically send a happy birthday email. I tried following several different tutorials, but there is always a problem. Mainly, I don't see the flow template they say to use. Nothing about birthday will show up in searches and I went through all the flows under 'email' and found nothing related. There is no search on the sharepoint page where the list is. Why can't I find the flows they used to do this?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@dger

See my example below. I am storing my data in a SharePoint list. The expression that I use in the Get Items action can be seen in the notes. Note the single quotes around the expression.

Was this reply helpful? Yes No
dger 6 on at

Like (0)

Report

Hello Scott, thank you for your reply. I got everything working except the date comparison, it's a little complicated as excel changes the format and power automate needs it in a certain way. I did it different than you did, I'm going to dive back in later this week and I will go over your solution.

Was this reply helpful? Yes No
pinares21 2 on at

Like (0)

Report

Hello @dger, you could put here as you have done please. I have to do it and I can't find anything in the templates.
Thanks in advance

Was this reply helpful? Yes No
dger 6 on at

Like (0)

Report

Will do as soon as I have time to get back to it.

Was this reply helpful? Yes No
teanaflo 10 on at

Like (0)

Report

I am trying to send automated Birthday emails through Outlook using my Excel sheet in Sharepoint. In Filter Query, I don't have the option to choose what you did in your example. What am I doing wrong?

Was this reply helpful? Yes No
dger 6 on at

Like (0)

Report

Hello,
This is what I ended up doing.

formatDateTime(item()['birthday'], 'yyyy-MM-dd')
is equal to
formatDateTime(utcNow(), 'yyyy-MM-dd')
Not sure it's the absolute best way to do things, but it works!

Was this reply helpful? Yes No