Dynamic Input Tool - No Sheet Specified Error

Question

I keep getting the "No sheet specified, you must specify a sheet" in my Dynamic Input tool even if I have specified the correct sheet. I sorted the creation time to descending and added a sample tool to get the first row, so it will take the data of the most recent file then I configured the Dynamic Input tool to select the correct sheet where the data is located. Any suggestion on how can this be resolved?

ChGatsby · Accepted Answer

Sorry, I am new to this. How can I do that? Right after my Directory tool is my Sort tool, then Sample tool, then the Dynamic tool.

cpet13 · Accepted Answer

@ChGatsby I used a Directory tool to return all files with a certain name in a folder. After the directory tool, I used a formula tool and replaced the FullPath with the following:
[FullPath] + "|||[Sheet Name]"

This only works if the sheet name is always going to be the same, however.

alexnajm · Accepted Answer

Exactly as @cpet13 mentioned - because the directory tool does not include sheet names by default, you need to add it manually. There are ways to get it more dynamically, but not sure if that applies here!