HappyBirthday flow for Office 365

Purpose

HappyBirthday is a Power Automate flow template to send a single email out to the company listing all people who are celebrating their birthday on that day.

Current version: 1.0.1

Features

• You do not need to create special SharePoint list of user birthdays and modify this list from time to time.

• The flow does not send the birthday e-mail to celebrant(s), it sends the e-mail containing the list of today's celebrants to the pre-defined address.
  It can be the address of a distribution list or an Office 365 group or even a Team channel.

• The flow assumes that only user mailboxes have non-empty "Given Name" value, in contrast of the shared and equipment mailboxes.
  In other words, only mailboxes with non-empty "Given Name" field are checked for birthdays.

Prerequisites

• Delve should be enabled in your Microsoft 365 (Office 365). Only user who set their birthday in Delve will be listed in the celebration email.

• You have to create the distribution list "AllUsers" - static or dynamic.

• (Optional) You have to create the distribution list "NoReply" with no members and assign yourself "Send as" right on it.

Installation

• Download HappyBirthdayFlow1.zip file and then run Office 365 PowerAutomate and import the zip file to your flows list as described here.

• Modify "Recurrence" trigger according to your needs.

• If you wish to send as NoReply, place the SMTP address of your NoReply distribution list to the "Value" field of "Initialize variable SendAsAddress (parameter 1)" action

• Place the SMTP address of AllUsers distribution list to the "Value" field of "Initialize variable TargetAddress (parameter 2)" action

  

• Scroll down and click "Condition PeopleToCongrat is not empty", then open "Send an email (V2)". Modify the HTML text in the "Body" field if necessary.

  

Price of support

If you need to get technical support, please buy at least one support unit and contact us. NO REFUND.

Price of one support unit

$35.00

  ORDER

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries