Outlook Input Connector Overwriting Downloaded Files

[Everett_Nelson]

Hi all,

I have a workflow that's downloading text files from a certain email inbox once/week. These emails contain individual remittance attachments, and they all have the exact same subject line and attachment name. Because some of them come in at the exact same second (and have homogenous subject lines/attachment names) some of these files are getting overwritten when I try to download the attachments through the Outlook Input connector. Looking at my connector output, I can see records 6/7, 10/11, 15/16, and 18/19 are each unique but came in at the exact same time, which is causing Alteryx to overwrite one of them. I checked the output folder and confirmed I only have 16 out of 20 attachments that I need downloaded.

Is there a way to change the naming schema for downloads so that files aren't overwritten? I've already asked and the client will not change how or when they send us emails.

Record #	Subject	Created Date Time	Save Path
1	FW: REMITTANCE	2024-10-21T15:49:26Z	C:\...\FW REMITTANCE_2024-10-21T154926Z\REMITTANCE.TXT
2	FW: REMITTANCE	2024-10-21T15:49:29Z	C:\...\FW REMITTANCE_2024-10-21T154929Z\REMITTANCE.TXT
3	FW: REMITTANCE	2024-10-21T15:49:30Z	C:\...\FW REMITTANCE_2024-10-21T154930Z\REMITTANCE.TXT
4	FW: REMITTANCE	2024-10-21T15:49:31Z	C:\...\FW REMITTANCE_2024-10-21T154931Z\REMITTANCE.TXT
5	FW: REMITTANCE	2024-10-21T15:49:32Z	C:\...\FW REMITTANCE_2024-10-21T154932Z\REMITTANCE.TXT
6	FW: REMITTANCE	2024-10-21T15:49:33Z	C:\...\FW REMITTANCE_2024-10-21T154933Z\REMITTANCE.TXT
7	FW: REMITTANCE	2024-10-21T15:49:33Z	C:\...\FW REMITTANCE_2024-10-21T154933Z\REMITTANCE.TXT
8	FW: REMITTANCE	2024-10-21T15:49:34Z	C:\...\FW REMITTANCE_2024-10-21T154934Z\REMITTANCE.TXT
9	FW: REMITTANCE	2024-10-21T15:49:35Z	C:\...\FW REMITTANCE_2024-10-21T154935Z\REMITTANCE.TXT
10	FW: REMITTANCE	2024-10-21T15:49:36Z	C:\...\FW REMITTANCE_2024-10-21T154936Z\REMITTANCE.TXT
11	FW: REMITTANCE	2024-10-21T15:49:36Z	C:\...\FW REMITTANCE_2024-10-21T154936Z\REMITTANCE.TXT
12	FW: REMITTANCE	2024-10-21T15:49:37Z	C:\...\FW REMITTANCE_2024-10-21T154937Z\REMITTANCE.TXT
13	FW: REMITTANCE	2024-10-21T15:49:38Z	C:\...\FW REMITTANCE_2024-10-21T154938Z\REMITTANCE.TXT
14	FW: REMITTANCE	2024-10-21T15:49:39Z	C:\...\FW REMITTANCE_2024-10-21T154939Z\REMITTANCE.TXT
15	FW: REMITTANCE	2024-10-21T15:49:40Z	C:\...\FW REMITTANCE_2024-10-21T154940Z\REMITTANCE.TXT
16	FW: REMITTANCE	2024-10-21T15:49:40Z	C:\...\FW REMITTANCE_2024-10-21T154940Z\REMITTANCE.TXT
17	FW: REMITTANCE	2024-10-21T15:49:41Z	C:\...\FW REMITTANCE_2024-10-21T154941Z\REMITTANCE.TXT
18	FW: REMITTANCE	2024-10-21T15:49:42Z	C:\...\FW REMITTANCE_2024-10-21T154942Z\REMITTANCE.TXT
19	FW: REMITTANCE	2024-10-21T15:49:42Z	C:\...\FW REMITTANCE_2024-10-21T154942Z\REMITTANCE.TXT
20	FW: REMITTANCE	2024-10-21T15:49:43Z	C:\...\FW REMITTANCE_2024-10-21T154943Z\REMITTANCE.TXT

Thanks in advance!

[DavidSta]

Hi @Everett_Nelson,

unfortunately this is working as designed, as far as I can see.

As of today Outlook 365 Input will create folders with the attachments in the destination path. The names of the folders will be the first 20 characters of email subject, underscore, date, letter T, time stamp, and letter Z.

In your case this means, that emails with the same timestamp will overwrite the old one.

I was thinking about creating some kind of Batch Macro by using the internetMessageId. So far I was not able to find a way to filter this element with the Outlook 365 Input Connector.

Even within Outlook itself I was not able to create a filter using this element - only with a rule (which is not helping either).

With this I would recommend that you work closely with your Account Team, Customer Success Manager or TAM to address this to the Product Team.

Best regards,

David

[Everett_Nelson]

Hi David,

Thanks for the response. I'll try reaching out to my TAM, maybe they can assist or provide an alternative solution.