Select an upload file from another folder

[Fauzan_Marantama (Muhammad Fauzan Marantama Raharjo)]

Hi, I have a problem with my build
so I want to upload an excel file that is already processed beforehand with the robot to our internal system
When I want to upload, there will be a pop up to select a file

the problem is, I want to upload a file that is not in the download folder (the path will be like this D://user/fauzan/document/folder a/folder aa/)

and after that, I want to upload the most recent file in the folder

How can I solve these 2 problems?

Thank you in advance

[Srini84 (Srinivas Kadamati)]

@Fauzan_Marantama

To Get the path of the latest file from the directory, use below

String.Join(“”, Directory.GetFiles(FolderPath,“*.py”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) )

Here *.py will be replaced with your file extension you want

Hope this helps you

Thanks

[Fauzan_Marantama (Muhammad Fauzan Marantama Raharjo)]

how about redirecting the open dialog to select a file to go to the specific folder? because in default it will go to the download folder

[Srini84 (Srinivas Kadamati)]

@Fauzan_Marantama

It’s not required to redirect, Use Type Into activity, Indicate the File name Text box to that, There you can type the entire path of the file and click open

It will works

Hope this helps you

Thanks

[Fauzan_Marantama (Muhammad Fauzan Marantama Raharjo)]

from the code
String.Join(“”, Directory.GetFiles(FolderPath,“*.py”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) )
folderpath will be removed by my folder path (ex: D:\documents) and *.py will be replaced with the file format right?

[Srini84 (Srinivas Kadamati)]

@Fauzan_Marantama

Exactly

FolderPath-> The folder you need to search for the latest file
*.py → This will be your file format you want to filter in all type of files

Hope this helps you

Thanks

[Fauzan_Marantama (Muhammad Fauzan Marantama Raharjo)]

Okay will try this later, will be marked as solutions if there is no further problem, thank you

[Fauzan_Marantama (Muhammad Fauzan Marantama Raharjo)]

@Srini84

“”, Directory.GetFiles(FolderPath,“*.py”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1)

Still doesnt work, i already put what you said in the activities like this

but the outcome are just the folder location

[Srini84 (Srinivas Kadamati)]

@Fauzan_Marantama

already put what you said in the activities like this

@Fauzan_Marantama

Can you make entire expression into a message box and check what is file path you are getting

Thanks

[Fauzan_Marantama (Muhammad Fauzan Marantama Raharjo)]

After trying it again, it now worked without a problem
Thank you
marked as solution