Microsoft Teams Birthday App 1/2 with automated reminders for upcoming Birthdays
HTML-код
- Опубликовано: 20 янв 2023
- This tutorial shows to how to create a Birthday App using Microsoft Teams, SharePoint and Power Automate. The app will post a message into the Team 7 days before a birthday is coming up and will also post another message in the Team on the day of the Birthday. In the Team is also a Calendar view populated with your birthdays and also a tab to add new birthdays to the calendar.
Microsoft Teams Birthday App 2/2 - addon to automatically copy birthdays to next year • Microsoft Teams Birthd...
Commands Used:
formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd')
formatDateTime(addDays(utcNow(),+7), 'yyyy-MM-dd')
formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd')
formatDateTime(utcNow(), 'yyyy-MM-dd')
Hey welcome to WeTechCareOfYou!
If you are a returning subscriber we wish to say thankyou!
If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: wetechcareofyou.com/contact/
We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts:
✅Express VPN - Get a 30-Day Money Back Guarantee with our link.
A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider:
👉 click.linksynergy.com/fs-bin/...
✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage:
👉 click.linksynergy.com/fs-bin/...
✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint:
👉 click.linksynergy.com/fs-bin/...
*Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well.
Kind Regards,
The WeTechCareOfYou Team 💙 
Наука
is this set up only for one year then? Or how do I get those entered birthdays to pop up repeatedly every year?
Hey entchenanne, thankyou for the great question, unfortunately at the moment this does not automatically transfer the dates to the next year. We will create a solution for this and post it in the coming weeks.
Hey entchenanne, we have released a new video here to fix the issue so it will automatically copy the birthday to the next year:
ruclips.net/video/M9HimavxMbM/видео.html
Explaining step by step as if I were a child and reading all the comments, actually recording videos answering the viewers. Answering the viewers doubts and explaining to them what would be the pros and cons of the suggestions given is why you just got a new subscriber and follower, my friend. The name if the channel is ON POINT!!! Thanks for the video and the whole channel.
Hey marco, thanks for the great comment! Really appreciate it and its good to know our videos are helping!! Legend.
Thank you for this very Helpfull. Looking forward to the next updated version of this video explaining yearly occurrence.
Hey Roblox! Thankyou for the great comment. The next video will be released on Monday so stay tuned!
Hey Roblox, the new video is up here, please let me know if you have any issues:
ruclips.net/video/M9HimavxMbM/видео.html
@@WeTechCareOfYou I have a question on the condition for the Birthday with the step that checks the date and gives you a 7 day notification for some reason the alert send through for all birthdays added and not just for the relevant date for that person. Anything i could be doing wrong or is this by design?
Hey Roblox, is it possible you can send a screenshot of your condition and apply to each steps to admin@wetechcareofyou.com
Hi, thanks for the tutorial. do you know how to change the timezone in the code to utc +7?
Hey igustin,
Yes certainly, at the start of your flow use the convert to timezone step:
learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/converting-time-zone-power-automate
Then for every step in your flow where you reference utcnow() make sure it references the result from the convert timezone instead
Hi thanks for the tutorial, for this power automate we have to purchase it? Can't find it on my menu
Hey Dinda, for Power Automate it will be included in certain Microsoft 365 licences. If you have a licence you can go to powerautomate.microsoft.com/ and create a flow
The power flow's logic app flow template was invalid. Unable to process template language expressions for action 'Apply_to_each' at line '1' and column '678': Expected an expression, but found string literal 'value x' instead. is the error message I am getting while trying to save it.
Hey ddevikar, hmm this is the first time i have seen this error. Is it possible you can send screenshots of your steps to admin@wetechcareofyou.com and we will take a look
Hi There, It does not work for me for some reason. I think it's messing up the date formats. I am in Canada and I follow the format MM/DD/YYYY. Does this change anything when I create the power automate?
Right now, the tool posts a message in the general channel letting me know that it's everybody's birthday today.
Example: Test 1 birthday is today - 00/28/2024
Test 2 birthday is today - 00/28/2024
How can I fix this?
Hey Sayed, please check you have not added another apply to each inside the first apply to each. Also for your formats just make sure both date formats in the condition are the same and it should be fine. If you want to send screenshots of your flow to admin@wetechcareofyou.com i can take a look
Hi, I believe that I have set everything up as you have done. However, for some reason the post I am getting is a post for every single birthday in my calendar and it is saying that they all have birthdays in 7 days. Do you know what I might have done wrong?
Hey gert, thankyou for following the channel. Please send screenshots of your flow steps to admin@wetechcareofyou.com and we will take a look
Ia can't save flows error code: "InvalidTemplate". message: "The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'condition' are not defined in the template.'.".
Hey ilya, it looks like a variable or one of your flow steps is not named exactly the same as shown in the video. If you can please send screenshots of your flow to admin@wetechcareofyou.com and we can take a look.
I am getting this error: The input parameter(s) of operation 'Apply_to_each' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Apply_to_each
Sent you an email. Any help would be highly appreciated, thanks.
Solution/Update: Okay with the old designer it is working fine.
Hey Ahetejazahmad Khan, I just replied to your email please let me know if you have any further issues.
Hello,
I created the flow using UTC, but how can I check for IST in the conditions? Can you please help me out. Thanks in advance
Hey Nalini,
I am sorry but we do not yet have a video on this conversion. There are 2 ways you can do it, you can see in the Microsoft documentation here:
learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/converting-time-zone-power-automate
I hope this helps you!
Hi please can you assist. I believe I have set everything up as you have done, but the only condition I have set it to tell me on the day of someone's birthday. However, for some reason the post I am getting is a post for every single birthday in my calendar and it is saying that they all have birthdays today. Do you know what I might have done wrong?
Hey Dennis, i just replied to your email so please let me know if that helps
Hello, I followed all the steps but it was not posting. so re-did everything and getting a failure under "Apply to each" For the "value" picked I only had a choice to pick "body/value".
Hey Monica, is it possible you can send screenshots of your flow and error to admin@wetechcareofyou.com and we will take a look
@@WeTechCareOfYou yes I can.
@monicaparenti527 hey I received your email so I will take a look and get back to you.
In india can we use Utc or any other standard..bcs I added ist and it didn't took
Hey vinyasdrai, you can use the "convert timezone" step which will give you ist
Is there a way to import the birthdays from an excel of csv file instead of adding one by one?
Hey thankyou for the comment. Sure you can select "edit in gridview" on the list and paste all of your data in
Can you make one where reminders are sent a day earlier if it falls on a holiday or weekened?
Hey minchien, unfortunately this specific video will be large to build. However we have just recorded a video on how to calculate the first business day of the month in Power Automate flow. The steps in this scheduled video will be a similar calculation to what you need to detect weekends. This video is scheduled to be released in July.
Hello can you pleas explain how to add both birthday and work anniversary in same workflow
Hey vinay, there are many ways to achieve this, however I think the best way is to add a choice column to your SharePoint list with the options "Birthday" and "Anniversary". Then in your flow, when it sends the email, add a condition and have if ChoiceColumn/Value - equals - "Birthday". In the true route send an email with birthday info, in false route send an email with anniversay info.
Be awesome if you could get it to send the coming soon teams message to everyone but that birthday person
Hey Peter, this is a great idea thankyou for the comment. This can be achieved in a number of ways
Would it be by adding a condition and then send only if title doesn't match the title of the birthday?
Hi, I have the same error to save flow and not leave save , you know the reason?
"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Condition_2' at line '1 and column '2725' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Condition_2' to be referenced by 'repeatItems' or 'items' functions.'.'."
P.D Thanks for you work
Hey thankyou for your comment Diego, it seems you are referencing something in the apply to each which is incorrect. Is it possible you can send screenshots of your flow to admin@wetechcareofyou.com and we will take a look
@@WeTechCareOfYou thank you for your quick reaction, I have already sent the e-mail with the information.
ok great thankyou Diego, we will take a look and get back to you.
thank you very much for your interest in helping me to solve the error I had, finally I solved it by deleting the second condition and recreating it, I had some error there.
Great to hear you resolved the issue Diego!
I've the sam Issue:
Code: InvalidTemplate, Meldung: "The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'Bedingung' are not defined in the template.'.".
I would be very thankful if you guys could help me
Hey diji, does the column "Bedingung" exist in the sharepoint list?
@@WeTechCareOfYou Hi no bedingung means Condition and Meldung means message
I delete the whole Flow and make it again an save it after every step it beginns at the moment when I writ in the Conditions. with Copy paste.... I Live in Switzerland may it have problem with the us date format?
Ah ok. The common problem when people copy our video is the date field in the sharepoint list is not called "Birthday" so when the condition tries to compare date against Birthday the field does not exist. Please check your date field in your sharepoint list is called "Birthday"
I got it now I've to change the name in
formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd') to : formatDateTime(items('Auf_alle_anwenden')?['Birthday'], 'yyyy-MM-dd')
The means the same just in german .... I toutgh teh function is in the backend also in english but it is german
I'm getting this error: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. HELP!!!!
Hey Adanelly, please make sure the date field in your SharePoint list is called "Birthday"
@@WeTechCareOfYou Hey there! - Thanks for this awesome video. I´m getting the same error. Tried with differente names. Not able to solve it. Do you think it has to be with the name, or something to do with the date format time. Mine is MM.dd.yyyy ERROR: 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Gonna keep u trying and start from scratch. Thanks! Appreciate your help.
Hey aleher, your problem is the birthday field you are trying to format as a date is empty. Please make sure you are formatting the correct date field and make sure a date has been selected and it is not empty.
@@WeTechCareOfYou works like a charm! Thanks so much. Want to learn more about power automate now :) thanks and greetings from Argentina
Great to hear alehermetika! Nice work and thankyou! :D
How do I make these dates recurring? Currently I have to update these dates every year
Hey tebo,
We have a video on how to do this here:
ruclips.net/video/M9HimavxMbM/видео.html
Thanks for your video, it's very help full, I tried the same the upcoming entry is not updating why?
Hey Aneesh, please send an email to admin@wetechcareofyou.com
And we will take a look at your issue
@@WeTechCareOfYou
Email sent through my personal mail id
Hey Aneesh, we just sent a meeting invite to check your issue.
You should be software engineer to understand this. In order to do this, writing the birthdays on a paper would be much more easier. Thank you
Hey Ozlem, thankyou for the comment. I apologise if the flow is too confusing. If you have any issues when following the steps please just let us know and we can help to clear things up.
this is wayyy to fast... i put this on slow motion to keep up and with the buttons... this should be more as slow down ....
Hey, thank you for the comment and apologies if the video is too fast. I will take this in account for future videos. I hope you were able to get value some from the video.
@@WeTechCareOfYou testing this, i get : the formula expression are not correct.. so beeing a fast video.. not pointing what buttons you press... i have to find again the formulas. i watched with 0.75 speed rate.. so i can also do it in the same time,... 0.75 was ..hmm kinda ok.. but in speaking you say somethings, but ion fact you press some important buttons... its a little bit of confusing...
Ah ok, all the formulas in the video are in the description so you can copy and paste. But yes if you need us to clear anything up in slower detail please just email admin@wetechcareofyou.com
@@WeTechCareOfYou Thank you, i didnt managed to copy it, and wrote it more easily from description..annd the workflow worked just fine
Ok perfect happy to hear it working! Great job
Too much work. Not worth it for my colleagues lol
haha fair enough Emptythoughts! Hopefully in the future there is a quicker birthday app for you or you get better colleagues! :P
Hi welTechCareOfYou,
Could you please help me with the following error:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Condition' at line '1 and column '1643' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Condition' to be referenced by 'repeatItems' or 'items' functions.'.'.
Hey Shee, it looks like you are referencing an incorrect variable from within the apply to each. I would remove all variables from within the apply to each and readd them. If you cannot fix it please send screenshots of your flow to admin@wetechcareofyou.com and i will take a look
I ran the test, but it failed an I cannot see why 🤔 I copied the formulas from the discription and followed the video multiple times. ( apply to each error- ActionFailed. An action failed. No dependent actions succeeded./// condition - post message in ..... error- Forbidden.-- someone knows why this happens?
Hey Daphne, as you are getting forbidden, make sure the connection you are using in the flow has access to the Team/SharePoint list in which it is reading/writing to. If you click the 3 dots on the top right of the step that has failed, it will show you at the bottom the connection being used.
@@WeTechCareOfYou The connection is listed as my work email which is also the account of my sharepoint and the account I use for teams.