copy an excel file to a different folder in the same onedrive (business account) and add a date to a the file name when creating it power automate

[Anonymous]

hi, 
I just discovered the power automate tool and made some use of it.

In fact, I built a flow that convert an excel file to PDF and send it by email every 24 hours, and the issue is that I want to archive (make a copy) of the original excel file to a different folder (let's say archive folder) with adding a date for each file before sending the mail,

thank you,

[v-duann-msft]

Hi @Anonymous

According to your description,  you want to copy the original excel file to a different folder with adding a date for each file before sending the mail.

Please take a try with the following steps:

Expression: formatDateTime(utcNow(),'yyyy-MM-dd')
test123: Source folder

copy: Destination folder

This is my original folder

This is my destination folder after flow runs.

This is the email I received after flow runs

Hope the content above can help you.

Best Regards

Anna

[Anonymous]

@v-duann-msft  thank you for your quick response, but I think I didn't express myself clearly,

here is the process to automate;

let's say I have two folders in the same Onerive business account, "test", and "RJ C&S" (which is not in the root),

and I have several files (excel and pdf) in the "test" folder, where I share an excel workbook for multiple editing, whose name is "C&S daily report"

At the end of the day, I want to copy the excel file "C&S daily report" in the "RJ C&S" folder adding the date in its name, at the same time (or one step further) convert the copied file to PDF (not the original, I think that it will be easier like that) and send it by e-mail ‌‌😁

I don't know if I am clear because my English is not very good ‌‌😐

thanks for taking the time to help me @Anna 🙏

[v-duann-msft · Accepted solution]

Hi @Anonymous 

Thank you for your explanation. Sorry for misunderstanding.

Your just want to copy the excel file "C&S daily report" in the "RJ C&S" folder adding the date in its name, at the same time convert the copied file to PDF (not the original) and send it email.

I simplified the flow.

Please take a try again with the following steps:

Expression: formatDateTime(utcNow(),'yyyy-MM-dd')

This is my test folder

This is my RJ C&S folder before flow runs, It's empty.

After the flow runs, C&S daily report can be copied to RJ C&S folder with date. 

And can receive an email as below.

Hope the content above can help you.

Best Regards

Anna

[Anonymous]

Hi @v-duann-msft 

Thank you very much 🙏 ! it worked well,

I think I will probably come back to you for some other questions 🤗

Best Regards,

Masnsen,

[Anonymous]

Hi, i tried this method but only yo duplicate and rename files in excel but it output is the copied file is not in excel format. Really need your help on this