Hi Buddy...can you please tell me how to add people in that list in an automated way so that the employee data should be added by-default whenever a new employee joins the organisation.
Hello! is there a way to write the OData Filter expression to include BOTH the month and day in the same expression? The birthdays in my list don't have the month and day in different columns. Thanks for any help you can provide!
@TheOyinbooke Learned a lot from your video. Now I am facing a problem please tell me the solution. This error is coming - The expression \"Joined eq ' 01' and Joined eq ' 12\" is not valid.
I followed the process step by step and it works without problems. I have just one question: How do I change the sender of the email, I mean, instead of using my account we prefer to use an HR account. Thanks again.
Hi Andrew, thank you for your question. To change the sender to HR account, kindly share the flow with the HR Account. I assume this HR account has Office 365 License as well. Once shared, just open the flow with HR account and locate the send an email action card(s). Click the more option button and change the account to hr
@@TheOyinbooke Thank you so much for your answer. I would like to add a web part for birthdays and work anniversaries on my main page. How can do I do it?
Hi, Is it necessary for all the date, month and year to be in separate columns? Can't we get the years (1st, 2nd,3rd..) anniversary if we put details in single column like mm/dd/yyyy in SharePoint list ? If yes, please can you show us how to get that ??
Hi @nduaguba Steven. Thank you for your question. This is possible but I haven't worked on it. I have pen down this topic and will create a video on this use case.
Hey great video, thanks. like you watching trying and learning. i have a question re this one. i fail to see any form getting the DOB in this format i.e dbirth mbirth if done on Microsoft forms am pretty sure people will use the date picker. how can if that is used i add the same.
Hi Simon Drayton, thanks for your question. In this scenario, we assumed the HR already have the list of the employees details and can easily put the dates in that format on Excel before uploading to SharePoint list. For date selected using the date picker on MS Forms, I will dona short video to describe how to manipulate it. Please do watch out here. I will add to this comment once posted.
This is great! But I’m getting an error that Column ‘DBirth’ does not exist. This appears in the Get Items inputs. I set up my file/list exactly as shown in the video. Suggestions?
Even though your comment is old but still i will share the fix incase someone else has this issue, The column name you see in the list isn't the true name, you have to go to your list then > options (gear sign top right corner) > list settings > you will find all the columns below, press the column that you want to insert and look at the URL, at the end of it there is an equal sign, the actual column name is the name after the sign. Mine was Field_1 for example. hope this helps.
Hi... Please i get this error when i run the test...The expression "DBirth eq '10'and MBirth eq '01" is not valid. Creating query failed. clientRequestId: 21f60fa7-a4b8-46e9-a2f1-f0bbc7e796fa serviceRequestId: 21f60fa7-a4b8-46e9-a2f1-f0bbc7e796fa. Please what is the likely causes? Thank you.
Hi Dan, Yes, we can use Excel instead of SharePoint. I don't have a video on this but it is similar. You only have to ensure the excel is formatted as table and stored on OneDrive rather than your PC.
@@TheOyinbooke I was trying to do it in excel but it doesn't take "And" function to check DD & MM as we are doing it in sharepoint in your video. If possible, could you create video and share whenever possible.
Hi, thank you so much for such an awesome fruitful PowerAutomate vedio, I was wondering if you could please present a vedio on PowerAutomate to send Birthday card on Whatsapp using employees information table\list where the trigger works on daily basis. REGARDS
Hello sir, Is there any way to add employee image and name as well in the image by using automate? Or do I have to create seperate images for the same And then link?
Hi Benedick, I learn by doing and teaching. I try to build something different every week and these use cases often lead to searching the web for guides which I can customized to suit my need. I then put this new found knowledge in a way that people can learn about it hence my TH-cam videos. I teach here so that I can learn twice. Finding useful resources on my TH-cam channel is your first stage of learning. Try to learn more and replicate. The more you do, the more you learn. All the best
Hi Revati, is it the email that is not displaying? If yes, you might want to check the file size of the image. If it's large, it might not display on the outlook desktop. Kindly let me know more about the challenge.
@@TheOyinbooke it is showing the cross ❌ sign where the image is displaying and it is working in web but it is not working in desktop app only And the image size is 47.39 kb
Hi Ankur, I want to assume that you have created the group email for your organisation. If they have, just get it from the IT Team or create one. You must have Admin access to create a group email where everyone in your organisation is part of. In the send an email action card, go to the advance section, you will see CC field. Add the group email to the CC field and everyone will be copied when a birthday mail get sent out
@@TheOyinbooke Thank you for the quick response I myself IT person and Admin just for the confirmation and for my knowledge I asked because the group mail which I've created is set with moderator so do I need to disable the moderator??
This is really great video, I was doing it for work anniversary but I am getting this error - "Unable to process template language expressions for action 'Condition' at line '1' and column '17363': '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 let me know where I am going wrong. This is what I have put in condition - sub(int(outputs('CurrentYear')), int(outputs('YearJoined')))
Try removing the YearJoined action card and add it again. This error often comes up if the variable added is not a Text. int() only work with a text or string input
@TheOyinbooke Learned a lot from your video. Now I am facing a problem please tell me the solution. This error is coming - The expression \"Joined eq ' 01' and Joined eq ' 12\" is not valid.
Very Helpful Sir.. Please make more Power Automate usecases videos.
Sure I will
The most helpful video, and all concepts are clearly explained. Thank you!
Thank you very much for this video...you save my life !! ;)
I am happy you found the video helpful
Hi Buddy...can you please tell me how to add people in that list in an automated way so that the employee data should be added by-default whenever a new employee joins the organisation.
Hello! is there a way to write the OData Filter expression to include BOTH the month and day in the same expression? The birthdays in my list don't have the month and day in different columns. Thanks for any help you can provide!
Instead of e-mail... Can we have that posted in Teams Chat Mesaage
@TheOyinbooke
Learned a lot from your video. Now I am facing a problem please tell me the solution.
This error is coming - The expression \"Joined eq ' 01' and Joined eq ' 12\" is not valid.
I followed the process step by step and it works without problems. I have just one question: How do I change the sender of the email, I mean, instead of using my account we prefer to use an HR account. Thanks again.
Hi Andrew, thank you for your question.
To change the sender to HR account, kindly share the flow with the HR Account.
I assume this HR account has Office 365 License as well.
Once shared, just open the flow with HR account and locate the send an email action card(s). Click the more option button and change the account to hr
@@TheOyinbooke Thank you so much for your answer. I would like to add a web part for birthdays and work anniversaries on my main page. How can do I do it?
You know I made the change, retested the flow, and I'm still showing myself as the sender instead of the HR account.
@@W.Wallace73 kindly connect with me on twitter twitter.com/theoyinbooke let's look at it together
@@TheOyinbooke Done. Just waiting your reply. Thank you again. I really appreciate it.
Hi,
Is it necessary for all the date, month and year to be in separate columns? Can't we get the years (1st, 2nd,3rd..) anniversary if we put details in single column like mm/dd/yyyy in SharePoint list ? If yes, please can you show us how to get that ??
Hi, kuch help chahiye thi appse sharepoint mein
please revert back if you see this.
Is there a way to display the person Profile Picture gotten from office 365 profile on the email
Hi @nduaguba Steven. Thank you for your question. This is possible but I haven't worked on it. I have pen down this topic and will create a video on this use case.
@@TheOyinbooke did u create video on this ?
Hi Sir i followed your steps but getting error when trying to get items based on birthday date as in step 39:53 . could you please help me out ? Tq
Hi, while adding image detail in step 3 - intialize varial after adding expression i am getting message "expression is invalid" Any suggestion or Help
in birthday email I want kept all of them for celebrating. how please guide.
hi i'm getting errors on my for each/ apply to each what are thr common causes for the error
Hey great video, thanks. like you watching trying and learning. i have a question re this one. i fail to see any form getting the DOB in this format i.e dbirth mbirth if done on Microsoft forms am pretty sure people will use the date picker. how can if that is used i add the same.
Hi Simon Drayton, thanks for your question.
In this scenario, we assumed the HR already have the list of the employees details and can easily put the dates in that format on Excel before uploading to SharePoint list.
For date selected using the date picker on MS Forms, I will dona short video to describe how to manipulate it.
Please do watch out here. I will add to this comment once posted.
This is great! But I’m getting an error that Column ‘DBirth’ does not exist. This appears in the Get Items inputs. I set up my file/list exactly as shown in the video. Suggestions?
Even though your comment is old but still i will share the fix incase someone else has this issue,
The column name you see in the list isn't the true name, you have to go to your list then > options (gear sign top right corner) > list settings > you will find all the columns below, press the column that you want to insert and look at the URL, at the end of it there is an equal sign, the actual column name is the name after the sign.
Mine was Field_1 for example.
hope this helps.
i cannot find this flow(scheduled flow) in microsoft teams power automate app
Hello, do you have a video where they teach how to make the images shown for the birthday?
Here is a video guide on this
th-cam.com/video/0-LFI0okl2o/w-d-xo.html
@@TheOyinbooke Thanks for your answer, but I mean if you have a video where you teach how to design the images with Power Point
@@JuanPablo-he4cx I don't have a video for this. I do use Canva or PowerPoint for my designs
Hi... Please i get this error when i run the test...The expression "DBirth eq '10'and MBirth eq '01" is not valid. Creating query failed.
clientRequestId: 21f60fa7-a4b8-46e9-a2f1-f0bbc7e796fa
serviceRequestId: 21f60fa7-a4b8-46e9-a2f1-f0bbc7e796fa. Please what is the likely causes? Thank you.
Can we make source as Excel instead of SP? If yes, Do you have any video around this?
Hi Dan,
Yes, we can use Excel instead of SharePoint. I don't have a video on this but it is similar.
You only have to ensure the excel is formatted as table and stored on OneDrive rather than your PC.
@@TheOyinbooke I was trying to do it in excel but it doesn't take "And" function to check DD & MM as we are doing it in sharepoint in your video. If possible, could you create video and share whenever possible.
thank you
Hi, thank you so much for such an awesome fruitful PowerAutomate vedio, I was wondering if you could please present a vedio on PowerAutomate to send Birthday card on Whatsapp using employees information table\list where the trigger works on daily basis. REGARDS
This is one of the best videos I've seen so far. But I have a question, how do I put a list of birthdays on my home page? It's possible using a flow?
Thank you Andrews for your comment. Do you mean put the birthday list on your SharePoint homepage? If YES, I will release a video guide on this soon
@@TheOyinbooke That will be great. I'll keep an eye on it, I guess the process will be very similar for work anniversaries.
Hello @@TheOyinbooke Do you have a ETA?
Hello sir,
Is there any way to add employee image and name as well in the image by using automate? Or do I have to create seperate images for the same And then link?
I have an error with DJoined from Get Items.... It says, doesn't exist. Please help
This is for Anniversary please
my flow is failing to fetch the djoined :(
bro, where you study Power Automate? Can you provide a link. Thank you
Hi Benedick,
I learn by doing and teaching.
I try to build something different every week and these use cases often lead to searching the web for guides which I can customized to suit my need.
I then put this new found knowledge in a way that people can learn about it hence my TH-cam videos. I teach here so that I can learn twice.
Finding useful resources on my TH-cam channel is your first stage of learning. Try to learn more and replicate. The more you do, the more you learn.
All the best
Or in 2 clicks you can install Billy Birthday for Teams... ;)
Great video. But for me it works in web outlook but it won't work in outlook desktop app.
Can you help me in this?
Hi Revati, is it the email that is not displaying? If yes, you might want to check the file size of the image. If it's large, it might not display on the outlook desktop.
Kindly let me know more about the challenge.
@@TheOyinbooke it is showing the cross ❌ sign where the image is displaying and it is working in web but it is not working in desktop app only
And the image size is 47.39 kb
@@TheOyinbooke is there any limitation on image size?
@@revatichaudhari1694 The Image file size is small and okay so you shouldn't have any issue.
@@TheOyinbooke but facing the same issue I tried with 98.1kb as well.
Hi,
How can I add my company group mail id so that everyone in my organization get birthday notification of that particular employee, please help
Hi Ankur,
I want to assume that you have created the group email for your organisation.
If they have, just get it from the IT Team or create one. You must have Admin access to create a group email where everyone in your organisation is part of.
In the send an email action card, go to the advance section, you will see CC field.
Add the group email to the CC field and everyone will be copied when a birthday mail get sent out
@@TheOyinbooke Thank you for the quick response I myself IT person and Admin just for the confirmation and for my knowledge I asked because the group mail which I've created is set with moderator so do I need to disable the moderator??
@@TheOyinbooke Thanks a lot, the Issue is resolved now its working Perfectly🙏
This is really great video, I was doing it for work anniversary but I am getting this error - "Unable to process template language expressions for action 'Condition' at line '1' and column '17363': '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 let me know where I am going wrong. This is what I have put in condition - sub(int(outputs('CurrentYear')), int(outputs('YearJoined')))
Hi Dany, thank you for your kind words. Kindly confirm if the YearJoined Column is a single line of text on SharePoint List.
@@TheOyinbooke Yes they are in single line of text in sharepoint
Try removing the YearJoined action card and add it again. This error often comes up if the variable added is not a Text.
int() only work with a text or string input
@@TheOyinbooke It's not working for me, I tried a lot but alternatively I will calculate years in excel and then link it.
@@Dany-ns6hg Are you reading the data from Excel or SharePoint list?
@TheOyinbooke
Learned a lot from your video. Now I am facing a problem please tell me the solution.
This error is coming - The expression \"Joined eq ' 01' and Joined eq ' 12\" is not valid.