Answered

Renaming Files

(1) Share

Report

Posted on by HD-02081403-0

Greetings,

I have a folder with the following file that gets dropped using FTP. The file must be renamed after once it is available in the specified folder.

Downloaded Naming Convention: CompanyName_ReportName_VendorName_2024_07_17_v1.0.xlsx
Desired Naming Convention: CompanyName_ReportName_VendorName.xlsx

I tried using Replace() expression but it require that I hardcode the file name. However the last part of the file name changes every week.

Regards

Categories:

Process Advisor

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nived_Nambiar on at

Like (1)

Report
Renaming Files

You can set the namein rename file action, so u can remove the date component from the file name using replace text action and set the resultant name in rename file (s) action. see below

Assume this is input file name

Use Replace text action so to replace date component_version with empty string as shown below

Now Replaced variable stores the output- i,e replaced file name with no dates or versions

Now use rename file to set new file name as shown below

See hoe replaced variable value looks like which has the file name of resultant

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
HD-02081403-0 6 on at

Like (1)

Report

Renaming Files

Thank you. I am using Power Automate online version. I think you are using the desktop version. I really appreciate your help and details.

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,029 Super User 2025 Season 2 on at

Like (2)

Report

Renaming Files

Hi,

Assuming the file format is always same -

you can try this-

Expression used-

concat(join(take(split(outputs('Compose'),'_'),3),'_'),'.',last(split(outputs('Compose'),'.')))

Now see the result

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No