Allowing app to run without user selecting files for ALL browsing option

I have an Alteryx app that asks users to input 5 different files using 5 different browsing options. Sometimes, the user may not have all 5 files to browse. So I am wondering if there is a way the workflow can still run when, for e.g., a user browses 4 files and leave 1 browse option empty. Hopefully, I am clear. Thank you for your time.

Workflow

Input

Apps

Accepted answers

mceleavey

@itssumanb ,

sorry...my mistake.

Change isnull to isempty in the action tool formula.

that should work.

All comments

mceleavey

Hi @itssumanb ,

in your app, of they select null in one of the selections then overwrite that selection with a dummy file which you can package into the app. This allows it to progress without a selection without the tool throwing an error.

itssumanb

Hi @mceleavey

Thank you so much for your quick response. That sounds like a great workaround. Are you able to provide me a little more direction as to where/how I should insert this logic in my workflow?

itssumanb

Hello @mceleavey

I have attached a test workflow. Thank you again for your help.

Test workflow.yxwz

mceleavey

Hi @itssumanb ,

I've attached the workflow.

Basically, I've changed the action tools to update on a formula:

This say if the value is empty from the File Browse, then simply pick up the dummy file, else do what it would usually do.

The dummy file simply contains a column called "Dummy" with a value of "Y", which is then filtered out.

You just need to save the attached dummy file in the appropriate folder. I've set this to be:

if isnull([#1]) then "C:\Users\SBhattar\Desktop\Test file\Dummy File.xlsx" else [#1] endif

If you want this to be somewhere else, that's fine, but you just need to change the path in each action tool to be the path to where the dummy file is.

This should work now.

Test workflow.yxwz

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703