@Anders Jensen, regarding power automate desktop how to pass variables from one flow to another flow. For example flow1 variable values to flow2. Can you please help me for this.
You are an exceptionally talented teacher and for someone not English, you speak better English than the English themselves. I love you man!!! Have learnt loads from you.
Haha, thanks a lot, my friend 😍😍😍 I have many more PAD videos to come during the next months. Have you seen my new PL-500 course (only the first lesson so far): th-cam.com/play/PLXXz88_TPiHrnu0itj7At0K-xEZyl2XNr.html Kind regards, Anders
Dear Anders, I started watching your videos on Power Automate since about 2 weeks ago, starting with the beginner's tutorial. I want to say that all of them are wonderfully explained, making the learning experience really enjoyable and easy to understand. I am new to this application, but by now I have successfully created some very helpful automate flows for my work. I want to dedicate a big salute to you and wish to thank you for all the help so far. 🙏
Appreciate the love, thanks a ton, j 🥳😍 These comments make it easy to find the motivation to create more videos. Please let me know, if you see something I can do better. Kind regards, Anders
Hi Jensen, I have been learning Power Automate Desktop by watching your video. Thanks a lot for bringing such meaningful knowledge in the easiest method for beginners. I am applying power automate desktop into my daily task. I would appreciate if you could help to guide me how to launch the latest excel file. For example, 16 Sept is Monday, and I would like to open the file of the last working day (Friday), instead of Sunday. Thank you
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Another extremely useful video… thank you Anders. My rate of knowledge growth (in PAD) is rapid, thanks to your guidance and very clear tutorials! Best wishes, Mick.
Hello Jensen, great video and contribution to the community. A question, I did the exercise and I understand only that the part when the excel file is saved and I add the formatted date sends me an error but if I leave only the name of the new file there if it is saved, any suggestions, I would greatly appreciate it. sds
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hey @yahyafares7515. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
4:20 You can end the hanging excel process by ending the open excel task in task manager > details. Always a good place to look if an automated file isn’t opening
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 11,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hello, I encountered a problem in converting text to number and it gives the following error. How do I fix it? Can't convert text '0/78' into a valid number (text provided is either in a non- recognizable format or contains too many characters).
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.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 12,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
When I download the Candy.xlsx sheet the first 2 columns data are not in decimal format. For example: Cost says: 365, Price says: 694, Units Sold says: 315. However on your video is shows decimals. Am I doing something wrong? Or is your data not formatted correctly on your course files site?
Thanks a bunch, @jimmyfal 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: th-cam.com/video/xWFz-S96XGo/w-d-xo.html You're more than welcome. Kind regards, Anders
Regarding the vbscript, I was having error Unterminated string constant for "%ActiveSheet%" where it used to reference the worksheet name. but where I use "Products" , it works. how to resolve this so it can reference the variable instead of the name of the worksheet .
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.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 11,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.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 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Thanks for all your likes and support 🙌🔥
You should watch this video next: th-cam.com/video/ZvbnuQp7x5g/w-d-xo.html
@Anders Jensen, regarding power automate desktop how to pass variables from one flow to another flow. For example flow1 variable values to flow2. Can you please help me for this.
@@PowerAutomateDesktop0322 Sure, you can use the Run desktop flow action with input/output variables 🙂 Kind regards, Anders
You are an exceptionally talented teacher and for someone not English, you speak better English than the English themselves. I love you man!!! Have learnt loads from you.
Haha, thanks a lot, my friend 😍😍😍 I have many more PAD videos to come during the next months. Have you seen my new PL-500 course (only the first lesson so far): th-cam.com/play/PLXXz88_TPiHrnu0itj7At0K-xEZyl2XNr.html Kind regards, Anders
Dear Anders, I started watching your videos on Power Automate since about 2 weeks ago, starting with the beginner's tutorial. I want to say that all of them are wonderfully explained, making the learning experience really enjoyable and easy to understand. I am new to this application, but by now I have successfully created some very helpful automate flows for my work. I want to dedicate a big salute to you and wish to thank you for all the help so far. 🙏
Appreciate the love, thanks a ton, j 🥳😍 These comments make it easy to find the motivation to create more videos. Please let me know, if you see something I can do better. Kind regards, Anders
Hi Jensen, I have been learning Power Automate Desktop by watching your video. Thanks a lot for bringing such meaningful knowledge in the easiest method for beginners.
I am applying power automate desktop into my daily task. I would appreciate if you could help to guide me how to launch the latest excel file. For example, 16 Sept is Monday, and I would like to open the file of the last working day (Friday), instead of Sunday. Thank you
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Another extremely useful video… thank you Anders. My rate of knowledge growth (in PAD) is rapid, thanks to your guidance and very clear tutorials! Best wishes, Mick.
Hey Mick, thanks a bunch for the kind words 💪🙂
I’m all here for this! Thanks Anders! Keep sharing the knowledge
Hey Jose Carlos! Thanks a ton for the nice message, highly appreciated. Have a great weekend ☀🙂 Kind regards, Anders
Hello Jensen, great video and contribution to the community. A question, I did the exercise and I understand only that the part when the excel file is saved and I add the formatted date sends me an error but if I leave only the name of the new file there if it is saved, any suggestions, I would greatly appreciate it. sds
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Thanks again Anders for this amazing tutorial. keep going and thank you for sharing best practices in Power Automate desktop
Hey @yahyafares7515. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
4:20 You can end the hanging excel process by ending the open excel task in task manager > details. Always a good place to look if an automated file isn’t opening
Thanks a lot, tonberryking. I prefer either cmd/PowerShell because it can also be implemented in PAD. Have a great day. Kind regards, Anders
I love the intro (and automation) 😍🤖
Haha, thank you 😍
hi thanks for another amazing video, i have a question, why did you add insert column F which i think dont need to add as there is no column after E.
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 11,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hello, I encountered a problem in converting text to number and it gives the following error. How do I fix it?
Can't convert text '0/78' into a valid number (text provided is either in a non-
recognizable format or contains too many characters).
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Thank you for the video. Do you have any course about VBScript?
Unfortunately not anything else than in this video, but I can recommend ChatGPT (even the free version GPT 3.5). Kind regards, Anders
@@andersjensenorg Once more time thank you for the tip. Best regards.
When I Read from excel worksheet... there is no data table that is showing up... Can someone help me with this?
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 12,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
When I download the Candy.xlsx sheet the first 2 columns data are not in decimal format. For example: Cost says: 365, Price says: 694, Units Sold says: 315. However on your video is shows decimals. Am I doing something wrong? Or is your data not formatted correctly on your course files site?
Thanks a bunch, @jimmyfal 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: th-cam.com/video/xWFz-S96XGo/w-d-xo.html You're more than welcome. Kind regards, Anders
Regarding the vbscript, I was having error Unterminated string constant for "%ActiveSheet%" where it used to reference the worksheet name. but where I use "Products" , it works. how to resolve this so it can reference the variable instead of the name of the worksheet .
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders
How can I remove blank Rows from a data table?
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 11,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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
@andersjensenorg Hi! Great video. I am unable to run the Macro when I have the Excel instance as invisible, do you know why?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders