Forum Discussion
Peter_R80
Apr 21, 2023Copper Contributor
Sharepoint and Power Automate Copy Information and Leave fresh template
Hi Guys, Im really struggling to work this out. I have exel file with tabs in it for each day of the week. Monday Day Monday Night Tuesday Day Tuesday Night and so on. Current Week Exel file is ...
jefmeyer
Apr 21, 2023Iron Contributor
You could do this with Power Automate running on a weekly schedule:
1. create a "clean" file with your Excel file format. This is just a template file.
2. have a current week file, used for your weekly input.
3. when the week is completed, the Power Automate could rename the current week file to whatever name you want.
4. the Power Automate could then copy the "clean file" and save as the current week file.
1. create a "clean" file with your Excel file format. This is just a template file.
2. have a current week file, used for your weekly input.
3. when the week is completed, the Power Automate could rename the current week file to whatever name you want.
4. the Power Automate could then copy the "clean file" and save as the current week file.