Gallery workflow does not provide outputs upon error message from Message Tool

Question

I have a workflow that is hosted on the Alteryx Gallery. The workflow has built in data integrity checks which provide users a clear message when there is a problem with their data or workflow configuration. All integrity checks are powered by Message tools which error out when the workflow is run and a check is not satisfied. However, all of the checks, regardless or pass or fail status, go to an .xlsx output. When the workflow is run on Designer, the output is provided in the workflow directory on their desktop.

When the workflow is run on the Gallery, no output is shown to the user, only the error message from the Message tool. Is there a way to remedy this?

ArtApa · Answer

Hi @jpl5253 - If you want a result to be seen in your browser on the Gallery, you need to add one more Output Data tool, which writes into yxdb.

jpl5253 · Answer

Yes, the checkbox for this output tool is checked off, but because the only way to show the integrity check message to the user is via an error message, when it is run on server it only shows the error message and not any of the outputs that may have been otherwise output.

DataNath · Answer

Hey @jpl5253, when you go to the Interface Designer (Ctrl+Alt+D), have you selected an output to show the user upon completion (shown below)? In my dummy app, this is just a browse. In your case, it should be the Output Data tool that creates the .xlsx.