Extract email from display name?

[NitroMDX27]

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 John.smith@example.com.

Is there a way to do this?

[NitroMDX27]

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 John.smith1@example.com as we could have multiple such as John.smith2@example.com.

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

[rajendraongole1]

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.