Move a latest file from download folder with complete dynamic name

[Hou_Paang_Soul]

Hi guys! I am trying to move a freshly downloaded file from the download folder. However, the Excel file has a complete dynamic name. The good thing is that I only downloads one file so the file will always be at the top of the download folder. May I know how do I write my Move File activity so that I can get the file into another location? Thanks!

[lrtetala (Lakshman Reddy)]

Hi @Hou_Paang_Soul
Try this

sortedFiles = fileArray.OrderByDescending(Function(f) New FileInfo(f).CreationTime).ToArray()
latestFilePath = sortedFiles(0)

or use

[Hou_Paang_Soul]

Hi! for the second method, what should I put into the from section? is it Currentfile? Thanks!

[lrtetala (Lakshman Reddy)]

@Hou_Paang_Soul

In From section give
CurrentFile.ToString

In To section give the folder location where you want to save the file

[supriya117 (Supriya Allada)]

Hi @Hou_Paang_Soul

You can get the file by using this expression since you know the type of file:
str_filepath = Directory.GetFiles(folder_path,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Tolist(0)

Later you can give the str_filepath variable in move file activity.

Hope it helps.