I have one automation where bot will download file from one application and will be stored in particular location.
File name is also created by bot. By using file name I am trying to search file in folder. My issue is even though file is present bot is not able to find file.
I am using below formula’s(neither of them is working) -
1 - Directory.GetFiles(in_Config(“COL_CTRIPM_EPP_ExtractFileRoot”).ToString,strTCID+““+environment.UserName+””+Today.ToString(“yyyyMMdd”)+“_*_EPP_OK.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime)
2 - new DirectoryInfo(in_Config(“COL_CTRIPM_EPP_ExtractFileRoot”).ToString)
idirectory.GetFiles(strTCID+““+environment.UserName+”__EPP_OK.xlsx”).Where(function(file) file.LastWriteTime.Date= DateTime.Now.Date).OrderByDescending(function(d) d.LastWriteTimeUtc).ToArray
Could you please suggest any solution