Excel

Question

Hi All,

I want a workflow which creates an output with current data and time in output name.

Schema for Output:

for eg.

Output_05012021_1330.xlsx

The output has different sheet  names which I am taking from one of the fields from data for e.g. Maths, English, Science, History, Geography.

So sheet name must not be changed.

Please suggest me some workflow.

Emil_Kos · Answer

Hi,

I have prepared the workflow for you.

It is using both the column name + System date time in order to save the output file.

The name of the outputs:

Date 4.yxmd

vijaylnyadav · Answer

@Emil_Kos  yes I am using the same options but it is updating the sheets and that is fine but I want to update the file name according to the system time and date.

and I am not using file name as you mentioned in a pic, I am using for eg subject instead of file name for updating several sheets.

Emil_Kos · Answer

Hi,

I am not sure if I got all the requirements correctly but for my understanding, you already use this option:

If that is the case you should use also datetimenow formula somewhere in the workflow and you should be able to make it work.

Date 3.yxmd