Power Platform Community Forum Thread Details

I'm brand new to Power Automate and cant seem to google my way to an answer here. I download a new version of 10 different files every day and save them to a data folder. Each day I want to replace the old file. Each file downloads with the datetime on the end (always 19 characters). I want to automate the action of copying each of the 10 different files and pasting them into my data folder removing the datetime on the end and replacing the previous day's file. I wondered if textsplit might work but cannot see a way to utilise this within the file name and "rename file" does not seem to offer the amendments i need. Is it possible to do it this way? Is there a better way to go about this task?

Many Thanks

Categories:

Power Automate Desktop

I think that "Get file path part" and "Get subtext" actions could be used.

Folder.GetFiles Folder: $'''C:\\Downloads''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
LOOP FOREACH CurrentItem IN Files
 File.GetPathPart File: CurrentItem RootPath=> RootPath Directory=> Directory FileName=> FileName FileNameWithoutExtension=> FileNameNoExtension Extension=> FileExtension
 IF FileNameNoExtension.Length > 19 THEN
 Text.GetSubtext.GetSubtext Text: FileNameNoExtension CharacterPosition: 0 NumberOfChars: FileNameNoExtension.Length - 19 Subtext=> Subtext
 File.RenameFiles.Rename Files: CurrentItem NewName: Subtext KeepExtension: True IfFileExists: File.IfExists.Overwrite RenamedFiles=> RenamedFiles
 File.Copy Files: RenamedFiles Destination: $'''C:\\Downloads\\Dest''' IfFileExists: File.IfExists.Overwrite CopiedFiles=> CopiedFiles
 END
END

# [ControlRepository][PowerAutomateDesktop]

{
 "ControlRepositorySymbols": [],
 "ImageRepositorySymbol": {
 "Name": "imgrepo",
 "ImportMetadata": {},
 "Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}"
 }
}