Files and Folders in Power Automate for Desktop (Full Tutorial)

[@andersjensenorg]

LIKE AND SUBSCRIBE IF YOU ENJOYED 🙌🔥 Instagram: @andersjensenorg

[@Quabbe2]

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!

[@andersjensenorg]

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

[@AhmedBalfaqih]

Probably, the most detailed and clear explanation for Power Automate anywhere. Thank you. Subscribed after watching this first video.

[@andersjensenorg]

Thanks a bunch, @AhmedBalfaqih 🤩 I've created a Discord. We're more than 8000+ RPA developers networking and solving problems here: kzbin.info/www/bejne/roipq2CJbpuLfdE You're more than welcome. Kind regards, Anders

[@shaunrowley7230]

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

[@andersjensenorg]

Very nice, Shaun. Working on private projects while learning is so great 😊 Thanks for the nice words. Kind regards, Anders

[@febsil66]

Thank you Anders! As a Power Automated beginner user, your videos have helped me a lot in the first steps

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@theprofessor4487]

Your teaching style is AWESOME!

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@MacroVisionInsight]

Amazed on the things you can learn with this app, thank you, great lesson!

[@andersjensenorg]

Hey KelsC - I'm so happy you enjoy it 🙌😀 Thanks a lot for commenting. Kind regards, Anders

[@jordanmartens4291]

Best walkthrough on the internet. Got my flow running without issue and learned quite a bit! Thank you, Anders!

[@andersjensenorg]

Hey Jordan, thanks a bunch 😍🙂 Kind regards, Anders

[@APPALARAJUYADLA-dy5hv]

The best Channel to learn RPA

[@andersjensenorg]

Many thanks for the awesome words. Kind regards, Anders 😍💪

[@jalonnun1]

Dear Mr. Jensen. Excellent tutorial. Thanks for sharing.

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@mikikwan9555]

Watching this tutorial is satisfying too!

[@andersjensenorg]

Thanks for letting me know 🙌😊 Kind regards, Anders

[@sazzarello]

Another good learning experience. Very clear. Thanks for sharing!

[@andersjensenorg]

Thanks for you nice support - highly appreciated 😊 Kind regards, Anders

[@terrymorrison2969]

Thank you for your work putting these lessons out there!🙂

[@andersjensenorg]

My pleasure! Thanks a lot for the supportive comment 😊

[@daveys]

Brilliant tutorial as always Anders. I have learned so much!

[@andersjensenorg]

Hey Dave, thanks for all your nice comments - highly appreciated 🙌🙂 Have a great day. Kind regards, Anders

[@MaxCriant]

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%)

[@andersjensenorg]

Thanks a lot, MaxCriant. And you're right 😊 It's because because yesterday I made this: kzbin.info/www/bejne/mInUhJ2CeLh_e8k, which solves what you're explaining. Kind regards, Anders

[@wamshipabbisetty1456]

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.

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@brijendraydv]

How do you run it in production in unattended mode?do we need to run on machine running on 24x7?

[@andersjensenorg]

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

[@ZefasBi-Analytics]

i am glad i found this solution really amazing

[@andersjensenorg]

My pleasure 😊🙌

[@xnbet]

Fantastic video again!

[@andersjensenorg]

My pleasure, xnbet - thanks for commenting 🙌

[@ALVINMAN452]

Thank you, for this very good video.

[@andersjensenorg]

Thank you so much, Alvin 😍🙋‍♂️

[@davirodrigueskawagoe1784]

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.

[@andersjensenorg]

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: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@OnlyIasReader76]

I am enjoying your videos, please make videos on all actions of power Automate Desktop

[@andersjensenorg]

Thanks a ton - and that's on my 2023 roadmap 😊

[@OnlyIasReader76]

@@andersjensenorg

[@OnlyIasReader76]

Will you teach new topic that is VB SCRIPT

[@harjitsamra]

Very good - Thanks!

[@andersjensenorg]

You're very welcome, Harjit Samra - your support helps me a lot 😍

[@PitakYT]

Thank you so much. Very good video !!!

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@maxs364]

Hi Anders, is possivel to reference only first five files into folder list? I would like to rename them. Thanks so much🙂

[@harjitsamra]

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

[@maxs364]

@@harjitsamra thank so much for your help 🙌

[@andersjensenorg]

Thanks a lot for you help 😊

[@gemmabannister6575]

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?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@duesenberger]

Enjoyed! Liked!! Subscribed!!! 😉

[@andersjensenorg]

Hahaha, thank you so much 🙋‍♂️🙂

[@aesievers]

Do you have a video explaining how to take all files in a folder and send them as email attachments?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@dragon3602010]

Awesome 🔥🔥 Can it work on Linux too?

[@andersjensenorg]

Thanks a lot, S. Windows only 🙂

[@chirantanupadhyay2375]

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

[@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: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@truewiking]

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

[@andersjensenorg]

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

[@truewiking]

@@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

[@andersjensenorg]

@@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.

[@harjitsamra]

@@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.

[@truewiking]

@@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.

[@olesolo]

How to get a current active window folder path? I am looking for solution to create several folders in a current window

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@abdussamad4889]

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?

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ingewll]

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?

[@andersjensenorg]

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: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@stephenkaras1523]

Very detailed

[@andersjensenorg]

Thanks a ton, Stephen Karas 🤩 Have a great day. Kind regards, Anders

[@thomasbeng9016]

What's your honest oppinion on Power Automate vs UiPath? Which one is better?

[@andersjensenorg]

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

[@nareshkumar-qo9qy]

how to iterate through all links in a table of a web page without knowing end value

[@andersjensenorg]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders