Comapare the File path in a directory with the input value from the Excel row

[mkankatala (Mahesh Kankatala)]

Hi @srinusoft37

=> Take an assign activity and store the File path in a array of string variable called FilePath.

Assign -> FilePath = Directory.Getfiles("Folder Path")

=> Take the Use Excel file activity and give the path of the file.
=> Inside use Excel file insert the for each Excel row activity. Output - CurrentRow
=> Inside for each Excel row activity insert the for each to iterate the FilePath (Array of String variable) Output - CurrentItem

- Condition -> CurrentItem.Contains(CurrentRow("EMP ID").toString)

=> In then block insert the Write cell activity
→ What to write : “Yes”
→ Where to write : CurrentRow.Byfield(“Status”)
→ Check the Auto increment option.

Hope it helps!!