Run workflow from Server and Download the results from the Gallery

Question

Hi,

I have developed workflows in the past which write to multiple Excel sheets. For each sheet, I use a formula tool to create [FilePath] and then in the output tool, I select 'change the entire file path' and  use the [FilePath] field to write the data. FilePath always was a shared drive location so I give entire path along with File name ||| sheetname.

This time the requirements changed and I have a workflow which writes data to Excel. I have multiple Output tools which write to same excel file and to different sheets (using Block until done). Business wants to run this workflow from the Gallery and after it is run, they should be able to download the Excel File.

Can you please guide me step by step process to achieve it?

Thank You for your time

patrick_digan · Accepted Answer

@Reddy4 I would suggest you use relative paths (ie File.xlsx) without any folder specified. When that workflow is saved to the server, it will write the data and let the user download the file. You can either put file.xlsx into the output tool's configuration, or you can still use the change entire file path and just feed in a relative path (like "file.xlsx|||sheet1")