How to append the worksheet name in an Excel writer step using the current date as a parameter

The below image are the steps that you’ll need to do this task. I used a Record Generator step as my source step.

In the Calculator step, you write the code to pull the current date. Highlighted in the below image is the parameter name that will be called/ populated in the Excel writer step.

The Combine step combines all the records into one record before it pushes it to the Excel writer step.

In the Excel writer step, clicked on the highlighted linked icon to add the parameter as illustrated below.

The below page will appear. Type the “parameters.timestamp” to reference the parameter and it’s name from the Calculator step and then click on Use Path as a confirmation.

The Excel writer step will then appear as shown below. Save the step to save the change you made.

image

Once the flow is executed successfully, you can download the Excel file in the Run File step as highlighted below.

When you open the Excel file, you will see the current date as the worksheet name as highlighted below.