Add number to file name.

(0) Share

Report

Posted on by RL-26071304-0

126

Hello.

I created a simple automation for PowerAutomate to copy a file from a local drive to OneDrive everytime it is modified.

I would also want to don't replace it but instead I would want to add one more file with a differente name (Book1.xlsx, Book2.xlsx, Book3.xlsx, etc).

Can you please help me to do that?

Thank you.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Paul_Gibson 25 on at

Like (1)

Report

Hi there,

If you are doing this to a specific file, instead of numbering the files, it may be easier to append with the date and time and use the following structure:

In which the formatDateTime is:

formatDateTime(body('Current_time'),'dd_mm_yyyy_hh_mm')

Was this reply helpful? Yes No
RL-26071304-0 126 on at

Like (0)

Report

Thank you for your answer.

The file is correctly created but it still doesn't create multiples files. Instead, it replaces the existing file.

Was this reply helpful? Yes No
Verified answer

Paul_Gibson 25 on at

Like (1)

Report

If you are testing it and run the code a few times in the same minute, this may happen since the date and time is only being formatted to the nearest minute. You can adjust this by using the following to add the seconds also:

formatDateTime(body('Current_time'),'dd_mm_yyyy_hh_mm_ss')

This way, unless the flow is ran twice with in the same second (which is not likely), you should have new files created on your One Drive each time with a different time stamp on them.

Was this reply helpful? Yes No
nilotbh 2 on at

Like (0)

Report

Hi,

Follow the below steps to append a number to your filename-

a. Create a Variable in POwerAutomate. Let's say the VarName is "NewVar" (Which is the default name when you add a variable). Assign a value of 1.
2. Inside the loop, append this variable to your file name like this -
%SpecialFolderPath%\<YourFolderName>\<FileName>%NewVar%.<FileExtension>
e.g.
%SpecialFolderPath%\myFolder\MyFile%NewVar%.xlsx

Was this reply helpful? Yes No