Mail - how to view "from" email address when connected to Exchange?

[Michael-Lowden]

I'm trying to extract all unique "FROM" emails from an email account and can't seem to find the "From" data-column. I've tried unpivoting all the columns in "Edit Query" but none of them contain the senders details, only the To/Cc/Bcc.
Anyone know how to get it?

--thanks.

[v-shex-msft · Accepted solution]

Hi @Michael-Lowden,

Normally, sender and topic will be filter during loading.(by default these data were stored with record/table format)

For your requirement, I'd like to suggest you enter to 'query editor' to spilt 'Sender' and 'Attributes' columns to new table.
Then expand 'Sender.Address' and 'Attributes.ConversationTopic' to get sender and mail topic.

Full query:

let
    Source = Exchange.Contents("xxxx@xxxxx.com"),
    Mail1 = Source{[Name="Mail"]}[Data]
    #"Removed Other Columns" = Table.SelectColumns(Mail1,{"Sender", "Attributes"}),
    #"Expanded Sender" = Table.ExpandRecordColumn(#"Removed Other Columns", "Sender", {"Address"}, {"Sender.Address"}),
    #"Expanded Attributes" = Table.ExpandRecordColumn(#"Expanded Sender", "Attributes", {"ConversationTopic"}, {"Attributes.ConversationTopic"}),
in
    #"Expanded Attributes"

Regards,

Xiaoxin Sheng

[Michael-Lowden]

Thanks. I'll give it a whirl today