Auto Selection of Files based on the user's chosen sheets using chained application

[Rao2821]

I'm seeking a way to have files automatically chosen in analytical apps, taking into account the sheet selections made by the user.

For instance: 

Step 1:Actual Data

File 1

sheet 1

sheet 2

File 2

sheet 3

sheet 2

File 3

sheet 2

sheet 4

Step 2: User will Manually select sheets (At this point display all the sheet names from the files provided by the user and User should be able to select sheet names manually)

sheet 1

sheet 2

sheet 3

sheet 4

Step 3: Automation should handle the automatic selection of files within those specified sheets. Note: User should also have the choice to deselect file selections if needed.

sheet 1

File 1

sheet 2

File 1

File 2

File 3

sheet 3

File 2

[ChrisWaspe]

Hi @Rao2821 . You would most likely want to use a Dynamic Input tool. You can build out the file path string using the results from the various selections and configure a Dynamic Input tool to read in those files. A chained app could provide a list of the file strings after the sheets have been selected. The user could chose which of these strings they then want to pass to the dynamic input tool

[Rao2821]

Thank you @ChrisWaspe,.

As a solution:
I used Directory tool and sheet name pull macro. A chained app using Tree interface tool.