Need help on vb code to get the latest file from folder

Help StudioX
1

Hi all,

I am new to UiPath Studio X. So I tried to use the following code to get the latest file from a folder.

System.IO.Directory.GetFiles(<[str_FolderPath]>,“.”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime.ToList(0)

However, when I tried to run the activities, it only showed the code instead of the actual file name.

Screenshot 2024-09-18 105823
Screenshot 2024-09-18 1058231243×739 34.8 KB

Any help is appreciated.

TWW

2

Hi @tww

Click on Open in expression editor and give your expression in that

The image displays a workflow sequence where a folder path is set, the latest file in the directory is determined, and a message box is used to display the latest file, with the expression editor option highlighted. (Captioned by AI)
The image displays a workflow sequence where a folder path is set, the latest file in the directory is determined, and a message box is used to display the latest file, with the expression editor option highlighted. (Captioned by AI)879×537 48.6 KB

System.IO.Directory.GetFiles(Str_FolderPath, ".", SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).First()

Regards,

1 Like
3

@tww

What is the type of ienum_latestfile

Also looks like it is string type and you would have given it as string

Just open advanced editor and paste the formula properly

Cheers

1 Like
4

Thank you for your help

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.