Alteryx Apps on Server - Outputting to Excel

Question

I have a workflow that is set up as an app - When run, it asks the user to select a file from the file explorer three times - Once with the input sheet selected, and twice with each of the two output sheets selected. It uses the input data in selected file to run the queries needed, then creates multiple output tables that should go to each of their selected output sheets. My goal is to save this to our server so that non-licensed users may run the workflow, but in doing this, the outputs only go to temporary files rather than going to the user selected output file. Is there a workaround for this?

sayres · Accepted Answer

Update - Shortly after posting this, I had a new idea come to me for a workaround, and it was successful. I will leave the post up along with what solution I found in this comment, just in case anyone else ends up searching for something similar in the future!

Solution - In the input file, I created a formula that produced the file path of the input file, and then I wrote a formula to output a modified file path that matched the desired output sheet - naming the columns "Output File". In the workflow, I then removed the interface tools from the outputs, and instead I picked up the output file column from the input and configured the output tool to replace the file path with the output file column.