cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rwittels
Resolver I
Resolver I

Birthday email listing all birthdays in a single email

There are many tutorials and templates explaining how to send out an email to someone on their birthday. We prefer to send a single email out to the company listing all people who are celebrating their birthday on that day. I found this great template: Send wishes to employees by email as per the birth date in SharePoint list but I would like to know how to list the names of all the people celebrating birthdays in the body of the email. The email would then go out to the same distribution list each day. So instead of "Happy Birthday FirstName" I would prefer, "We would like to wish the following people happy birthday today:" and then list the full names.

23 REPLIES 23

 I've noticed that the run will fail if none in the List has a birthday. Not sure if this how it will work.  Big thanks to this!

 

P.S. Did you write anything in the Terminate part?

P.S.S. I've also added screenshots for future reference. Hope this might help.

No birthdays:

almapete21_1-1624280095408.png

 

With at least one birthday:

almapete21_2-1624280247617.png

 

 

There is nothing in the Terminate part. If the list is empty then there is no need to send any email so the Flow terminates. This might appear as Failed or Cancelled in the Run history.

What is the formula you have entered in the condition section - formatdatetime.....?

Condition:

formatDateTime(outputs('Compose'), 'M/d') is equal to formatDateTime(utcNow(),'M/d')

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,663)