How to get the last downloaded xlsx file from the Folder

[dmitroika1 (Lekan Oye)]

Hi guys, I created a workflow to copy the latest downloaded excel file from my download folder to the required destination. However, I’m getting an error when I used the workflow.

Workflow credit : ashley 11

str = String.Join("",Directory.GetFiles(Path,File_Type,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) )

Thanks!

[wusiyangjia (Siyang Wu)]

Hi @dmitroika1

Change the Path to “C:\User\fred\Downloads”

[pattyricarte (Patty Boy)]

Hi @dmitroika1
What error did you encounter ?

cheers

Happy learning

[Schirru]

Hi @dmitroika1

If i got it right what you want is to get the latest downloaded file in an spefic folder. When you use the method Directory.GetFiles, the first argument expected is the path of the spefic folder that you want get the files, what you are passing is the path of the file instead of path of the folder. Change the “Path” variable to “C:\User\fred\Downloads” as @wusiyangjia suggested and it should work.

Happy coding! =)

[dmitroika1 (Lekan Oye)]

Thanks guys… it worked!!