Attaching email excel attachment for todays date

Question

Hi,

I have a file generated everyday within my workflow.

I want to attach this file to my email within my workflow.

File name is like so:  Email Data - 2022-09-12 .and each day will generated Email Data - 2022-09-13.xslx and so on.

How can I attach the latest file to my email? Im not sure how to dynamically choose todays file.

Thanks.

DataNath · Answer

Hey @wonka1234, you could use an Append Fields tool to bring the output of your filter into the same stream as your layout and then reference the field needed in the email tool attachment configuration.

wonka1234 · Answer

@DataNath  Thanks.

I used your directory and filter tool to get the file, not sure how to bring it into the actual email.

do you know how to do this?

DataNath · Answer

@wonka1234, does the file you want to use as an attachment get created during the same workflow? If so, you could adopt an approach like so (may need to use a Block Until Done tool depending on processing order):

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Email-Output-Error-Need-Help-Please/td-p/515889

If you're just bringing in an existing file then you can use a directory tool and just point it towards where these files will be saved, before filtering based on today's date being in the filename:

Then reference the field in the email tool attachment configuration: