I need 2 different file paths two be read before a dynamic input

Question

I have a workflow set up to read a specific tab in 6 months' worth of files and calculate the 6-month average for each row. The file originally contained 3 different tabs: data, summary, and summary & summary and 6-month average.  After 3/21, we removed the summary tab. Now that I've removed the tab from the file, I am getting the Dynamic Input (375) error on every file after the tab was removed, and workflow will not calculate the 6-month average correctly. I tried to update the full path formula to read the summary & 6-month average tab, but the total comes out lower and cannot read another batch of files. Is there a way I can have the workflow read both tabs? For example: Read the summary tab, and if it does not match, then read the summary & 6-month average.

Error using Summary Tab.PNG

Previous Table Summary.PNG

Forumla.PNG

Previous Table Summary and 6 month.PNG

Tabs without Summary.PNG

GMG0241 · Answer

Hi, looks like I can recreate the error when the dynamic input tool is trying to read in a sheet name when the sheet name doesn't exist. In your case, this will be because the Summary sheet which you are specifying in the formula tool no longer exists in the file. After running some tests, I can conclude that it is not an issue with the data source template. I don't completely understand what you mean when you want to test if the summary tab will or won't match, but if you want to test if a sheet exists, you should read in the list of sheet names from your source input, and then you can use formula/filter tools to update the path you want to read. For example, you will use '|' to get the list of sheet names from your file like this: C:\path o\file\dynamicInputTest.xlsx| Then, you will use a formula/filter tool to detect which sheet name you want to use, and you can adjust your formula tool to be [FilePath]+"|"+[Sheet Names] (or something similar) before putting that through the dynamic input tool.

apathetichell · Answer

Hypothesis - > Dynamic Input - a tool I have said very mean things about - requires a template when reading in files. you have your template set to a file which had Summary sheet. It no longer does. Dynamic Input is not happy. Click on it. Remap template to a different sheet. Rerun. Don't delete new sheet.