How to prepare workflow to read bunch of files by using Dynamic tool from dynamic path

NarendraUBS

Please help me how to prepare the wf, i have data in path:  \\india\Narendra\20250510\raya\office\file\

i used directory tool giving path like (\\india\Narendra\), i want to extract all file folder files which all on particular date example i will give manual from text input- 20250520(here date wll vary as per requirement) i want this date files from file folder thats why i gave until Narendra only, but this is leading huge time consumption, so i tried to prepare manual path with Text input tool and Formula tool. example: Text input tool i gave date field and formula tool i created one field like Path and gave expression like  '\\india\Narendra\'+[date]+'\raya\office\file\' i give date manually then dynamic tool to read  all files from that date file folder but getting error( Dynamic Input (13) File selection does not contain data; select a valid data file.). i gave sample file in dynamic tool input source templete. but i am not sure where need to give give file names are to extract.

could you please advise me how to extract data from manual date given path?

is Dynamic will work only full path come from directory toll only?

do we have any other way to give path manually to read total data 

Please help me to prepaire

abacon

@NarendraUBS Not totally sure what you are trying to do exactly, but this macro allows you to pull all data from the excel files from a directory into a workflow, then you can add a filter on the field that includes the filename to only include the desired files.

Dynamic XLSX Input Tool 

Bacon