How to check file name?

[fairymemay (noona)]

I want to check file name (after _) and add Y in column Datetoday and row follow file name as below.

[AdityaVN (Aditya Vaddiraju)]

Hi @fairymemay

to get file names in a folder, check out the below post.

Move File from one folder to another in uipath studio activities

do you mean file names in the destination folder ?? you can use same method as mentioned by @NIVED_NAMBIAR and @postwick but for loop with destination folder follow below pseudo code for each item in Directory.GetFiles(Destination_folder_path) FileName = New FileInfo(item) message box FileName.Name variable FileName variable type is FileInfo (Browse for type System.IO.FileInfo in variables panel) note that, to get file name we need to give FileName.Name (i.e. var_name.Name) and not Fi…

regarding add Y to the column logic, are you updating Y in a different excel?

[shaik_Azam (Shaik)]

Sequence.xaml (11.0 KB)

Check the workflow

[ermanoj3101 (MANOJ)]

Let me try if i can provide you a solution in workflows.

[ermanoj3101 (MANOJ)]

UseCaseUpdateExcel.zip (21.0 KB)

Here is the solution, please find the zip file.

[sai_krishna_somisetty (sai krishna)]

Use “Path Exists” activity to know the file exists in particular path or not.
Ex: “C:\documents\report_”+row(“username”)+“.xlsx”