How to get tab names in data when using download tool

[gauravnegi2]

So I have to download a file from somewhere and have to show the sheets name of that file 

I used download tool to get the file but now when i am using dynamic input i am not able to get the sheet names. i don't want the sheets data as an output i am looking for sheet names only 

suppose there are 3 sheets in a excel file so the output should be the name of the 3 sheets

sheet1

sheet2

sheet3 

[joshuaburkhow]

Hey @gauravnegi2 It's going to be hard to tell what you need to do without seeing the workflow. Are you able to share or maybe screenshot the output of the select tool? Are you outputting a temp excel file? 

[Jonathan-Sherman]

Hi @gauravnegi2,

I would add a formula tool before your dynamic input tool with the following formula:

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

And feed this into the dynamic input tool, which will return the list of sheet names in each file.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[gauravnegi2]

@Jonathan-Sherman @joshuaburkhow  Here is the workflow with the URL

@Jonathan-Sherman i already tried this but it didn't work, can you please check what am i missing.

[joshuaburkhow · Accepted solution]

The issue you have is in your formula tool. The string size is too small 😉  I created a new field and gave it a bigger size string and then I updated the dynamic input to look at that new file name, it works now. 

Hope this helps. Please mark as solved so others can see it

[Jonathan-Sherman · Accepted solution]

Hi @gauravnegi2,

The size of your [file name] field was too short and cutting off the extra text you added in the formula tool. I've upped it and it works perfectly!

If this solves your issue please mark the answer as correct, if not let me know! I've attached an updated workflow for you to download if needed.

Regards,

Jonathan

[gauravnegi2]

@joshuaburkhow @Jonathan-Sherman I didn't noticed that, thank you for the help.