Dynamically change file name and output to different tabs

[Haokun]

Hi 

I have read several community post but seems there is no relevant to my case yet. For example, my output data looks like below, I want to output to different tabs based on column name. On top of that, I want to update my file path with the current datetimenow, so everytime i run the workflow, i would expect to see a new excel file with 5 different tabs based on the dynamic file name.

Ref	Name
1	John
2	Allen
3	Peter
4	Lily

Thanks.

[Hamder83]

Hi 

I've attached a sample workflow that should do the trick if I understood you correctly 🙂 

[Haokun]

hi @Hamder83 

yup, but is it to show the date and the time? because if only have date means the user can run one time per day, or else they will need to remove the file before they can re-run it.

[Qiu · Accepted solution]

@Haokun 
Based on the work of @Hamder83 , and I hope you will not be able to run the workflow within one second.😁

[Haokun]

@Qiu 

Wow, yes. but why need to change ":" to "-"?

[Qiu]

@Haokun 
":" is an illeglal character for file path or file name, right? 😁