How to get filepath based on specific keyword

Help Activities
, ,
5

Hi @Raja.G ,

You may try the following solution:
Step1: use “Excel application scope” activity to read the excel file and drag “Get workbook Sheets”. it will store all the sheets in a list of strings.

Step2: For each loop, Directory.GetFiles(“FolderPath”)
Step3: in the same container, use an if activity with the condition:
mySheets.Any(function(f) file.Contains(f))

This image depicts a flowchart in UiPath Studio, illustrating the process of opening an Excel file, retrieving its sheets, and checking if files in a specified directory match certain conditions, displaying a message box if they do. (Captioned by AI)
This image depicts a flowchart in UiPath Studio, illustrating the process of opening an Excel file, retrieving its sheets, and checking if files in a specified directory match certain conditions, displaying a message box if they do. (Captioned by AI)552×726 36.1 KB

FilePathFinder.xaml (11.7 KB)

Please refer to the attached solution and let me know if it works.

Thank you,
Anjani

1 Like