I am currently working on a list that will display contact information. I would like to set things up so that someone can just past several email addresses into a list (in the datasheet view), after which a workflow will go out and retrieve any relevant information from active directory.
I am able to retrieve data using the "User Profiles" data source, although I can only search for that data by using AD account names. I was able to make a column display AD account names by setting the field type to "Person or Group" and then setting "Show Field:" to "Account", although I am not able to copy the resulting value out of the cell (the copied value just ends up being the email address that I had originally copied into there, even though it display as an AD login name).
Is there a way that I can take an email address and then determine the owner's account name so that I can look up their info using their AD account name?