Combining email data with attachment data

Question

I have linked Power BI to a folder in Outlook where I receive emails with attachments. The attachements have the same format. for exampleEmail1 (Sender a@aa.com, time received 15 Nov 2019 11:02am , Attachment 1:Head1|Head2|Head31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |5Email2 (Sender b@bb.com, time received 16 Nov 2019 10:15am , Attachment 2:Head1|Head2|Head34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2I have setup the Query editor so that the attachments in the folders are combined:Head1|Head2|Head31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |54&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;Is there a way to have the sender and time received to every row in the combined attachment table:Head1|Head2|Head3|Sender|TimeRec1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |a@aa.com|15 Nov 2019 11:02am5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |a@aa.com|15 Nov 2019 11:02am4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |b@bb.com|16 Nov 2019 10:15am

v-xuding-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
You could connect Microsoft Exchange Online into Power BI to get the name and email address. And then append them to your&nbsp;existing table.

Get data &gt; Choose Microsoft Exchange Online

Sign in Microsoft account

Choose Mail table &gt; Transform data
Expend Sender column to show address

Just retain the columns of address and received datetime

Then you could add columns or append the queries based on your actual data model to implement.
&nbsp;
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

hi Xue Ding, thank you for your reply. Unfortunately this doesnt solve my issue. Once I choose Combine - Attachment content, a new table is created with the attachment information and the original email information dissapears. So I cant refer to the sender email column etc. Is there a way to do this.

Forum Discussion

Combining email data with attachment data

2 Replies

Related content

Get email attachment with receivedtime

Sending emails with attachment via pipeline

attach file to email

How to send an email with a csv attachment

subscription's png attachment and email image show errors