Answered

Move files to folder based on filename

(0) Share

Report

Posted on by TimMuenz

Hi,

I am trying to move files from a local folder (no cloud) into a set of local folders, depending on the file name, with Power Automate Desktop.

So e.g. filename could be CUS1000_Invoice_1234. That file should be moved into folder "CUS1000", ideally into the subfolder "Invoice" (optional).

I have seen a few solutions with Power Automate (Cloud) using the split function etc. but none for the Desktop version.

I do appreciate any help.

Best regards, Tim

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Highboy 1,187 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can use Split text to create a list

This will produce a list with three elements, that you can use to move the files to the folder you want.

You can paste the text below into PAD to see the example

Folder.GetFiles Folder: $'''c:\\test''' 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 CurrentFile IN Files
Text.SplitWithDelimiter Text: CurrentFile.NameWithoutExtension CustomDelimiter: $'''_''' IsRegEx: False Result=> TextList
File.Move Files: CurrentFile Destination: $'''c:\\Movedfiles\\%TextList[0]%\\%TextList[1]%''' IfFileExists: File.IfExists.DoNothing MovedFiles=> MovedFiles
END

Was this reply helpful? Yes No
TimMuenz 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks, that looks promising. Do you know how to apply this to each of the retrieved files i get from the folder?

Was this reply helpful? Yes No
Highboy 1,187 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It will do it for all files in the folder, unless you specify a "File filter"
The Get files, will get all files in a specified folder
The "for each" loop will travel through the list of files.

Was this reply helpful? Yes No
Jayaram_B 2 on at

Like (0)

Report
Copy link

Link copied!

If you provide how you did that approach on cloud, that will be useful for me.
Thanks in advance

Regards,
Jayaram B

Was this reply helpful? Yes No