Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |