Your tutorials are such high quality! I wouldn't have thought to learn how to automate a nasty task that would have taken me literally 40 hours in less than 2 hours! Thank you so much!
Hey Quabbe. Wauw, what a lovely message, thanks a lot. And yes Power Automate/RPA is great - it's straighforward, and the learning curve is fast 🙂 Have a great day. Kind regards, Anders
Thanks a bunch, @AhmedBalfaqih 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: ruclips.net/video/xWFz-S96XGo/видео.html You're more than welcome. Kind regards, Anders
Excellent Lesson and I learned so much - now to develop this to sort and move files in my Onedrive that has become very messy over the years - thanks again
Thanks a ton, Fernando Silva 🤩 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks a lot, @theprofessor4487 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks a lot, @jalonnun1 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hey anders, I have started watching your videos on power automate for the past one week and I'm truly impressed with the way you are explaining stuff. What do you think is the correct approach for me to pursue my career in Power automate RPA.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Really nice tutorial! Just adding a note here to help people that might use this video for a real case scenario, taking care of the upper case in the extension could save you some trouble! :) For the Switch condition: toLower(%File.Extension%)
Thanks a lot, MaxCriant. And you're right 😊 It's because because yesterday I made this: ruclips.net/video/bXqSjLCSLEg/видео.html, which solves what you're explaining. Kind regards, Anders
Hey brijendraydv. Great question. Then you need to buy an unattended licence, which, I think, is $40/month. You need to run it in an environment, so yes a machine, VM or a server etc... Kind regards, Anders
Hey Pitak N. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great tutorials but I'm having trouble finding how to extract files from a folder and copy them into another folder but only extracting the files listed in an Excel sheet?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
As a starter for this I must say that you create Really good stuff. Highly apprecitated. Is there a Way to keep track of filés that are copied from one place to another if you have a Hugh amount of filés and you don`t want to copy them twice? Subscribing from now on, Thank you
Hey True Viking. Thanks a lot 😍 We don't move them twice, but we add them to a list for logging purpose. Let me know, if you want a more detailed explaination. Kind regards, Anders
@@andersjensenorg Thank you for your quick reply. I understand the general idea of writing a log for this flow. Then I also asume that one of the first things to do is to read the logfile. Thanks again for the reason that you share youre knowledge
@@truewiking Yeah, or maybe the best approach to a log, will be to only read the errors happening. Else you get a lot of logs to read 😀 So an example of how to create a simple log.
@@truewiking The logfile created isn't used in processing the files. It's only for the user to inspect later if they want so see the names/quantities of files moved.
@@harjitsamra Thanks for your input. I get the concept of the log file. What i was thinking about was reading from that log file to see what file i last read. Solved it with ”if file exists” instead.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi Anders, I'd like to know how to copy folder and subfolder names into an excel file, only the name without path. I have a shared folder called 'Customers' and my coworkers can place new projects inside each customer folder. Every moth I'd like to run a flow and count each customer project inside folder and make a list like this one but in excel.
Hey Davi Rodrigues Kawagoe 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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
You could set a variable before the loop, and increment it inside the loop. if it is greater than 5 then don't carry out the processing. You can't actually exit the for each - current limitation
Hi Anders, Hope you’re doing well ! I have received a requirement in which I have to read approval through Email , as it is not feasible as People may send different reply for Approval. So, Now we are planning to send an Excel file with a dropdown to Approve and Reject. So , Now the Bot will have to download Excel and read the responses . Is it possible?
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): ruclips.net/video/xWFz-S96XGo/видео.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 7000+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Nice but my case is: I download a serie filename: FunnyS01E01.mkv. I want to move this file to an external hd. The filepath on this hd is Funny. The sub dir is S01. Here I want my file. Next time its an other filename but same structure. Is this possible?
Hey Inge W 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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. 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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hey Thomas. It depends. Power Automate is cheap and already in people's microsoft suites, but UiPath is the most advanced RPA tool (by far). Kind regards, Anders
I just watched one lesson and it was explained very well so moved to next lesson and next lesson and now I am half way done. I am going to watch all the lessons. It's very informative, detailed and very nicely explained. Awesome course work @andersjensenorg
You're very welcome, @chirantanupadhyay2375 - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html
LIKE AND SUBSCRIBE IF YOU ENJOYED 🙌🔥
Instagram: @andersjensenorg
Your tutorials are such high quality! I wouldn't have thought to learn how to automate a nasty task that would have taken me literally 40 hours in less than 2 hours! Thank you so much!
Hey Quabbe. Wauw, what a lovely message, thanks a lot. And yes Power Automate/RPA is great - it's straighforward, and the learning curve is fast 🙂 Have a great day. Kind regards, Anders
Probably, the most detailed and clear explanation for Power Automate anywhere. Thank you. Subscribed after watching this first video.
Thanks a bunch, @AhmedBalfaqih 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: ruclips.net/video/xWFz-S96XGo/видео.html You're more than welcome. Kind regards, Anders
Excellent Lesson and I learned so much - now to develop this to sort and move files in my Onedrive that has become very messy over the years - thanks again
Very nice, Shaun. Working on private projects while learning is so great 😊 Thanks for the nice words. Kind regards, Anders
Thank you Anders! As a Power Automated beginner user, your videos have helped me a lot in the first steps
Thanks a ton, Fernando Silva 🤩 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Your teaching style is AWESOME!
Thanks a lot, @theprofessor4487 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Dear Mr. Jensen. Excellent tutorial. Thanks for sharing.
Thanks a lot, @jalonnun1 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Amazed on the things you can learn with this app, thank you, great lesson!
Hey KelsC - I'm so happy you enjoy it 🙌😀 Thanks a lot for commenting. Kind regards, Anders
Thank you for your work putting these lessons out there!🙂
My pleasure! Thanks a lot for the supportive comment 😊
Another good learning experience. Very clear. Thanks for sharing!
Thanks for you nice support - highly appreciated 😊 Kind regards, Anders
Thank you, for this very good video.
Thank you so much, Alvin 😍🙋♂️
Watching this tutorial is satisfying too!
Thanks for letting me know 🙌😊 Kind regards, Anders
Brilliant tutorial as always Anders. I have learned so much!
Hey Dave, thanks for all your nice comments - highly appreciated 🙌🙂 Have a great day. Kind regards, Anders
Hey anders,
I have started watching your videos on power automate for the past one week and I'm truly impressed with the way you are explaining stuff. What do you think is the correct approach for me to pursue my career in Power automate RPA.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Really nice tutorial! Just adding a note here to help people that might use this video for a real case scenario, taking care of the upper case in the extension could save you some trouble! :)
For the Switch condition: toLower(%File.Extension%)
Thanks a lot, MaxCriant. And you're right 😊 It's because because yesterday I made this: ruclips.net/video/bXqSjLCSLEg/видео.html, which solves what you're explaining. Kind regards, Anders
Fantastic video again!
My pleasure, xnbet - thanks for commenting 🙌
I am enjoying your videos, please make videos on all actions of power Automate Desktop
Thanks a ton - and that's on my 2023 roadmap 😊
@@andersjensenorg
Will you teach new topic that is VB SCRIPT
Very good - Thanks!
You're very welcome, Harjit Samra - your support helps me a lot 😍
How do you run it in production in unattended mode?do we need to run on machine running on 24x7?
Hey brijendraydv. Great question. Then you need to buy an unattended licence, which, I think, is $40/month. You need to run it in an environment, so yes a machine, VM or a server etc... Kind regards, Anders
Thank you so much. Very good video !!!
Hey Pitak N. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great tutorials but I'm having trouble finding how to extract files from a folder and copy them into another folder but only extracting the files listed in an Excel sheet?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Very detailed
Thanks a ton, Stephen Karas 🤩 Have a great day. Kind regards, Anders
As a starter for this I must say that you create Really good stuff. Highly apprecitated. Is there a Way to keep track of filés that are copied from one place to another if you have a Hugh amount of filés and you don`t want to copy them twice? Subscribing from now on, Thank you
Hey True Viking. Thanks a lot 😍 We don't move them twice, but we add them to a list for logging purpose. Let me know, if you want a more detailed explaination. Kind regards, Anders
@@andersjensenorg Thank you for your quick reply. I understand the general idea of writing a log for this flow. Then I also asume that one of the first things to do is to read the logfile. Thanks again for the reason that you share youre knowledge
@@truewiking Yeah, or maybe the best approach to a log, will be to only read the errors happening. Else you get a lot of logs to read 😀 So an example of how to create a simple log.
@@truewiking The logfile created isn't used in processing the files. It's only for the user to inspect later if they want so see the names/quantities of files moved.
@@harjitsamra Thanks for your input. I get the concept of the log file. What i was thinking about was reading from that log file to see what file i last read. Solved it with ”if file exists” instead.
Do you have a video explaining how to take all files in a folder and send them as email attachments?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Awesome 🔥🔥
Can it work on Linux too?
Thanks a lot, S. Windows only 🙂
Hi Anders,
I'd like to know how to copy folder and subfolder names into an excel file, only the name without path.
I have a shared folder called 'Customers' and my coworkers can place new projects inside each customer folder. Every moth I'd like to run a flow and count each customer project inside folder and make a list like this one but in excel.
Hey Davi Rodrigues Kawagoe 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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
Hi Anders, is possivel to reference only first five files into folder list? I would like to rename them. Thanks so much🙂
You could set a variable before the loop, and increment it inside the loop. if it is greater than 5 then don't carry out the processing. You can't actually exit the for each - current limitation
@@harjitsamra thank so much for your help 🙌
Thanks a lot for you help 😊
Hi Anders,
Hope you’re doing well !
I have received a requirement in which I have to read approval through Email , as it is not feasible as People may send different reply for Approval.
So, Now we are planning to send an Excel file with a dropdown to Approve and Reject.
So , Now the Bot will have to download Excel and read the responses .
Is it possible?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
How to get a current active window folder path? I am looking for solution to create several folders in a current window
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 7000+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Nice but my case is: I download a serie filename: FunnyS01E01.mkv. I want to move this file to an external hd. The filepath on this hd is Funny. The sub dir is S01. Here I want my file. Next time its an other filename but same structure. Is this possible?
Hey Inge W 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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
Enjoyed! Liked!! Subscribed!!!
😉
Hahaha, thank you so much 🙋♂️🙂
how to iterate through all links in a table of a web page without knowing end value
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
What's your honest oppinion on Power Automate vs UiPath? Which one is better?
Hey Thomas. It depends. Power Automate is cheap and already in people's microsoft suites, but UiPath is the most advanced RPA tool (by far). Kind regards, Anders
I just watched one lesson and it was explained very well so moved to next lesson and next lesson and now I am half way done. I am going to watch all the lessons. It's very informative, detailed and very nicely explained. Awesome course work @andersjensenorg
You're very welcome, @chirantanupadhyay2375 - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html
i am glad i found this solution really amazing
My pleasure 😊🙌
Best walkthrough on the internet. Got my flow running without issue and learned quite a bit! Thank you, Anders!
Hey Jordan, thanks a bunch 😍🙂 Kind regards, Anders