I’m trying to develop a workflow which read the file names from the particular folder (dynamic) and should match each name against pre-defined file name list in excel file. Any file name which is present in the pre-defined excel sheet but not in the folder, should be noted and mentioned in another new excel sheet/file or body of outlook mail.
I’m done with discovering dynamic path folder and getting file names in to data tables, but facing difficulties on later part fo matching it against pre-defined excel sheet and keep noting if not found in folder, any help on this would be appreciated.
Folder (C:\Users\Administrator\Document\Test) has files : Test.txt, Test1.txt, Test2.txt, Test4.txt & Test6.txt
Pre-Defined Excel sheet (C:\Users|Administrator\Document\compare.xls) has row entry of Test,Test1, Test2, Test3, Test4, Test5, Test6 in column called “Data”
Now as Test3 & Test 5 name is there in the excel sheet but same file name not present in the file Folder, name “Test3 & Test5” should be noted and mentioned in another output excel file or else body of outlook mail.