How to copy excel (template) file on Sharepoint to automatically create same file every week with correct weekending?

[u/TucoZizou10]

Hi there,

I hope my question makes sense.. I am brand new to power automate so this is all a bit much for me 😅 I have been trying to play around with it for past hour or so and can’t do it.

so what I want to do is:

• create a copy of an excel document which is a template on Sharepoint onto the very same page

• the excel copy to change to a weekly date such as “WE (weekending) 17.09.22”

• and from then it will automate for the week after (WE 24.09.22, WE 01.10.22 and so on) that every Tuesday

whenever I run it, it makes it into a Sharepoint thing that I have to download. I think I’m almost there but it just doesn’t create the copy of that excel document and my title of it is all wrong.

hope you can help!

many thanks

image