Alteryx App with multi-select File Browse for Excel Files

[jacobwhitworthkubrick]

Hi all!

I'm wanting to create an Alteryx App where the user can input files names and the workflow processes it into a table. I currently have a File Browse for a single file input and Folder Browse when I user wants to input files from one directory.

The issue with folder browse is the target user is fairly computer illiterate so a Folder Browse could end up ingesting "shopping.docx" instead of just excel files as intended.

My Questions:

1. Is there a way for File Browse to enable multiple selections of files? This would make it easier for the user to select the appropriate files instead of the single File Browse input or blanket Folder Browse input

2.(stretch) Is there a way to bypass the Select Excel Sheet Input Pop-up in the File Browse Interface module? I want it to automatically select 'Import only the list of sheet names' option. I have attached a photo of the pop-up for clarity.

I've attached a basic version of my current workflow, so hopefully people can understand the workflow I'm wanting to achieve.

Thanks!

[apathetichell]

re-route this to a chained app.

directory tool - maybe with folder browse.

extract list of .xlsx files.

create .yxdb file of .xlsx flies.

app 2:

listbox tool populated by .xlsx filename.

this feeds to text input tool. formula tool creates full path and includes "|sheet1" for your sheet name.

this feeds to batch macro which reads in each filename/sheet.