You’re offline. This is a read only version of the page.
Announcements
Hi there, I am pretty new to writing flows. Trying to write a flow that will automatically create a new worksheet with a template applied to the new sheet as a landing zone for daily data to be uploaded as reports are submitted. I am able to create a new sheet and label it with the date.
Tried writing a script to apply to the new page. Now trying to get the "template" workpage to copy and paste. Neither approach has been working.
If anyone has any suggestions I would appreciate the help.
Thanks
The approach I have tried before and work pretty well is as below:
1. Create your Excel Template File with the Table formatting and column Headers you want and then save it to a specific sharepoint or one drive folder, in the below sample i will share below I was using SharePoint.
2. Get the stored excel template created in step 1
3. Create a new file with the content from the template as below and save it with a new name and in the specific path you would like
4. Then Use Get Tables on the newly created file in step 3 as below, using the Path output from previous step
5. Then you can do you logic and add rows in a table as below, you need to construct the row manually according to your logic in JSON format
Share
Report
All responses (
Answers (
11,413
