Email attachments not combining

[chrisgreen5]

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?

[Anonymous]

Have you tried deleting the Changed Type step? Or you can click on the white space around the error and see what the value is.

--Nate

[chrisgreen5]

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.