Collect email address from Person column in Sharepoint List

[ArturasF]

Hello, I have read other suggestions but was not able to understand them, perhaps someone could help on this problem:

I have a sharepoint list where these fields are available:

ID - Number

Driver - Person only (only one allowed)

Department - Text (single line)

How to populate a collection with only these values:

ID - Number

Email - email address extracted from driver

Department - Text

I know how to use ShowColumns while collecting, but I don't know how to extract email address from Person Column. Please help!

[Jeff_Thorpe · Accepted solution]

You can use the combination of Addcolumns() and ShowColumns(). Here is an example:

ClearCollect(colTemp, ShowColumns(AddColumns(SPListName, "Email", Driver.Email), "ID", "Department", "Email" ))