I'm trying to bring top 3 Excel files based on date in file name. Each excel file has multiple sheets. There is sheet with name 'A' in all 3 excel files I want read data in sheet A of all 3 files but getting error 'No sheet specified, you must specify a sheet' in Dynamic Input. Can someone help?
Solved! Go to Solution.
Hey @srk0609, the [FullPath] field from the directory output stops at the filename and therefore doesn't contain the filename. Try making a new calculated field using the following expression, and feed that into the Dynamic Input instead:
[FullPath]+'|||'+'A'
Thank you. I'll check and let you know if it worked😊
Thank you. I'll check and let you know if it worked😊
Thank you so much for the solution