The following problem:
I want to rename the files in a folder so that they contain the creation date and a numbering per day
Currently it numbers the files in the folder without considering the creation date how can I change it like this
Example:
10_06_2024 Nr.01
10_06_2024 Nr.02
10_06_2024 Nr.03
11_06_2024 Nr.01
11_06_2024 Nr.02
etc.
please ignore point 2-4 it is for later integration
Thanks 🙏
Hi @niklas_haar !
Try out this flow.
The code (simply copy paste into your PAD flow):
Share
Report
All responses (
Answers (
1,714
SET nCounter TO 1
Variables.CreateNewList List=> CreationDateList
Folder.GetFiles Folder: path FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.CreationTime SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
LOOP FOREACH File IN Files
SET CreationDate TO File.CreationTime
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CreationDate CustomFormat: $'''dd_MM_yyyy''' Result=> CreationDate
IF Contains(CreationDateList, CreationDate, True) THEN
IF nCounter < 10 THEN
File.RenameFiles.Rename Files: File NewName: $'''%CreationDate% Nr.0%nCounter%''' KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
ELSE
File.RenameFiles.Rename Files: File NewName: $'''%CreationDate% Nr.%nCounter%''' KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
END
Variables.IncreaseVariable Value: nCounter IncrementValue: 1
ELSE
Variables.AddItemToList Item: CreationDate List: CreationDateList
SET nCounter TO 1
File.RenameFiles.Rename Files: File NewName: $'''%CreationDate% Nr.0%nCounter%''' KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
Variables.IncreaseVariable Value: nCounter IncrementValue: 1
END
END
Input (Before):
Output (After):
I hope this helps.
