How to pick up the excel file having dynamic "date and also system Time"

please check the image below:


As per image:

  1. there are 6 files(200,201,400,500,600,601) that are created dynamically when the bot ran for 3 times. (so totally 18 files are created dynamically)
  2. we need to pick each file based on recent creation time.

please help me with this requirement.
regards.

HI @Manoj_sreekanth

Checkout this expression in for each activity and loop through the files

If your downloaded files will be download means use the below

Directory.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder.UserProfile) + "\Downloads").[Select](Function(x) New FileInfo(x)).Where(Function(f) f.Extension.ToLower.Equals(".xlsx")).OrderByDescending(Function(x) x.LastWriteTime).ToArray().ToString

If not in download means you need to change the folder path in the expression

Directory.GetFiles(FolderPath).[Select](Function(x) New FileInfo(x)).Where(Function(f) f.Extension.ToLower.Equals(".xlsx")).OrderByDescending(Function(x) x.LastWriteTime).ToArray().ToString

image

Regards
Sudharsan