Use File Browse and Action tools to update Excel file save location in Render tool

[Jeremy]

I am trying to solve something I thought would be straightforward.  I have an application I'm creating, and I want the output of that application to be a table rendered into an Excel file.  I would like to choose where this file is saved to on each run.  Below is a screenshot of the relevant section of the app.  Incoming is just a basic table with a few columns.

The Render tool is configured:

And the Action tool:

When I run the workflow normally, everything works, and the file is rendered to the [Redacted].xlsx file.

When I run the workflow as an application, I get an error because the File Browse tool is inserting the sheet name into the text I'm replacing with the action tool.

How do I change the file name and path in the render tool without including the sheet name so the render tool will see the string as a valid file name?

I found an unresolved post from years ago with the same question: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outputting-a-Render-file-through-file-...   I wonder if @rajatjain1 ever got the answer they were looking for.

[gabrielvilella · Accepted solution]

Hi @Jeremy, try updating the value with this formula. This way won't matter what the user inserted as sheet name.

REGEX_Replace([#1],'(.*)\|{3}.*','$1')

[Jeremy]

Thank you, @gabrielvilella, that worked perfectly.