Greetings,
This can be achieved by using the excel connector. To begin with, you should create a Scheduled Cloud Flow and set the repetition rate to once per day.
Add the "current time" action from "date time", this will give you data output in this fomat: [2024-01-01T00:00:00.0000000], however you only want the date, therefore this will need to be edited in further steps.
Then, select the Excel Business Connector/List Rows in a table, and choose your table. Expand the advanced options, and in the "Filter Query" input, type this in: "startswith([column name of the column storing birthdays], substring([dynamic output from "current time"],0,10)". Note to input the "substring([dynamic output from "current time"],0,10)" as a fuction, as it is a function to get the first ten chacracters of the "current time" output, which is the date in xxxx-xx-xx/year-month-date fomat. Also, please note to make sure that the birthdays in your excel database are also in that format and that instead of employees' name, their business email adresses should be listed in another column.
This should give you the dynamic output allowing you to use the email address of the specific person who has their birthday on this date, you can then use this to send a teams message in the specific channel you wish for the bot to send the message in with the microsoft teams connector. An example of the message can be "Happy birthday! @[user email from dynamics]".
Best regards,
Patrick
If you find this helpful, please consider marking it as the solution to help me and other people to get relevant help on this topic aswell! 😀
You can also help me by giving me a free 👍! Thank you in advance.
Note: This is one of my first responses to problems, any corrections will be extremely appreciated, thank you!
