Power Platform Community Forum Thread Details

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.

Screen Shot 2022-02-09 at 2.33.52 PM.png

Screen Shot 2022-02-09 at 2.34.27 PM.png

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

Categories:

Building flows

@scrabtree

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