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

[dreldrel]

I guess the error is coming from your file paths, it seems like Alteryx can not find your destination file based on the path you gave. Have you verified that all file paths are correct?

[dreldrel]

It seems like the error is coming from your file paths. Alteryx couldn't find at least one of the files on your list. Have you verified if your paths are all correct?

[MinhLO]

Hey @NarendraUBS,

From what I understand the keypoint here is getting this date.
If you know you always need to query yesterday's folder, create the folderpath and use this formula for the date:
DateTimeFormat(DateTimeAdd(DateTimeNow(), -1, "days"), "%Y%m%d")

Otherwise if date is custom, transform your workflow into an app and provide this date in parameter. Then in your app, use this parameter to create your folder path:

\\india\Narendra\%Question.CustomDate%\raya\office\file\

If it does not andswer your problem, can you please provide a sample ?