Thanks a lot, @helencronin5557 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Your points are valid. It's very difficult to understand what you're saying because of the way you explain it. I listen to the video repeatedly and try to predict what you are saying in order to understand. Thank you tho.
Thanks a lot, James Canning 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hey Rob H Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Thank you very much. Is there a way to validate the day without knowing for sure the format it is coming from? the user may input the data in dateUs and/or DateUK format. And after validating it just standardize in one format. Thanks
Hello, Thanks for the beautiful video! I need to get clarity for a question from you. I have an Excel file with a couple of columns, kept the file in SharePoint location, and with the help of list rows present in a table operation trying to read data from the Excel file with date format as "ISO 061", the output looks like "Joining Date": "2021-01-18T00:00:00.000Z" but I need only the date and month from above value Expected output - "01-18". How do I need to specify the condition in ''Enter custom Value" to get the desired output
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi Anders - Your videos are really good and especially also very structured and also super explained. However, I do not get on with one point. I want to create a CSV from an Excel table and change the date format. When I go through the steps, it works, but when I go to create the CSV table, it does not accept the changed format for the date. How can I include the changed date format in my CSV?
Hey Michael Kerwath Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Hi Anders, thanks for the very helpful tutorial. Need some help:) when I used the same expression to manage date from excel sheet I'm getting this error : "Unable to process template language expressions in action 'Compose_2' inputs 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 solve this?
Hey Indushree B Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
Hi! thanks so much for this tutorial it has been very helpful! I am still having a few issues gettting my flow to work from an excel template, to update a Sharepoint List. Basically, I have been copy/pasting from a source file into the excel template where the table is. But, for some reason, PA continues giving me this error message "OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_21' is required to be of type 'String/date'. The runtime value '"44998"' to be converted doesn't have the expected format 'String/date'." Any idea what I'm doing wrong?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi Anders, another amazing lesson from you! Just have a question about date -- I am creating a PAD flow to read from some excel files and write into a master file. One of the columns is date formatted as "dd/MM/yyyy'. The iteration with conditions went smoothly. But after the flow was completed, I found that the date column in the master file was messy with various date formats. Some were "MM/dd/yyyy" and some were "MM/dd/yyyy hh:mm:ss". I simply just want the date column formatted as "dd/MM/yyyy" as the original files. Is there an effective way I can do that? Thanks in advance!
Hey Y Y Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
hi am using Microsoft Power automate desktop , according to my requirement i need only date and it should be in date format, am trying to that but am getting date along with that time as well , i dont want time , please help out
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello. I'm from Brazil. I got a doubt... I have 4 date's colomns. How may I do it for all the columns. I tried this addDays('1899-12-30',int(items('Aplicar_a_cada')?['INÍCIO'] , ['TÉRMINO'], ['TÉRMINO REAL']),'dd/MM/yyyy') But gets wrongs. sorry for my english. Hope u understand.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How to get rows when one of its column is blank.? I need to collect the data for which date column is empty. I mean, need data for the goods not yet in our building.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How would you cope with a table entry which is blank? I have a Flow which pulls from a table which has some dates which are empty fields. Kills my flow…..
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
I got this Error on Power Automate : Unable to process template language expressions in action 'Criar_item' inputs 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.'
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello Anders, my date says 452083057060185 in my csv file from excel. I have tried your version from excel, but it dosen't work. I get an error. I need the date dd-MM-yyyy HH:mm but I can't figure it out. Can you help me?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Did the video help you? You can help me a lot by liking the video then 🙂
Done !
@@RanjanKumar-bv6ok Thanks a lot, Ranjan - your support helps my channel 🤗
Very informative! Liked.
Please could you make more stuff related to various flows between Outlook and Excel? Thank you.
would you please show me how to change the date to the day before when I am trying to extract my file from the website.
I've spent two days trying to work out how to get today's "day"! First part of your video nailed it. Thank you
Thanks a lot, @helencronin5557 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Your points are valid. It's very difficult to understand what you're saying because of the way you explain it. I listen to the video repeatedly and try to predict what you are saying in order to understand. Thank you tho.
Thanks a lot, Ugur, and I'm sorry. I'll try to do better in the next video 😊
This is an AMAZING tutorial. This has made my day thank you very much Anders!
Thanks a lot, James Canning 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
you're great. Your style is just the best, thank you so much!
Wow, thanks a lot, Relief - Highly appreciated. Have a great weekend. Kind regards, Anders
Absolutely brilliant tutorial, well explained with great detail.
Hey Gerard, thanks a ton - appreciated 🤗
Thank you very much for a very detailed video, this is very good.
Thanks a ton, Ha Sai 🤩 Have a great day. Kind regards, Anders
Excellent video😇expecting more tutorial videos in power automate.
Thanks a lot. Plenty of Power Automate (and Desktop) videos coming - I'm full-time on this now 🙂
Great and very clear explanation, thank you!
Hey Nikolai - thanks a lot, I'm glad to hear 😊
@@andersjensenorg May I ask if you have any materials on how to format numbers in an array? I would really appreciate one.
Really useful, thank you. I just need to get this to work on a Form to List view as a Calendar!
Hey Rob H
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Thank you very much. Is there a way to validate the day without knowing for sure the format it is coming from? the user may input the data in dateUs and/or DateUK format. And after validating it just standardize in one format. Thanks
Hello, Thanks for the beautiful video! I need to get clarity for a question from you. I have an Excel file with a couple of columns, kept the file in SharePoint location, and with the help of list rows present in a table operation trying to read data from the Excel file with date format as "ISO 061", the output looks like "Joining Date": "2021-01-18T00:00:00.000Z" but I need only the date and month from above value Expected output - "01-18". How do I need to specify the condition in ''Enter custom Value" to get the desired output
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thank you very much for sharing, how could I condition a date, if today is Monday subtract two days... could it be done with power automate?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks!
My pleasure 🤩
Hi Anders - Your videos are really good and especially also very structured and also super explained.
However, I do not get on with one point. I want to create a CSV from an Excel table and change the date format. When I go through the steps, it works, but when I go to create the CSV table, it does not accept the changed format for the date.
How can I include the changed date format in my CSV?
Hey Michael Kerwath
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Hi Anders, thanks for the very helpful tutorial. Need some help:) when I used the same expression to manage date from excel sheet I'm getting this error : "Unable to process template language expressions in action 'Compose_2' inputs 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 solve this?
Hey Indushree B Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
Hi! thanks so much for this tutorial it has been very helpful! I am still having a few issues gettting my flow to work from an excel template, to update a Sharepoint List. Basically, I have been copy/pasting from a source file into the excel template where the table is. But, for some reason, PA continues giving me this error message "OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_21' is required to be of type 'String/date'. The runtime value '"44998"' to be converted doesn't have the expected format 'String/date'." Any idea what I'm doing wrong?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi Anders, another amazing lesson from you! Just have a question about date -- I am creating a PAD flow to read from some excel files and write into a master file. One of the columns is date formatted as "dd/MM/yyyy'. The iteration with conditions went smoothly. But after the flow was completed, I found that the date column in the master file was messy with various date formats. Some were "MM/dd/yyyy" and some were "MM/dd/yyyy hh:mm:ss". I simply just want the date column formatted as "dd/MM/yyyy" as the original files. Is there an effective way I can do that? Thanks in advance!
Hey Y Y Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
hi am using Microsoft Power automate desktop , according to my requirement i need only date and it should be in date format, am trying to that but am getting date along with that time as well , i dont want time , please help out
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello. I'm from Brazil. I got a doubt... I have 4 date's colomns. How may I do it for all the columns.
I tried this
addDays('1899-12-30',int(items('Aplicar_a_cada')?['INÍCIO'] , ['TÉRMINO'], ['TÉRMINO REAL']),'dd/MM/yyyy')
But gets wrongs.
sorry for my english. Hope u understand.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How to get rows when one of its column is blank.? I need to collect the data for which date column is empty. I mean, need data for the goods not yet in our building.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How would you cope with a table entry which is blank? I have a Flow which pulls from a table which has some dates which are empty fields. Kills my flow…..
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
I got this Error on Power Automate : Unable to process template language expressions in action 'Criar_item' inputs 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.'
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello Anders, my date says
452083057060185 in my csv file from excel. I have tried your version from excel, but it dosen't work. I get an error. I need the date dd-MM-yyyy HH:mm but I can't figure it out. Can you help me?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How to take execution time in screenshot in power automate?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Porque não consigo ativar legenda em seu vídeo ?? :(
Can you do it in English please? 😊