Inputting multiple excel files using dynamic input

[sky007]

Hello,

I'm trying to input a ton of excel files from a folder into my workflow and I tried using dynamic input but I'm having issues understanding the issue. I've changed the filepath to include "*v1" and I've told the dynamic input to read from the fullpath field from the list and it is saying file not found. Can somebody help me?

[JosephSerpis]

Hi @sky007 from your screenshot you will need to change the action to Change Entire File path rather than Append Suffix to File/Table Name in the Dynamic Input Configuration. 

[sky007]

Just tried that and it still says file not found.

[JosephSerpis]

Hi @sky007 I think its errored due it needing a sheet name. You should have a look at this community post. Also this post might be helpful too.

[sky007 · Accepted solution]

NVM I figured it out! This link told me everything! https://www.youtube.com/watch?v=1y1gFXDkYwA