Chaining apps to send emails

[MattR79]

I am trying to get some chained apps to work together based on a user request, the end result desired is that one app will run and create a data file, then the next will run, and grab the data file and include it as an attachment along with some charts.  I am new to chaining apps and am having trouble with even getting a simple one to trigger the next.  I have included the two test apps I created, and I am hoping someone can help me understand why they are not working.  In the ones included, the first is supposed to write to a single tab in a file and the second is supposed to update a second tab.  However, while the first is running correctly, as far as I can tell, the second is not working.

If there is an easier way to get a workflow to pick up a file that is created inside of it and include it as an attachment I am open to that as well.

[binuacs]

@MattR79 Based on my understanding you don't need a chained app for your requirement, you can implement everything in one workflow or analytical app

[MattR79]

That's great, how would I go about making that work.  From what I have been able to figure out I cannot create an Excel file and then have the workflow pick it up as an attachment with that days data in it.  The user cannot use day old information, everything must be current.

[DanM]

@MattR79 for future knowledge if you create more chained apps. The first app must execute in 30 seconds or less in order for the second app to launch. This is a security protocol to make sure that the first app does not get stuck running if an issue arises. 

[binuacs]

@MattR79  First part - create your Excel output file and connect to the Block until done tool (first output anchor), In the second part use the input from the first part of the workflow (make sure you are connecting from the second anchor of the BUD tool),  then create the charts and finally connect to the email tool. The BUD tool make sure that the excel file is created first then only it processes the second part of the workflow

[MattR79]

I did try that, however if I did not have the sample tool in the workflow, then I was getting an email for each new row that the workflow was adding to the file rather than just a single email including the attachment.

[binuacs]

@MattR79 use the sample tool just before the email tool

[MattR79]

I can't do that, I need all of the records added to the file which could be upward of 1k so that the full data set can be provided to the correct teams.