Forum Discussion
Extract email from display name?
Hi, Im currently working with a data set and need to extract the email. At the moment it connects to a sharepoint list and when filling in the details it looks at the GAL when you type a username...
Ideally it would just output the email as the form thats completed by my team they select the user thats submitted content from a drop down which is looking at the GAL. But when its complete the output is the email as a display name. I need a column showing their name and another that shows their email. Given the size of our organisation we have alot of people with the same names so I can just assume John Smith would be [email protected] as we could have multiple such as [email protected].
Ive attached a screen snip of what is filled in so i put in an email and it changes to a display name and thats the output but i need to show both email in one column and name in another