Forum Discussion
Email attachments not combining
I am currently trying to combine files from email attachments. I have used this process previously but with these files it is not working.
Below are screenshots of the steps.
1. Exchange online inbox as the source & filtered to just show date & attachments:
2. expand attachments:
3. Attempt to combine:
4. Once table picked this is what I get:
Each excel attachment is named the same with the same columns every day. I have restricted the inbox to two emails for the screenshots but it does the same no matter how many files there are. Any idea what I am doing wrong here or a fix to get each days attachments to combine?
2 Replies
Hi, thanks for the suggestions. I deleted the Changed Type Step but that didn't make any difference. I clicked the white space around the error & got the following: An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=2024-04-15
Kind=Sheet
Table=[Table]What's bizarre is that it always picks 2024 -04 -14 as the sample file but the data shown prior to the error is always from whatever happens to be the most recent file (in this instance from 2024 - 04 - 16) but there doesn't seem to be anyway of altering what it picks as the first or sample file.
