Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create a Column for email body

Hi,

 

I am currently building a report wherein the source data is an excel file coming from my email.

 

I would like to ask if is there a way that I can add a column in Power Query wherein it will return the file name where the data was extracted.

 

Expected columns that I want to integrate to my data source are the following:

- File name

- Date when the email was received

- Who sent the email

- Email body

1 Reply

  • What is your data source,  the Microsoft Exchange Online connector?