Getting trouble Selecting sheet

[Jay2022]

Hi,

I have this flow that have been working just fine for the past year, but now I'm getting an error message " No sheet specified"   in my "dynamic input tool" when I clearly specified a sheet name. I have double check on the sheet selection and so far cannot come up with a solution. 

Below is a screen shot of what the flow looks like

[PhilipMannering · Accepted solution]

Try using a Formula Tool before the Dynamic Input, where you update the FullPath with a sheet name. Something like,

[FullPath] + '|||Sheet1'

[Jay2022]

that works! thank you