Specify sheet name in Dynamic Input for reading .xlsx file

[srk0609]

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?

[DataNath · Accepted 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'

[Armon24]

Hey @srk0609 !

Here is a sample workflow with the solution. Hope it helps. 

[srk0609]

Thank you. I'll check and let  you know if it worked😊

[srk0609]

Thank you. I'll check and let  you know if it worked😊

[srk0609]

Thank you so much for the solution