Forum Discussion
Microsoft exchange - data refresh automatically
Hi Frank10
Yes, you don't need to apply latest filter. Just filter by Subject as the emails have the same name format. Then you can follow the steps below to combine all XLSX files.
For example, I filter by Subject (starting with) and remove other unnecessay columns. After that, I get below table. Click on white space in any cell of Attachments column, you will see its attchment information table displayed below. In each email, there is an XLSX file attached.
Now click on Expand icon on Attachments column header and select AttachmentContent to expand.
Then click on Combine Files icon on AttachmentContent column header.
You will see dialogue windows like "Evaluating Queries..." and "Connecting...". Just be patient and wait for Power Query to detect and connect to files. After a while, you will see Combine Files window. It's similar to when you use Folder connector to combine files in a folder. Select the sheet where data is and click OK.
After that, you will have queries like below. In the Mail query, all data is combined. You can transform data then.
For more information about combining files, please refer to Combine files overview
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Frank10
As you need attachments from multiple emails, you can filter rows to keep emails you want to get data from. Are these emails in the same inbox folder? Maybe you can set up some rule at the email box to move all required emails to the same folder, then filter the Folder Path column to only keep emails in this folder. Or maybe these emails have the same name format so you can filter Subject column to find them. The first goal is to keep only the emails you want in the table. Then we can think about some method to combine all attachments at the same time. What is the file format of the attachments? XLSX, CSV or something else?
BR,
Jing
Hi v-jingzhang,
thanks for supporting.
I already filtered Subject (starting with) and Latest (Date/Time Filters). At this point I get latest email in my table. As said, I need to keep historical data, are you suggesting to not apply latest filter but combining in some way all the email ?
Anyway, the emails are in the inbox with same name format and XLSX file enclosed.
Thanks !
Hi Frank10
Yes, you don't need to apply latest filter. Just filter by Subject as the emails have the same name format. Then you can follow the steps below to combine all XLSX files.
For example, I filter by Subject (starting with) and remove other unnecessay columns. After that, I get below table. Click on white space in any cell of Attachments column, you will see its attchment information table displayed below. In each email, there is an XLSX file attached.
Now click on Expand icon on Attachments column header and select AttachmentContent to expand.
Then click on Combine Files icon on AttachmentContent column header.
You will see dialogue windows like "Evaluating Queries..." and "Connecting...". Just be patient and wait for Power Query to detect and connect to files. After a while, you will see Combine Files window. It's similar to when you use Folder connector to combine files in a folder. Select the sheet where data is and click OK.
After that, you will have queries like below. In the Mail query, all data is combined. You can transform data then.
For more information about combining files, please refer to Combine files overview
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.