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]

Hmmm.. that looks correct (if the Dynamic Input Tool is set up to replace the entire Filepath and you've correctly set the field [FullPath]). The only thing that looks suspicious is the space in the date folder. Is that space in the Directory Tool output? If so, you probably need to keep it.

[CaitlinFallows]

It's not, but I've tried both ways in case there's some sort of anomaly. Both produce the same problem above.

This is the tool configuration:

[PhilipMannering]

Did you select a sheet in the Input Data Source Template file? That's all I can think of. Beyond that feel free to send a redacted / dummy file over and I can have a go.

[CaitlinFallows]

Hi Philip,

I did that and had a colleague test it - it seems to be system based. We've escalated to Alteryx support as the file itself is fine; if I copy it to my desktop it finds it, but for some reason it cannot see this particular file path.

Thanks for your help, and if you're interested in the outcome I'll reply here once I have an answer :)

[GMG0241]

[Deleted]

[omj1]

Was there a response from Alteryx Support on this? I am experiencing the same issue.

[CaitlinFallows]

Hey,
Yes, they did. You can't have a space after a \ in the name. I had the file folder writing the name as [Column A] + "\ File Path". You need to add the space separately like [Column A] + " " + "\File Path".

Hope that helps!