topic Re: Connecting Recently Made Excel Workbook to Email in Alteryx Designer Desktop Discussions

Connecting Recently Made Excel Workbook to Email

Mike_at_CG — Mon, 03 Oct 2022 20:35:47 GMT

Hi All

First post to the community. Wanted to see if there was a way to connect the most recent file made to an email?

This is run every Monday and updated to that date plus a file name.

Is there a way to take that most recent file and attach to an email?

Thank you

Re: Connecting Recently Made Excel Workbook to Email

Felipe_Ribeir0 — Mon, 03 Oct 2022 23:47:07 GMT

Hi @Mike_at_CG

Here is a way of doing this, take a look at the attached workflow.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

Re: Connecting Recently Made Excel Workbook to Email

Mike_at_CG — Mon, 03 Oct 2022 20:50:49 GMT

Hey Felipe. Appreciate the response. Not sure I know what I am looking at there.

The formula tool - Can you confirm what the output part is saying? I am able to recognize the email portion of it.

Re: Connecting Recently Made Excel Workbook to Email

Felipe_Ribeir0 — Mon, 03 Oct 2022 23:51:56 GMT

Hi @Mike_at_CG , take a look at this updated version. Please tell me if something is not clear.

The OutPutFilePath is something like FileFolder\Filename.csv, it is the path of your output file. After writing your output file the path will be sent to the email tool attachment field.

Re: Connecting Recently Made Excel Workbook to Email

Felipe_Ribeir0 — Thu, 06 Oct 2022 13:13:10 GMT

Hi @Mike_at_CG

It worked?

Re: Connecting Recently Made Excel Workbook to Email

Mike_at_CG — Thu, 06 Oct 2022 14:09:05 GMT

Hey Felipe. Really want to give you credit for the help but not really sure where your flow fits into my workflow. Any way you can with that?

Re: Connecting Recently Made Excel Workbook to Email

Felipe_Ribeir0 — Thu, 06 Oct 2022 14:29:30 GMT

Hi @Mike_at_CG

It is possible for you to share this workflow here with some fake input data?

Anyway, based on your workflow image, it would be like that:

1)On your last formula tool, add a new column with the name OutputFilePath. The content of this formula is the place where the file will be saved 'FileFolder\_RCB Weekly Model.csv'

2)Add a stop until done tool after the formula.

3)The first output from stop until done will go to the output tool

4)The output tool must be configured like the image bellow

5)The second output from stop until done will go to the email tool

6)The email tool must get the OutputFilePath as attachment.

You have experience sending emails with Alteryx? Configuring the tool i mean.

Email Tool | Alteryx Help

Re: Connecting Recently Made Excel Workbook to Email

Mike_at_CG — Thu, 06 Oct 2022 14:35:37 GMT

This actually makes a lot of sense now. So thank you for that. Someone else actually built this flow and I was just trying to add the email portion as the final touch. Can you confirm if the Output file column will end up in the final CSV? I only ask because I dont want to mess up the data in the final output.

Re: Connecting Recently Made Excel Workbook to Email

Felipe_Ribeir0 — Thu, 06 Oct 2022 14:39:40 GMT

Yes, if you keep the .csv at the OutputFilePath formula and configure the output tool like this, it will work

What i suggest you to do is save this modified workflow as workflow_v2 locally and test it. Keep the version from the other guy as it is, so you will have the original version of the workflow if necessary.