Unanswered

Rename File Using Excel File

(0) Share

Report

Posted on by frasercotton

I start off by using power query to get all the names of files within the folder. Then I use power query to add a column with how I want the file to be named (ie. "01.01.01 Name.pdf" > "Name.pdf"). Now using the two columns in Excel I'm trying to rename the file that match within the column and rename them to the new name in the second column. Please see my attachment - any help would be greatly appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

frasercotton 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @frasercotton ,

Do you want to rename files that match column1 to the new name in column2?

Based on your description, I have made a simple test for your reference.

Here is the flow:

Result:

Best regards,

Was this reply helpful? Yes No
frasercotton 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni it needs to work within subfolders as well? Any ideas

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @frasercotton ,this is a Desktop Flows forum and solution shared above is of Cloud Flows. Which one are you looking for?

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, I saw your second screenshot and it contains Desktop Flows.

So here it is...

Since you have to rename multiple files with different names you cannot pass the entire %Files% datatable at once. Pass one file at a time.

In line #6, use as below. Take care about the file extensions if it is needed.

You can also have the folder path "C:\Test\" inside another variable like %FolderPath%%OldName%

Post back how its going.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you have the full path in A1 and the full new path in B1, put this formula in C1:

="ren "&""&A1&""""""&B1&""""

copy it down

now copy c1 to c whatever and paste it to command line. If using PAD:

Get Clipboard contents

Open CMD Session

Write to CMD Session using %ClipboardContents%

This will work much faster than doing 1 at a time using PAD.

Was this reply helpful? Yes No