Add number to file name.

Like (0) Share

Report

Posted on 8 Mar 2022 12:37:08 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.

I have the same question (0)

All responses (4)

Answers (1)

Paul_Gibson 25 on 08 Mar 2022 at 13:23:31

Like (1)

Report

Re: Add number to file name.

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 08 Mar 2022 at 14:16:44

Like (0)

Report

Re: Add number to file name.

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 08 Mar 2022 at 14:22:03

Like (1)

Report

Re: Add number to file name.

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 20 Nov 2022 at 04:07:56

Like (0)

Report

Re: Add number to file name.

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