Dynamic Input with No Sheet Specified error message

[rockeylearning]

Hello!

Can someone please help me pointing to the right direction.

I configured the Dynamic Input, specified the sheet for the excel as seen in the screenshot below. However, when running the workflow, it keeps erroring with the No Sheet specified, you must specify a sheet. But I did specify in the setting, so what am I doing wrong?

[rockeylearning · Accepted solution]

I found Solved: Error with Dynamic Input Tool - No Sheet specific - Alteryx Community this seems to be working better

[JosephSerpis]

Hi @rockeylearning you need to add the sheet name you want the Dynamic Input to get the data from to the Fullpath. If you look at this article they add a formula tool to add the sheet to the fullpath/filepath before it goes into the Dynamic Input tool. If the sheet names are dynamic then you need a batch macro to find them all a solution in this post would be the approach.