Action: Update value with Formula Not working

ChrisSpr

So here's the brief: This isn't changing the filename.

Here's the long of it:

I have a single excel workbook with a sheet for each day of the month plus two at the end that i don't care about.

I need to build a csv file with the data from the range B22 to C25 from each day.  

I tried to do a dynamic input solution (Pull in the sheet names then go through a Dynamic input tool) but, despite visual evidence to the contrary, the tool errors saying the schema is different on each page.

Right now I'm just trying to pull yesterday's data and that will be the main function going forward. Run once a day and pull yesterday's data appending to the sheet.  

The issue is I can't seem to get this to function.  It does nothing.

Can someone help? 

Thanks in advance.

danilang

Hi @ChrisSpr 

What you've created is a batch macro with the control parameter used to pass in the date your looking for.  When you run the macro workflow directly in Designer, the control parameter and the corresponding action tool do not get executed.  It's only when you take your macro and insert it into a calling workflow the the action tool will work.  

The expression in your action tool doesn't actually use the value of the control parameter.  It calculates the day before today.  You can replace the parameter and action tool with Text box coupled with a dynamic input like the attached. 

The Dynamic input tool is configured like this to replace the entire path of the Input Data Source Template from "text.xlsx" to the value of the [destination] field.

This will read the values from the previous day's worksheet. 

Dan

UpdateSheetName.yxzp