Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Happy Birthday Email

(0) ShareShare
ReportReport
Posted on by 6

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?

  • dger Profile Picture
    6 on at
    Re: Happy Birthday Email

    Hello,

    This is what I ended up doing.  

    dger_0-1632261654549.png

     

    dger_1-1632261723105.png

     

    formatDateTime(item()['birthday'], 'yyyy-MM-dd')   
    is equal to 
    formatDateTime(utcNow(), 'yyyy-MM-dd')

    dger_2-1632261770333.png

    dger_3-1632261878182.png

    Not sure it's the absolute best way to do things, but it works!

     

     

  • teanaflo Profile Picture
    10 on at
    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 Profile Picture
    6 on at
    Re: Happy Birthday Email

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

  • pinares21 Profile Picture
    2 on at
    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 Profile Picture
    6 on at
    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 Profile Picture
    25,218 Most Valuable Professional on at
    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.

    image.pngimage.png

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,017 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow