Easily Rename All Files In Folders (NOOB vs PRO) & rename files based on an Excel table with PAD
Vložit
- čas přidán 1. 06. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
This easy-to-follow tutorial shows you how to rename multiple files efficiently using Power Automate for Desktop.
🛠️ What You'll Discover:
▪️ Step-by-step instructions on installing and using Power Automate for Desktop.
▪️ How to create a new flow for renaming system files, including setting up variables and specifying file paths.
▪️ Techniques for dynamically renaming files based on specific conditions, like adding a location name to file names.
▪️ Advanced tips on how to use Power Automate for more complex tasks like renaming files based on data from an Excel sheet.
Power Automate for Desktop (PAD) is a great utility that helps you program complex tasks without writing a single line of code. Renaming a few file names is easy in Windows Explorer. But what do you do when you have to rename many files in a specific folder? Or in many subfolders? You can use a tool you already have access to which is Power Automate for Desktop. You have it if you have Office 365 at work. There might be other bulk Rename Utilities available, some are free, some are paid but they either have limitations or they're costly. Other tools are good for if you know programming. With Power Automate for Desktop you can bulk rename files in one go.
You don't need to do any programming, you just need to drag and drop. It's super simple, even our Office Noob gets the job done.
Power Automate for desktop also allows you to rename files based on a logic. For example, you might have a mapping table for renaming files in Excel. With Power Automate, you can use the logic from the Excel file and loop through the rows and rename files in windows explorer based on that.
00:00 How to Rename Multiple Files
00:36 How to Get Power Automate for Desktop
01:07 Create a New Flow
02:22 Get All Files in a Folder
03:30 Rename All Files
04:36 Run Flow
05:12 How to Make Dynamic Replacements
06:38 Loop and Read From Excel File
10:09 Dynamic Renaming of Files
11:44 Run Flow
🎬 LINKS to related videos:
Web Scraping Made EASY With Power Automate Desktop: • Web Scraping Made EASY...
➡️ Join this channel to get access to perks: / @leilagharani
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#noobvspro #powerautomate #powerautomatedesktop
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
One of the challenges that I find with Leila's advice and tips that for those us who work in large corporations and government is our systems are locked down and by design, we're running a generation behind on the operating system and one to two generations behind on our office suite. The upgrade cycle is tied to budgets and risk management. We can't take advantage. My personal computer has Windows 11 and O365, but tend not to do officey things on it. This is not a problem for Leila to solve, but it does simultaneously lead to a frustration about being left behind and hope that things will be easier in the future. In the meantime, I have my 1994 DOS for Dummies book that sits on my desk for bulk tasks and batch files for doing some, but not all, of these automated tasks.
PowerShell. Shouldn't be locked out of that.
Portable apps 👍
@@patrickmeylemans9627 as long as you don't need a flash drive
@@j.ballsdeep420 that can be disabled in group policy for security.
Spot on! And for office 365 some gov orgs require on site NON-cloud software. Though I have heard there is hybrid for large orgs and gov. But yes. I have office 16 and 21 but not 365.
She mentioned talking to an Microsoft product manager so this channel maybe a bit of shilling channel. MS loves to push people to new products.
Like I noticed with the outlook search video she did for using the search function there was no mention that in older versions of office searching works live as you type each letter but an office 21 and it looks like 365 that feature is gone.
She could have ever make some videos for folks using older versions of office would open up her channel to other demographics and help people out
If people follow your tutorials, they will save at least a couple of days worth of time.
You are literally adding lifespan to people🤣
Thanks Leila. I knew about Power Automate, but it was really helpful to see it applied in a useful way. Videos like this will get you even more subscribers for sure.
Great content as always. Just a shortcut for the first task, Run powershell in the folder and enter the following command:
dir | rename-item -NewName {"Chicago_" + $_.name}
I had to do this recently, i just opened command prompt with cmd and ran a dir DOS command. With the results of the file list, i ran a ren (rename) command with the modified file name. (This works on any version of windows). A little search on dos commands will get you the job done.
true , lot less to learn
A few days earlier, I made a detailed step-by-step response implementing a DOS window and Excel spreadsheet to a post by a gentleman named Mustafa.
True. But people must eat every day, so...
you did this for the second one to replace the worker ID?
That's fine unless you are not a techie. Many are command line phobic.
I truly enjoy joining in all these comprehsensive curated courses out there which do so much to help us optimize our health and wellness, forgiveness and meditation, avoiding vulnerability in the workplace, getting more done in less time, even if we've haven't had enough restful sleep or a healthy nutritional breakfast because in the typical workplace these days, you're expected to get online early and start signing and returning documents, renaming all files in folders, and have them all done well in advance of COB (whatever that is anymore). Fortunately, many of these courses are brown bag lunch and learn events, which allow us to grab a sandwich while while we learn more from the life lessons learned by the host. Great job Leila!!!
Total Commander -> select files -> Files -> Multi-Rename Tool (Ctrl+M). Also a good search tool, synchronize directories, find duplicates...
I was going to comment that as soon as I see the video title :D
Can total commander do that?
Goodness just remembered this program ....
either way its all good
Yes! As always Leila is my savior. I've known about power automate and needed a tutorial on how to rename files. Before power automate I've been searching on how to rename files as this was a frustrating process to do. Luckily, I don't have a lot of files. BTW your videos are fun to watch. I love twin Leila 😁 and most of the time she represents me 🤣🤣🤣 Excellent performance. As always, thank you for sharing your expertise. Have a great day! ❤👍
Very cool idea! Thanks Leila! I think learning Power Automate is a must going forward! If you are launching a course, nothing like it! And well, you enacted both "Noob" and "Pro", so professionally! 👌😄
Excellent. I am embarrassed to admit it, but this is the first time I understand the power of Power Automate. Your videos are always great and educational. And cute!
Wow, it worked! I'm so happy that it's not complicated. Love your voice and tone, I can listen to you all day. You make complicated task into ease, love your calm clear guidance approach 👍👍
This video is one the most helpful tips I ever watched and learned. Unlike those horrible channels that just waste our times, This channel is so USEFUL. Please never stop. You are so pro. Thank you.
Loved this video!!! A definite help getting going with PA and completing these tasks that would have been still sitting on the ToDo List until we set up enough time to do this! THANKS! A Big Hug and great creative work!
Excel is really the most powerful tool i came across...we can continue learn it whole life...thanks leila for this awesome video
Great video introduction to Power Automate. One thing though. The first step should be to copy all the files to a new directory and rename from that directory. Otherwise, if you make a mistake in your Power Automate script you could lose all your files.
I would say better copy files manually as that process may also be in a mess if you make a mistake in your script
Copying only works if all the files are reasonably small. Otherwise, you could be waiting a long time just to create your temporary backup. I think it might be easier to just create a batch file to do the renaming. The first example shouldn't take more than half a minute, and the second two minutes. For a couple of thousands of files.
@@danielch6662 well you don't need to copy all files. You can just copy a couple of files for a test. If that works then you can run the flow against all other files.
If you don't have windows 11, then search for "Rname-it v3.1" It has been around since the 90's, it will do the same and has more functions.
Rname-it is a Win95/98/NT file renaming utility that specialized in batch
process renaming. It allows the user to select multiple files and rename
them all at once. Files can easily be organized and grouped by renaming
to a new common prefix and/or padded with a unique numerical or alphabetical
value for sorting purposes. Also features Real Time Preview and Full
(Final) Preview to ease the user in complicated renaming procedures.
Great for graphics collectors and webmasters!
you are missing the point, renaming is just a slice of what power automate can do? actually in this example she could have renamed in explorer without any tool
Leila, your videos never cease to amaze me!
Wow! I remember doing the first one few years ago. Good thing I knew how to work my way with VBA. This is like that but way easier. No codes to remember and write too have it running. Just awesome! 😍
Just installed Power Automate and successfully changed files names!
Great tool!!! 👍👍👍
Thanks for the tutorial, much appreciated!
Great to hear!
Hi Leila, excellent video! Have you any plans to create a comprehensive course on Power Automate? 🙂
- Open command prompt with
- press (Win) + (r), type "cmd" and press (enter)
- c: (enter) --- (or instead of "c* whatever the drive letter is that the files are on)
- cd "\some\folder" (enter) --- (to keep the command shorter)
- ren *.xlsx CompanyName*.xlsx (enter)
OR
- for %i in ("c:\some\folder\*.xlsx") do ren "%~i" "CompanyName-%~nxi" (enter)
Leave command window with
- exit (enter)
Job done.
I've been looking for something like this for years. Thank you Leila!
Just discovered you a few days and i´m in love! Thank you for your content!
A great tutorial 🙂 I agree with the DOS command option below (I am an old Guy....) but this brought me up to speed with PA Desktop which I have not seen for about a year and I am now inspired to get back with PA. It can do so much.
You are so awesome Leila. I can stop smiling whilst watching and listening to you. Cheers
Right on time Leila. I needed to rename 5000 files and you come up with that. Big thnx.
Content absolutely priceless! Thank you!
Wow, very interesting! Thanks, Leila!
lucky to have you to teach. thanks. I will learn as much as possible about this tool
Used to work for MSFT in the early/mid 90s. This reminds me of internal tools we would add to Windows and use in house. I have to admit, as someone who used to have to recover HD for MSDOS users on a telephone via edlin, this GUI is awesome. It essentially allows anyone to create some really nice batch scripts via the GUI instead of going to the command line. Nice to see MSFT still putting out useful development tools that can change the way end users at any level work.
Oh JESUS!! edlin.... EDLIN !!!!
Only those who've used it understand the PAIN !!!
This is groundbreaking stuff Leila! Good job with the handholding as this can be intimidating
Best things learnt this year. Thanks.
Awesome automation. Thanks for sharing 👍
Leila - this is a game-changer ! Thank you for the primer.
Oh, THATs impressive! Will take some mulling to work out how to impliment it at work, but I love the sound of this tool already.
That was a fun video, and very useful too. I'll definitely explore this further. Many thanks for a great idea.
You are very competent with communicating and explaining this subject
Incredible! I never heard of this tool! Your youtube channel is amazing! Thank you!
Awesome video. Didn’t know that. Thanks for sharing.
Oh God she is back with a stunning look and excellent short key. Just love the way you explain excel to us. Everyone including illetrate people's can easily benefit from your videos.
O.M.G, your step by step explanation is soooooo well structured, loving it, and a bug thank you to you for doing this
She explain very well!!!!!
Leila, you are the GOAT of this stuff. Thanks so much
Concise and precise. Thank you very much!
Leila, you are the best! Thanks for sharing this tool.
Thanks Leila ... awesome task done in superfast time. Thanks for this tutorial.
Great info, thank you!
WoW!! Mind blowing stuff
What an awesome tool!!! Thanks.
Thank you Leila and Noob! Love the video!
Glad you enjoyed it, Mike!
Thanks to Leila for showing this to the people of CZcams. 🙏🏽
Automating things had been for ages. Practically any programming language can be used to do so... But power automate do make it easier for everyone and specially for those who are not accustomed with coding. But then again you have to be good at creating steps of the algorithm.
👍
Thanks Leila for such valiable content!!!
Thank you so much for this video ! Clear & useful, nothing to add, it s just perfect
This is amazing, thank you!
I learned something new .Thank you Laila !
I have used Excel VBA to rename files which is easier. Dragging and dropping in a loop in the video etc, reminded me of my VBA code.
Automate would be very handy too. Thank you very much.
You're a lifesaver! thank you for sharing helpful content!
Interesting! I've used PCs since 1998 and taught Newbies one-on-one, yet never had a need for this. I'd just run the DOS ren command - after almost 25 years basic DOS commands still play an important role.
Loved it! Good luck noob!!
This is really awesome tips, Thanks
That is so awesome. Thanks for the share.
Very cool. This is visually programming steps. I was just going to write my own program to do this.
Great video! I was able to use your tutorial to update file extensions for a migration project.
Great explanantion and used of Power Automate 👍
Awesome tips always, thank you so much! 👏👏👏👏🌹🌹🌹🌹
Love your work Leila
Nice info and explanation.
Thank you very much Leila!
Great video as always! I have to start using Power Automate. Thank you again @Leila
Really useful video... thank you
Leila, excellent video! thanks. Upvoted!
Mind blowing... excellent video.. thanks for sharing
Thank you! Cheers!
Usefull and smart video, as usual
Thank you very much, always love all your videos.
Fantastic! Thanks Leila!
Hi, Leila, You are lucky to have such a nice helper! Thanks for sharing! Stay healthy!
Thanks, Jon! You too!
Entertaining and informative thank you 🙂
Great feature - thank you 👍😃
As usual no words to appreciate your work ... thanks a lot
So nice of you
you are simply awesome. Thank you for making such wonderful videos and enlightening us with tools that make our life easy. God bless you.
Love the pigtails!
excellent explanation, thanks a lot LG
Glad you enjoyed it!
Leila - You are something else! Your videos are fantastic - watch your Excel, PowerPoint and others. What a neat presentation in this video - Noob vs Pro!!!
Best to you! Hope to see more - I learn so much!
Great video, as usual. Oh, and I like seeing this Noob. From time to time, that's refreshing.
Glad you enjoyed it!
Wow, useful. Will make a note of this
Excellent tip!
Hey leila this is fun and engaging 💞
You know how I know that the Noob and the Pro are two different people? The Noob is taller! This is why I love this channel; the details! Thanks for introducing this very handy tool.
THIS IS NEXT LEVEL, love the NOOB
More videos with Mrs. Noob, please :-) And.. for boys and simply - Total Commander, Ctrl + M, counter, regular expressions and so on.
I made an Excel sheet to do that and it works perfectly without any other program
Great one
Would love to see a complete course on power automate
Great job, I am just beginning to get into power automate. Hope to see a lot more content.
More to come!
Thank you! Thank you for your no nonsense an waffle free style. Have had a lot of help and guidance from some of your previous videos.
You are so welcome, Kim!
That's fantastic, thanks alot.
I love you for this!
that was great info!!
As always you Rock!
Cant wait for your advance tips for this app. Really need help setting up the connectors.
You explain very well, please make more videos for Power Automation 🙂
ليلي عبارة عن نحلة مليئة بالعسل.. شكرا علي كل ماتقدمية 🌹👋