Hi everyone,
I am quite new with SP and read somewhere that SP Designer can do some sort of VLOOKUP.
In my company, our email address is based on employee ID, meaning I am 123@xxxx.com however whenever I submit into SP, my display name will be shown instead which is Fierul F@xxxx.com.
How to convert it back to employee ID? I tried with SP Designer but I cannot locate Created By as a list. Is this something I can do with SP Designer + workflow or there's other method to do it?
Thanks!
