How to check file name?

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

Hi @fairymemay

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

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

1 Like

Sequence.xaml (11.0 KB)

Check the workflow

1 Like

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

UseCaseUpdateExcel.zip (21.0 KB)

Here is the solution, please find the zip file.

1 Like

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

1 Like

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