How to Automate Birthday Emails With MS Power Automate

In 2021, the birthday celebration will take a new turn, moving from hard-copy birthday cards to e-cards. It is safer that way. In this video, I walk you through how to automate Birthday emails to your colleagues at work.

#powerapps, #howto #powerautomate #birthday #automation

[chibuzoropiti]

Thanks man!!! I been on this for over 8 hours now battling with the date conversion from excel to SharePoint and Power Automate but that little trick of yours(converting to int) saved me the frustration.

[savetheearth]

This is great! I have once question, its ok if its a no, but does the email send to any email (such as gmail, Hotmail, etc)????

[quintonrichards]

Could you show how to do this if you have a Microsoft List with 100 employees each of which has a unique Birthday Card Image? I can set up an email that is triggered when it’s an employees birthday, but the Microsoft List Image column containing all the employee birthday jpg files can’t be directly added from what I can tell to the body of the email. Any help would be greatly appreciated!

[tbhellaz]

Wow thank you very much. I tried this and the picture is only available as an attachement at the recipient. how can i make it work as a picture directly in the email body?

[addpojuabayomi]

Thank you so much for this. I have one concern I'll like you to help me with. How do make use of a png image card in the body of the email instead of text? Thanks

[lucianapilartur]

Thanks a lot for this! I am putting pause and play folowing everything exactly haha I have one more question. How can I do to send emails with the images or videos in the body of the email and not as attachments?

[Josh-oc]

Can you please create a flow weekly birthday reminder sent to teams chat list of coming birthdays this week send every Mondays thanks

[lauricecastillo]

Hi, I don’t know why this didn’t work for me. No error on the flow but I didn’t receive the email even though it was supposed to be my birthday based on the data in the excel. Can you help?

[vinodkomiri]

This is awesome video... Thanks for sharing such a useful info...

[nnnikas]

Hello! I tried this and it worked! However in a few weeks I got this error:
-
Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
-
Now, it keeps failing. What should I do? Please help

[nitika]

Thanks for the video @Microsoft Power Tools. Could you also let me know how can I add an image (Birthday Card or gif) in the email content rather than an attachment and also add a distribution list in cc. or bcc. .

[nnnikas]

Hi! I will try this tutorial soon, I was wondering…for example one of my client’s bday is April 21. Does this mean (of course if I put in all the info and follow the tutorial) that my client will automatically get a birthday email (without me even opening my computer that day)???

[odunayooyebode]

I know this teaches how to automate birthdays for colleagues at work, but would it also work for clients of a business with a database of 12, 000 recipients?

[kugapriyan]

Hi
I made the exact one like what you did, flow is running successfully but when I tested changing the month to current month with current date for testing, it’s not sending e-mail as the condition says false, could you guide what I could have missed out?

[tharunthaduri]

Thanks, it's working, but the flow is sending mails continuously, Can you please show us how to change font style in email content

[adrianzenaalvites]

Hola @Microsoft Power Tools
saludos desde Perú
¿Cómo lograste realizar el efecto animado pica pica 🎉🎉 que se visualiza al abrir el correo? En el minuto 13:58
Desde ya muchas gracias por tu respuesta 😇

[murastube]

Thank you very much for this video🏆. Great work. It was an important help for me. 👍

[revatichaudhari]

It's awesome. But in my case it won't work in outlook desktop app.
Can you help me out? as soon as possible.

[djsingh]

Super!! can you also please add one more thing, that is how can we add image of birthday person in the body with decorative birthday message

[enzasellitri]

Hello @Microsoft Power Tools, if I have a formula in the cell, how can I get the corresponding value in Power Automate? Now I get #VALUE!