Hi is there a workaround for a scenario where there are multiple excel file as inputs. using "*.xlsx" we are able to make the workflow function, however there seems to be a restriction on the server.
Note: the inputs are dynamic there could be 2 excel files or up to 12 on any given day.
is there any workaround for this, any suggestions would be of great help.
Hi @olimpio
Is the limitation you're mentioning around the Folder Browse tool?
There's a workaround by having a Text Box instead of the Folder Browse tool and the User would simply copy and paste the file path to where the excel files are. The rest is done with the wildcard in the input tool like you mentioned.
* You need to configure the text box to dynamically replace the file path of the files with the Action tool.
Cheers,
Yes we have tried the text input option, it works on the analytical app however, once we move it to server , the text input replacement does not seem to work and the workflow is searching for the local drive and giving an error
unless there is something i am doing wrong, where you able to successfully move the workflow to the server and it was reading multi files through the server. also, can the text input connect to a directory tool i have tried both the input and directory both give an error
would you be able to share a workflow that would help? that would be really helpfull
hi, we meet the same issue, do you find a way to resolve it?
The Text Box Tool solution might work if the user gives the fully-qualified/absolute UNC path.
For example:
The issue would be whether or not your users are computer-savvy enough to provide the proper address. Some workarounds I can think of: