Dynamic Input - Sheet not specified
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am trying to update a workflow to create a new report type. I am using dynamic input tool and have specified a sheet but, I am getting an error when running the workflow. I have posted a screenshot below (I edited out any sensitive information like the user on the file pathway and the data in the screenshot, hence why it is blank).
 
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
After the .xlsx you'll need to include the |||<Sheet Name Here>. You can fix it by adding a formula tool before it with [FullPath]+"|||`<Sheet Name Here>`".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @cjaneczko,
I do not need the file path in a formula as it is already present in the data beforehand. Also, I have already tried the triple pipe "|||" after the file extension to specify a sheet. Doing that only updates this:
After which, refreshing the configuration window or running the workflow removes the "|||".
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have a look at this thread where other users had the same issue. A formula tool prior to the dynamic input should resolve this error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CSmith16 Can you share your dynamic input tool configuration?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, @CSmith16.
Does the attached yxzp help?
It's an example I made to read in data and load it into a Dynamic Input tool.
If you want to run the workflow, you may also want to download the extra Excel file I attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @acarter881,
The workflow works isolated on its own. I have swapped the files on your provided workflow to the ones I would need in my workflow. I am going to test this out on the actual workflow after lunch and will let you know. Thanks for your help man.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I can only get it to work in that isolated workflow. In my org's workflow, it is not working still. I have reached out to our contact at Alteryx and have some time scheduled with them next week. I have tried every solution available, but because of what the workflow is and what we need out of it, I can't use the Directory tool, nor can I use a specific file path and add "|||<Sheet>" in a formula tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CSmith16 I mean the below con figuration
