How to move/copy latest downloaded excel files?

@Muhamad_Izwan_Bin_Hamran

Craete the variable by clicking the (+) icon

@Muhamad_Izwan_Bin_Hamran

Hit on + icon and click on create variable

@Muhamad_Izwan_Bin_Hamran
Click on Create Variable

@Muhamad_Izwan_Bin_Hamran

To keep it simple …you have in built activities for the same…

  1. Use for each file in folder and provide the folder path…and select order by creation date descending in the options
  2. Inside that use move file activitiy and in from field provided currentfile.FullName and in to field provide the destination location
  3. After move file activity use a break activity so that after first file is moved the for loop will end

Cheers

image

How about Value to save ?

Directory.GetFiles(yourfolder_path,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Tolist(0)

Replace yourfolder_path with the downloaded Path.

@Muhamad_Izwan_Bin_Hamran

This is how it looks

cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.