Dynamic Input No Table Chosen Error

[ashleyinman]

I'm trying to use the Directory input to grab a list of the most recent created date file and then use the dynamic input to grab the correct data. I'm running into the issue where the dynamic input is telling me "No Table Chosen; Please select a Table from the data source". 

When I select the dynamic input data source template and select the file, and the refresh my data shows up. But running the workflow is does not work. 

[gnans19]

If the table name is consistent, You have append excel sheet name to file path.

Example: c:/Project/sample.xlsx|||:`Sheet1$`  (Fullpath+"`Sheet1$`

[ashleyinman]

I tried to add the file sheet and am still getting an error. 

[gnans19]

@ashleyinman

Excel has it's own syntax for full path + |||+Sheet name.

Example:

C:\Filename.xlsx|||"East$"

[ddiesel]

I'm starring this post because I also have trouble using dynamic input in this same type of situation. I gave up and used a work around. @ashleyinman I'll be watching for the solution that works for you. Please share your solution from @gnans19's suggestion if it works. for you.

Thank you!

[ashleyinman · Accepted solution]

@ddiesel This is the solution that worked for me. In the formula tool I put the below. Name Sheet1$ to the sheet name of your file. 

[FullPath] + "|Sheet1$"

[bdeschler]

I was able to get this to work but it looked slightly different than the other suggestions.

In the formula, i appended "|||sheet name" to the full path. 

The formula was FullPath+"|||sheet name"

[NickGarafola]

This also worked for me.

For dynamic sheet input (i.e. getting a list of sheet names and then selecting/looping through sheets), the following formula works:

[FullPath]+"|||<List of Sheet Names>"

[mocalvo]

Thank you all!!! This worked for me: 

[Mahmood]

This worked for me as well.