I am trying to automate part of an invoicing process where I access specific excel files within multiple variable sub folders in order to save them as PDF.
We have one constant parent folder which contains multiple sub folders for each client (the list of clients may change month to month), and then we have the target files within those sub folders. (See pictures below.)
Please see attached process and advise on how to best iterate through the sub folders AND iterate through the files within each sub folder to then be able to access the “INVOICE” excel.
My guess is that I would need to use GetDirectory to save each of the file paths for the invoices within each client sub folder as a variable to be used to specify in the excel application scope.
I am currently having an issue specifically with assigning the files array variable to the GetDirectories of the sub folder array variable. I’m not sure how to go about translating the sub folder array variable into string (rather than array of string) to assign files array variable to it. . .
I would appreciate any and all ideas.
Iterate Through Files.xaml (14.1 KB)