Easily Rename All Files In Folders (NOOB vs PRO) & rename files based on an Excel table with PAD
Вставка
- Опубліковано 6 сер 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.
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!!!
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}
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.
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 people follow your tutorials, they will save at least a couple of days worth of time.
You are literally adding lifespan to people🤣
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! 👌😄
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! ❤👍
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
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!
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!
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.
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! 😍
Excel is really the most powerful tool i came across...we can continue learn it whole life...thanks leila for this awesome video
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.
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 !!!
Just discovered you a few days and i´m in love! Thank you for your content!
You are so awesome Leila. I can stop smiling whilst watching and listening to you. Cheers
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? 🙂
Leila, your videos never cease to amaze me!
I've been looking for something like this for years. Thank you Leila!
lucky to have you to teach. thanks. I will learn as much as possible about this tool
That was a fun video, and very useful too. I'll definitely explore this further. Many thanks for a great idea.
This is groundbreaking stuff Leila! Good job with the handholding as this can be intimidating
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.
Right on time Leila. I needed to rename 5000 files and you come up with that. Big thnx.
You are very competent with communicating and explaining this subject
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
Leila - this is a game-changer ! Thank you for the primer.
Thanks to Leila for showing this to the people of UA-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.
👍
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 ... awesome task done in superfast time. Thanks for this tutorial.
Leila, you are the best! Thanks for sharing this tool.
Great video! I was able to use your tutorial to update file extensions for a migration project.
Leila, you are the GOAT of this stuff. Thanks so much
Best things learnt this year. Thanks.
Concise and precise. Thank you very much!
Incredible! I never heard of this tool! Your youtube channel is amazing! Thank you!
Very cool. This is visually programming steps. I was just going to write my own program to do this.
Just installed Power Automate and successfully changed files names!
Great tool!!! 👍👍👍
Thanks for the tutorial, much appreciated!
Great to hear!
You're a lifesaver! thank you for sharing helpful content!
Content absolutely priceless! Thank you!
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.
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.
Awesome automation. Thanks for sharing 👍
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!
Cant wait for your advance tips for this app. Really need help setting up the connectors.
Awesome tips always, thank you so much! 👏👏👏👏🌹🌹🌹🌹
Great one
Would love to see a complete course on power automate
Usefull and smart video, as usual
Thank you very much, always love all your videos.
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?
Thank you so much for this video ! Clear & useful, nothing to add, it s just perfect
you are simply awesome. Thank you for making such wonderful videos and enlightening us with tools that make our life easy. God bless you.
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!
More videos with Mrs. Noob, please :-) And.. for boys and simply - Total Commander, Ctrl + M, counter, regular expressions and so on.
What an awesome tool!!! Thanks.
Thanks Leila for such valiable content!!!
This is really awesome tips, Thanks
Wow, very interesting! Thanks, Leila!
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.
That is so awesome. Thanks for the share.
You explain very well, please make more videos for Power Automation 🙂
- 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.
Great info, thank you!
Awesome video. Didn’t know that. Thanks for sharing.
Fantastic! Thanks Leila!
Love your work Leila
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!
This is amazing, thank you!
Entertaining and informative thank you 🙂
As usual no words to appreciate your work ... thanks a lot
So nice of you
I learned something new .Thank you Laila !
Thank you Leila and Noob! Love the video!
Glad you enjoyed it, Mike!
Great job, I am just beginning to get into power automate. Hope to see a lot more content.
More to come!
Loved it! Good luck noob!!
Great video as always! I have to start using Power Automate. Thank you again @Leila
Really useful video... thank you
Hey leila this is fun and engaging 💞
Great feature - thank you 👍😃
Nice info and explanation.
Excelente, antes lo hice con macros pero este recurso es muy bueno. Gracias
Brilliant video! Just saved me tons of time :)) Interesting to test if it is faster than the previous method of DOS commands like 'ren'
WoW!! Mind blowing stuff
Excellent tip!
Great explanantion and used of Power Automate 👍
Love her! Great teacher!
Thank you very much Leila!
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
Brilliant! I'd like to see more examples of what we can do with Power Automate 😃
More to come! I have a few other examples already on the channel in case you're interested.
Great video, as usual. Oh, and I like seeing this Noob. From time to time, that's refreshing.
Glad you enjoyed it!
Hilarious and super useful. Normally I would write some VBA for something like this. Looks a bit more interesting to try Power Automate.
Wonderful information 😊
That's fantastic, thanks alot.
Wow, useful. Will make a note of this