Dynamically change file name and output to different tabs

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.

Output

Accepted answers

Qiu

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

test1.yxmd

All comments

Hamder83

Hi

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

test.yxzp

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

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

test1.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703