You’re offline. This is a read only version of the page.
3
I have an Excel list contains the name /birthday.
I would like to build a flow so that it check the current date to see if it is matching the date in my excel list.
if there is any matching, the bot will post a message on a specific channel wishing that person a Happy birthday.
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!
So the excel columns are Name of person and Date of Birth of person right ??
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
