Answered

Copy and rename a document

(1) Share

Report

Posted on by UC-03010435-0

I would like to create an automation. I have a Excel file named "Generic Attendance" in my work team SharePoint folder named "Attendance", every weekday at 4:00am (just anytime before the work day) I would like it to create a copy of of "Generic Attendance" and rename it with the day's date in mm-dd-yyyy format. In other automation interfaces I would do something like

Every Monday, Tuesday, Wednesday, Thursday, Friday at 4am
Find file [Generic Attendance.xlsx] in Folder [Shared Documents/Folder 1/Folder 2/Attendance]
Create Copy of file [Generic Attendance.xlsx] in the same folder. (It would then make a file named "Generic Attendance1.xlsx")
Rename File [Generic Attendance1.xlsx] to ["Today's Date, mm-dd-yyyy"] (it would then rename the file "01-02-2026.xlsx")

Mostly my team uses SharePoint and have access to all the Microsoft Power apps.

Categories:

Building flows

General topics

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

trice602 15,905 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi there!

Here's a quick flow you can copy and make it your own, works in testing.

The trigger.

Get the file content of the 'generic attendance.xlsx' workbook.

Create a copy of the file with the new name MM-dd-yyyy.xlsx

Note the formula for the file name.

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

trice602 15,905 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The SharePoint folder view.

1 people found this reply helpful.

Was this reply helpful? Yes No
UC-03010435-0 4 on at

Like (0)

Report
Copy link

Link copied!

Yes, thank you!!!! Now that I figured that out I'm able to apply what you taught me to so many more things! Thank you.

Was this reply helpful? Yes No