Attach file conditionally

[GustavoTagli]

I want to attach a file in the email only if this file has records, anyway, with attachment or not, the email will be sent. Is that possible?

[binuacs · Accepted solution]

@GustavoTagli You can check the file has any records with the help of the count record tool , based on that you can attach the file or not in the email. Attaching a sample workflow for your reference

[Felipe_Ribeir0 · Accepted solution]

Hi @GustavoTagli 

I use this macro built by CharlieS (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Send-email-even-if-attachment-doesnt-e...) to do this job, it can attach 0 to N files dynamically depending on how the logic is built. It will change the XML of the email tool based on each condition.

Email with data:

Email without data:

[GustavoTagli]

Thanks a lot, guys! They both work.