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.
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 😇
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!
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
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?
Hi @Luciana Pilar Tur. thanks for your comment and support. I have made a short video on how to embed image in the email. check it out here: th-cam.com/video/0-LFI0okl2o/w-d-xo.html
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)???
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?
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
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. .
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?
Yes you can! you can use Expression to extract these values. I used this method as I was trying to avoid any complex instructions in this video. Do you need this alternative method?
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?
Hello I have been following your videos and it has really helped me. I have been trying to create a flow that gets new items from SharePoint list and send email with the last item. however I can't get my flow to do what I want it to do any thoughts about what I might be doing wrong?
Hi FK. Thanks for finding the resources here valuable. Your issue is quite unclear. There is a SharePoint trigger for when item is created/modified. If you are able to use this, you can then add another action to get items details using the ID from the dynamic content. These details can be included in your email or anywhere you want to use them. Please do try this or explain better where the issue is
Hi could you please help me at onepoint actually i am able to sent but email goes to every person whose name was there at thesame time instead of date mentioned there
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?
Hi Revati, My sincere apologies for my late response. Kindly try to reduce the picture size. large files can be difficult to display sometimes in Outlook desktop
This is really awesome. It worked. Just need another help. I wanted to all all the emails in CC that present in the email. Please help that side also. waiting for your reply.
Thank you Yogesh. Glad it worked. If I get you right, you want to CC some particular email right? The question is 1. Do you want the CC to be dynamic? i.e. changing for different emails or just static email addresses. If dynamic, then you should add a column to the excel for CC. If Static, you should just hardcode it in the email action card body. Do let me know if this was helpful
@@TheOyinbooke Thanks for the help. Another help that is required is: I wanted to have the random image in the email that gets triggered. If there any option in this.
@@TheOyinbooke Same query but I've created an employee group mail so that I don't need to select all employees in so how can I add that group mail in Cc. Do I need to configure these settings from the 365 Admin Centre?? Please suggest
@@ankurjaiswal4829 kindly type in the group email created in the cc part. If the group email is active, then it should be working. Do let me know if this works
@@AMAdet it is possible to send sms within power automate. However, you must have active subscription to any of the available bulk SMS gateways e.g. Twillio
Hi there this is usefull. It was working before but now i'm getting 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 '1609' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Condition' to be referenced by 'repeatItems' or 'items' functions.'.'."
Hola, can you help me get solution to this error? i followed your steps but here is the error below: 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.'.
Awesome video :) can you please create one video for work anniversary. In my case, i want to send emails when colleagues completes its 3 year or 5 year or 7 years. Also, from today’s date, it should select the colleagues who have not yet completed their 3,5 or 7 years.. Is it possible? Please help
Hi Vivek, join me this Saturday on this Channel Live. I will be teaching how to Automate birthday and work anniversary with flexibilities that accommodates your need.
Hi , I am getting no dynamic content available every time when I try to list my table , previously it was working fine this problem has started since yesterday please help me out
Great Video - Thanks for sharing. I tried to replicate this flow but when I did the test run I received this error message: Unable to process template language expressions for action 'Condition' at line '1' and column '16503': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. Could you please help me to fix it? Many thanks and best regards from Switzerland, Michael
Hello @@TheOyinbooke Thanks for your quick reply. I tried to rebuild the flow you describe in the video. But I only did the the simple birthday email (without pic, without gender and without relation ship). When I tested the process it did not show any errors or warnings. When I hit the "Run Flow" button everything looked ok. But when I check the run history I see that it failed. On the right side of the window I see an error message (Action 'Condition' failed) with the text that I mentioned above in my first comment. Many thanks for your feedback and your help, Michael
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.
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)????
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 😇
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!
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
This is awesome video... Thanks for sharing such a useful info...
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?
Hi @Luciana Pilar Tur. thanks for your comment and support.
I have made a short video on how to embed image in the email.
check it out here: th-cam.com/video/0-LFI0okl2o/w-d-xo.html
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)???
Yes. Exactly what you just described
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?
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
Can you please create a flow weekly birthday reminder sent to teams chat list of coming birthdays this week send every Mondays thanks
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. .
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?
Thank you very much for this video🏆. Great work. It was an important help for me. 👍
Hi, thank you for this awesome video. Can I check what if the record from my HR department the DOB is already in mm/dd/yyyy format. Thank you
Yes you can!
you can use Expression to extract these values.
I used this method as I was trying to avoid any complex instructions in this video.
Do you need this alternative method?
@@TheOyinbooke that would be really awesome if you could show me how to do it. Many thanks
@@Nicleehw sure. I will create the video today and upload today
@@TheOyinbooke Truly thank you!!!
@@TheOyinbookeHi Sir, hope I am not disturbing, was thinking if the video is ready. Thank you. :)
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?
Hello I have been following your videos and it has really helped me. I have been trying to create a flow that gets new items from SharePoint list and send email with the last item. however I can't get my flow to do what I want it to do any thoughts about what I might be doing wrong?
Hi FK. Thanks for finding the resources here valuable.
Your issue is quite unclear. There is a SharePoint trigger for when item is created/modified.
If you are able to use this, you can then add another action to get items details using the ID from the dynamic content.
These details can be included in your email or anywhere you want to use them.
Please do try this or explain better where the issue is
Thanks for your email Sir do you by chance have an email I can reach you on?
I have used scheduled reoccurrence then used Get items using ID and top count but the flow does not pick the most recent activity dates in my flow
@@FK-zb9is kindly reach me on olacharles@capacityng.onmicrosoft.com
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!
Hi could you please help me at onepoint actually i am able to sent but email goes to every person whose name was there at thesame time instead of date mentioned there
Thanks, it's working, but the flow is sending mails continuously, Can you please show us how to change font style in email content
How to embed a picture or birthday card instead of sending it as attachment
same question
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?
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
Yes I am looking for that !
Thank you for this! :)
Thank you for the support and encouragement
It's awesome. But in my case it won't work in outlook desktop app.
Can you help me out? as soon as possible.
Hi Revati,
My sincere apologies for my late response. Kindly try to reduce the picture size. large files can be difficult to display sometimes in Outlook desktop
@@TheOyinbooke could you recommend of the picture size?
This is really awesome. It worked.
Just need another help. I wanted to all all the emails in CC that present in the email. Please help that side also.
waiting for your reply.
Thank you Yogesh.
Glad it worked.
If I get you right, you want to CC some particular email right? The question is
1. Do you want the CC to be dynamic? i.e. changing for different emails or just static email addresses.
If dynamic, then you should add a column to the excel for CC.
If Static, you should just hardcode it in the email action card body.
Do let me know if this was helpful
@@TheOyinbooke what I want is: if there are 10 employee's data in table the all those 10 email ids to be kept in CC.
@@TheOyinbooke Thanks for the help.
Another help that is required is: I wanted to have the random image in the email that gets triggered.
If there any option in this.
@@TheOyinbooke Same query but I've created an employee group mail so that I don't need to select all employees in so how can I add that group mail in Cc. Do I need to configure these settings from the 365 Admin Centre?? Please suggest
@@ankurjaiswal4829 kindly type in the group email created in the cc part.
If the group email is active, then it should be working.
Do let me know if this works
How to add img in mail body without attaching img to thread
Awesome, interesting. Guess I would request all my friends email but is it possible that the mail can be send via mobile?
Hi Mathew, kindly clarify what you mean by mobile? Do you mean SMS or Email on mobile apps?
@@TheOyinbooke sorry for the ambiguity, I meant SMS
@@AMAdet it is possible to send sms within power automate. However, you must have active subscription to any of the available bulk SMS gateways e.g. Twillio
Hi there this is usefull. It was working before but now i'm getting 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 '1609' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Condition' to be referenced by 'repeatItems' or 'items' functions.'.'."
Thank you for bringing this to my attention. Let me check
Thank you for the video 😄
Hola, can you help me get solution to this error? i followed your steps but here is the error below:
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.'.
how to do this thing for leap year birthdays
Awesome video :) can you please create one video for work anniversary. In my case, i want to send emails when colleagues completes its 3 year or 5 year or 7 years.
Also, from today’s date, it should select the colleagues who have not yet completed their 3,5 or 7 years..
Is it possible? Please help
Hi Vivek, this is possible in Power Automate. Kindly watch out and subscribe to my channel to get notification once I drop the video guide.
Hi Vivek, join me this Saturday on this Channel Live. I will be teaching how to Automate birthday and work anniversary with flexibilities that accommodates your need.
Hi , I am getting no dynamic content available every time when I try to list my table , previously it was working fine this problem has started since yesterday please help me out
I will check it out and get back to you
Yes please
Did you find something?
Bravo!
Great Video - Thanks for sharing. I tried to replicate this flow but when I did the test run I received this error message:
Unable to process template language expressions for action 'Condition' at line '1' and column '16503': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
Could you please help me to fix it?
Many thanks and best regards from Switzerland,
Michael
Hi Michael, thank you for checking this video.
At what point is this flow failing? I will really like to help fix it.
Hello @@TheOyinbooke
Thanks for your quick reply. I tried to rebuild the flow you describe in the video. But I only did the the simple birthday email (without pic, without gender and without relation ship). When I tested the process it did not show any errors or warnings. When I hit the "Run Flow" button everything looked ok. But when I check the run history I see that it failed. On the right side of the window I see an error message (Action 'Condition' failed) with the text that I mentioned above in my first comment.
Many thanks for your feedback and your help,
Michael
@@Mig-gd1so noted. I will review the video with this explanation and make some recommendations shortly
condition not working for me. could you please share your email id for connect.
Can you please create a flow weekly birthday reminder sent to teams chat list of coming birthdays this week send every Mondays thanks
I will work on this and have it ready over the weekend
It's awesome. But in my case it won't work in outlook desktop app.
Can you help me out? as soon as possible.
Where exactly are you having the challenge?
Is your flow running successfully?
@@TheOyinbooke yes I'm running successfully with my flow, but it not send going to outlook app