Happy Birthday Email

Like (0) Share

Report

Posted on 12 Aug 2021 15:47:13 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?

All responses (6)

Answers (0)

dger 6 on 21 Sep 2021 at 22:05:27

Like (0)

Report

Re: Happy Birthday Email

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!
teanaflo 10 on 21 Sep 2021 at 21:52:07

Like (0)

Report

Re: Happy Birthday Email

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?
dger 6 on 20 Aug 2021 at 21:15:11

Like (0)

Report

Re: Happy Birthday Email

Will do as soon as I have time to get back to it.
pinares21 2 on 18 Aug 2021 at 04:59:19

Like (0)

Report

Re: Happy Birthday Email

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
dger 6 on 17 Aug 2021 at 21:16:26

Like (0)

Report

Re: Happy Birthday Email

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.
ScottShearer 25,223 Most Valuable Professional on 12 Aug 2021 at 17:46:19

Like (0)

Report

Re: Happy Birthday Email

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