Error Reading in file with dynamic input, looking for a sheet that doesnt exist,

Question

hi all,

1) I have a dynamic input reading an excel file,  looking for a tab that isnt there.

2) I get error  Error: Dynamic Input (177): 1_Due Next 30 Days does not match a sheet or named range in previous_week.xlsx or the file is corrupted.

How can I bypass this? is there a way to insert headers and sheet in my workflow if a tab cannot be read in?

Thanks.

read in error.JPG

apathetichell · Answer

use a batch macro - not dynamic input.

Raj · Answer

@wonka1234 
you can add a dynamic part into the macro where you can union the headers template as text input so in case you do not have data into the sheet it will not give you the error and you will have the headers