Easily Rename All Files In Folders (NOOB vs PRO) & rename files based on an Excel table with PAD
ฝัง
- เผยแพร่เมื่อ 15 ก.ค. 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
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.
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.
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!!!
If people follow your tutorials, they will save at least a couple of days worth of time.
You are literally adding lifespan to people🤣
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}
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! 👌😄
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
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
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!
Leila, your videos never cease to amaze me!
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.
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 👍👍
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!
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.
You are so awesome Leila. I can stop smiling whilst watching and listening to you. Cheers
Just discovered you a few days and i´m in love! Thank you for your content!
Excel is really the most powerful tool i came across...we can continue learn it whole life...thanks leila for this awesome video
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! 😍
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.
lucky to have you to teach. thanks. I will learn as much as possible about this tool
I've been looking for something like this for years. Thank you Leila!
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!!!!!
Hi Leila, excellent video! Have you any plans to create a comprehensive course on Power Automate? 🙂
Right on time Leila. I needed to rename 5000 files and you come up with that. Big thnx.
This is groundbreaking stuff Leila! Good job with the handholding as this can be intimidating
Content absolutely priceless! Thank you!
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.
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 !!!
Best things learnt this year. Thanks.
Leila, you are the GOAT of this stuff. Thanks so much
Thanks Leila ... awesome task done in superfast time. Thanks for this tutorial.
Powerful tool. Could make life easier for a lot of people. The only problem I see is that you are not able to debug your programming before you commit the changes. For example windows Power Toys PowerRename utility has a preview window showing all the changes about to be applied before you actually commit them.
Agreed, You can make a mess quick if you don't have the flow set up perfectly
Incredible! I never heard of this tool! Your youtube channel is amazing! Thank you!
That was a fun video, and very useful too. I'll definitely explore this further. Many thanks for a great idea.
Leila - this is a game-changer ! Thank you for the primer.
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.
You are very competent with communicating and explaining this subject
You're a lifesaver! thank you for sharing helpful content!
Leila, you are the best! Thanks for sharing this tool.
- 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.
Thanks to Leila for showing this to the people of TH-cam. 🙏🏽
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.
👍
Just installed Power Automate and successfully changed files names!
Great tool!!! 👍👍👍
Thanks for the tutorial, much appreciated!
Great to hear!
Thank you so much for this video ! Clear & useful, nothing to add, it s just perfect
Concise and precise. Thank you very much!
you are simply awesome. Thank you for making such wonderful videos and enlightening us with tools that make our life easy. God bless you.
Awesome automation. 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.
Thanks Leila for such valiable content!!!
Great video! I was able to use your tutorial to update file extensions for a migration project.
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.
Wow, very interesting! Thanks, Leila!
Usefull and smart video, as usual
Thank you very much, always love all your videos.
What an awesome tool!!! Thanks.
Awesome tips always, thank you so much! 👏👏👏👏🌹🌹🌹🌹
Love your work Leila
Recently I have done these task with the help of command prompt this is more easier and user friendly than power automate and even more faster than power automate
Agreed CMD can be fast but at times you want UI to do the job by giving instructions rather than writing shell script.
windows?
@@saradhiananth1613 yes
@@harshindublin you can create an excel template to write the script dynamically tho. And it's super easy script not a complex one
For the first part of the video: 100% agree with you.
For the 2nd part, how do you replace "ID" by "name" in the filenames with command prompt?
Great info, thank you!
This is amazing, thank you!
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!
Amazing!!! Another amazing tool developed by Microsoft. Thank you very much for sharing your knoledge. I will think where I can use this to automate processes in my work.
Great video as always! I have to start using Power Automate. Thank you again @Leila
Awesome video. Didn’t know that. Thanks for sharing.
This is really awesome tips, Thanks
As usual no words to appreciate your work ... thanks a lot
So nice of you
I learned something new .Thank you Laila !
WoW!! Mind blowing stuff
Fantastic! Thanks Leila!
Excelente, antes lo hice con macros pero este recurso es muy bueno. Gracias
Loved it! Good luck noob!!
Thank you very much Leila!
Entertaining and informative thank you 🙂
That is so awesome. Thanks for the share.
Cant wait for your advance tips for this app. Really need help setting up the connectors.
Great one
Would love to see a complete course on power automate
Really useful video... thank you
Love her! Great teacher!
Very cool. This is visually programming steps. I was just going to write my own program to do this.
Great feature - thank you 👍😃
You explain very well, please make more videos for Power Automation 🙂
Great, power automate has always baffled me great to see how it could be used.
I would have hanged the file name in the excel file too to be tidy.
Hi, Leila, You are lucky to have such a nice helper! Thanks for sharing! Stay healthy!
Thanks, Jon! You too!
Great video, as usual. Oh, and I like seeing this Noob. From time to time, that's refreshing.
Glad you enjoyed it!
ليلي عبارة عن نحلة مليئة بالعسل.. شكرا علي كل ماتقدمية 🌹👋
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!
Great explanantion and used of Power Automate 👍
I love you for this!
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.
Hey leila this is fun and engaging 💞
Thanks Leila, it works for me, but I used it to rename folders, using Excel to get information from those folder names to rearrange and rename them
That's fantastic, thanks alot.
Nice info and explanation.
Thank you Leila and Noob! Love the video!
Glad you enjoyed it, Mike!
Awesome😀
Wonderful information 😊
As always you Rock!
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.