Dynamic Input not finding file folder

[CaitlinFallows]

Good afternoon,

I am trying to use a Directory to connect into a Dynamic Input to get files from two different subfolders.

I keep getting the error message "cannot find file". No one is in the file, and it is accessible. I have not edited the FullPath name, and it matches the folder itself. I have tried truncating the file name using "Short Name" but this is blank in my Directory tool so does not affect the FullPath - I read on the forums this is limited to 260 characters?

The full name is pulling in, including the individual file names, into the FullPath. Filtering works as I expect; I'm able to pull just the files I need from the Directory.

Please see a screen grab of the workflow (confidential information redacted):

How do I get my Dynamic Input to read this file location?

TIA

[PhilipMannering]

Try adding the sheet name (whatever that might be) to the end of [FullPath] (separated by three pipes). So in a Formula Tool - update the FullPath field - with something like,

[FullPath] + '|||Sheet1'

[CaitlinFallows]

Hi Philip,

The sheet names are different in each file; how do I get around that?

[CaitlinFallows]

Hi Philip,

I've managed to do that but it's still returning the same error.

[PhilipMannering]

If you add "|||<List of Sheet Names>" to your FullPath and pass that into your dynamic input tool you should get the Sheet Names. Then you can send the FullPath + [Sheet names[ into the Dynamic Input (note that if the schema is different between your files you may get this error - then a batch macro solution might be required).

To get the list of sheet names, in a Formula Tool,

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

This should get you the Sheet Names.

Let me know if you can get to this step.

[CaitlinFallows]

Hi Philip,

Thanks for that. I got around the sheet name issue by separating the two reports out.

However, I'm still getting the error.

Thanks!

Cait

[PhilipMannering]

Can you screenshot the error with the FullPath you're trying to find?

[CaitlinFallows]

Hi Philip,

It's in the original post. I've had to redact some information due to confidentiality.

Cheers,

Cait

[PhilipMannering]

So, like in my original comment, you need to add a sheet name to your FullPath. The FullPath in your screenshot does not have this.

[CaitlinFallows]

Apologies, you're absolutely right - I have amended the FullPath. Please see here:

It still has the same problem though: