Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
102 | |
86 | |
77 | |
68 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |