Unanswered

How do I automatically post a Happy Birthday message in Teams?

(2) Share

Report

Posted on by grantfuhr

I have all of my employees' birthdays in my Outlook 365 calendar. They are all-day events. I am struggling to create a flow that automatically outputs the following on their birthday into a post in Teams:

Today is [Name]'s birthday! Happy birthday!

[Happy Birthday gif]

I have been working on this for a week. Thanks in advance.

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @grantfuhr ,

You could use Filter array to filter the eligible events and post the message to Teams channel:

You could also click Edit in advanced mode to enter multiple conditions to filter events.

https://sharepains.com/2018/12/18/microsoft-flow-filter-data-in-an-array/

Image reference:

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
grantfuhr 9 on at

Like (0)

Report

Thank you @v-bacao-msft. That works great! Is there a way to post the message at 8:00 AM every day?

Will this work for multiple birthdays on the same day?

Thanks again! You are awesome!

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @grantfuhr ,

You could set Recurrence as follows:

Filter array will filter all eligible events in the current date.

Best Regards,

Was this reply helpful? Yes No
harshkohli 4 on at

Like (1)

Report

Hello, @grantfuhr @v-bacao-msft I am doing the same thing for microsoft teams as well but my flow is not posting anything on the channel can you two please tell me the exact steps for the above process it will be great help or if its possible please contact me on my email address:
Email: harshkohli033@gmail.com

Was this reply helpful? Yes No
ErikOlsson Microsoft Employee on at

Like (1)

Report

@v-bacao-msft and @grantfuhr - Would you mind sharing the flow as a zip here so people could experiment with it?

Love this idea, but like @harshkohli , I struggle to create it from start to finish. Thanks for sharing guys!

Was this reply helpful? Yes No
ericlindros 2 on at

Like (0)

Report

It stopped working for me too. Anyone have any suggestions?

Was this reply helpful? Yes No
Pyke 3 on at

Like (0)

Report

Hi @v-bacao-msft ,

Thank you for this. I tried using the same filter array but unfortunately the output body cannot retrieve any information from the birthday calendar. Then I tried using "contains" instead of "starts with"(See below), then the power automate successfully post a message in our teams. However, it post the same message in two(2) consecutive days every 7:00AM from the birthday calendar. I wonder what is wrong to my filter. I would greatly appreciate if you can help me to my concern. Thanks

Was this reply helpful? Yes No
CHITRA1 9 on at

Like (0)

Report

Hello, why the email did not trigger the message?

Was this reply helpful? Yes No
fabienpinel 2 on at

Like (0)

Report

You can do that with apps like https://billybirthday.com/microsoft-teams

Was this reply helpful? Yes No
ATSvmahale 4 on at

Like (0)

Report

Hi @grantfuhr ,

To automate happy birthday messages in your Teams channel, install AnnounceBot from the Microsoft Teams app store. You only need to select your Teams channel to set it up.

Getting started with this birthday bot is simple. It automatically collects the dates for you or if you already have the dates you can bulk upload and manage them using a spreadsheet template. Along with birthday messages, it's great for work anniversary celebrations and special events like holidays, and new hire onboarding.

Vipassana Mahale
Quality Assurance Engineer
vipassana.mahale@announcebot.in
https://announcebot.in
AnnounceBot - Your Microsoft Teams bot to automatically wish teammates on their birthdays, work anniversaries, and special occasions.

Was this reply helpful? Yes No