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 and then you can select the relevant person. When this is output the column displays the name as a display name i.e Smith, John (Business Area) behind this is the users email which is what i want to extract/show aswell as their name i have a columns that shows [email protected].
Is there a way to do this?
2 Replies
Hi NitroMDX27 - you want to create a new column showing both the name and email
eg:
Full Name & Email = 'YourTable'[Display Name] & " (" & 'YourTable'[Email] & ")"
I hope this works. please check.
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
