UiPath | How to open some or all files in a folder | Tutorial

[@andersjensenorg]

Check my new UiPath RPA Beginners Tutorial (+2 hour): kzbin.info/www/bejne/aYuuq4d-mdWmitU

[@robsongoncalves9377]

Congrats man !!! Amazing video ! Tks for sharing with us !

[@andersjensenorg]

Thank you, Robson 😊

[@cristianhendel6944]

Thanks for sharing, it was just what I was looking for.

[@andersjensenorg]

Hey Cristian. Great and thank you very much for letting me know 😊 Kind regards, Anders

[@lucyesoque2614]

Gracias Anders Jensen, fue puntualmente educativo.

[@andersjensenorg]

You're very welcome, Lucy ¿eso qué? - your support helps me a lot 😍

[@kristiannemagro466]

First of all thank you so much for your time doing these tutorials. I have a question, I need to search in a folder for a specific file that is saved in a variable.

[@andersjensenorg]

Hey Kristianna. What you want to do is first to loop through your files in a For Each with the directory.getfiles etc. Then you can make a an if inside the For Each, where the condition is "path.GetFileNameWithoutExtension(item) = yourVariable". In the Then branch you can have your actions 🙂 let me know, if that helped? Kind regards, Anders

[@kristiannemagro466]

@@andersjensenorg Thank you so much for your reply, basically I need the robot not to move the file if multiple files are found with that name, And move only the file if there is one file name that matches it.

[@andersjensenorg]

@@kristiannemagro466 Exactly. That's what I described. with the getfilenamewithoutextension etc. Try to build it and place the move inside the If. I'll gladly help, so just post, when/if you run into a wall 🙂 Kind regards, Anders

[@kristiannemagro466]

@@andersjensenorg Worked fine :) thank you so much for your help :D

[@andersjensenorg]

Awesome 🥳

[@andyyeo5757]

Excellent video, Anders. I have a request: how can I copy a folder from SharePoint and save it to my desktop using UiPath Studio? After I processed the files in the folder, I also want to put the folder back to SharePoint Would it be possible for you to do a video on this?

[@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 4900+ 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

[@jeniferantony2314]

Hui Anders, It works Thank you

[@andersjensenorg]

You're very welcome, Jenifer Antony - your support helps me a lot 😍

[@firamidafatahillah7916]

Hi Andre,, that's great tutorial, I have a question, i need to open a file ( .xlsx or .txt ) based on date ( example : Today, or Day + 1 )

[@andersjensenorg]

Hey Firamida Thanks for the nice words and for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@monsorroman8216]

Useful

[@andersjensenorg]

Hey MONSOR. Thanks a lot :) Tomorrow I'll upload a video, with a lot of file handling (and regex + pdf automation). Kind regards, Anders

[@nightowlmusic3905]

Hi anders, can you make a tutorial of upload multiple files by string in a browser?

[@andersjensenorg]

Hey Nightowl. Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@23Ashishonelove]

Thanks, Anders for this video. I searched a lot with respect to the opening on two different files using directory.getfiles command but didn't get. Your video solved my problem. I have one question. getFiles=Directory.GetFiles(in_TransactionItem,"*.pdf").Concat(Directory.GetFiles(in_TransactionItem,"*.doc")) where getFiles is an array of strings, I get the error as "Process.xaml: Cannot assign from type 'System.Collections.Generic.IEnumerable`1[System.String]' to type 'System.String[]' in Assign activity 'Assign'." But it works files inside a for a loop. Please advise how to proceed if I take it as an assign activity?

[@LuanaBudanna]

Hi, where you able to figure it out? I have the same problem.

[@23Ashishonelove]

@@LuanaBudanna I left learning Uipath Last year

[@andersjensenorg]

Hey Ashish Verma Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@gurramsaiviswanath8921]

I had developed some codes ..after few days i will go to local folder and clicked whatever I developed. but it's not opening in uipath tool it's navigating microsoft egde what the problem how can I open

[@andersjensenorg]

Hey Gurram Sai Viswanath 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 UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@shobhar7507]

How to open latest downloaded Exel file from folder using uipath

[@andersjensenorg]

Hey Shobha. You can use the solution in the video and in the expression of the getfiles, you just append it with the following: Directory.GetFiles(strPath,".xlsx",SearchOption.AllDirectories).OrderByDescending(Function(s) New FileInfo(s).CreationTime).Take(1) Let me know if that solves your question 😊 Kind regards, Anders

[@ks-nn5ob]

How to count the number of specific files present in a folder and give the output in a notepad???? Please give the answer

[@andersjensenorg]

Hey Suneel. Yes, for sure. Check this: kzbin.info/www/bejne/qaGYi6p8gMubY5I (fast forward to 1:32:02), where I solve for exact that. Let me know, if that helps? Kind regards, Anders

[@zaidansari-zr1ti]

if i want to get all files in a particular folder of drive can you help with something ?

[@andersjensenorg]

Hey Zaid. Sure. Watch the video, we use the Directory.GetFiles(strYourFolderPath) and then a For Each. Kind regards, Anders

[@zaidansari-zr1ti]

@@andersjensenorg hi Andrew I am talking about files of google drive not local drive via using find files and folders gsuite .

[@sivasankar566]

But it's showing error for me in assign activity

[@andersjensenorg]

Hey siva sankar Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@AndrewzOnAir]

it doesn´t work for me, i am trying to open 10 files of excel which belongs a one folder buy uipath just open two files and then it apper a error. :(

[@andersjensenorg]

Hey Andres. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@AndrewzOnAir]

@@andersjensenorg Congratulations on the birth of your baby!

[@addictgaming4983]

I just need advice from you guys in Uipath I am having 70 images in one folder I need to open those image one by one in ms paint and save the image in same path.. Can anybody give some tips...

[@andersjensenorg]

Hey Abdul. The easiest thing would be to get the file names with a For Each (string) and then file in Directory.GetFiles(strYourFolderPath,"*.jpg"). Now you got the file names and they can be open, edited and finally saved the same place. Did that help? Kind regards, Anders