How do I pass formula result into field of another tool?

[BlaseG]

Azure datalake input tool doesn't have the option to use wildcards or search subfolders. 

As a workaround I thought I could create the file path string, then pass it into a action tool, and update the file path field with what I created to pull yesterday's file everyday.  

My issue now is - how do I configure the action tool to reference the result of my formula to replace the filepath in the action tool?

Examples attached.

I can't figure out how to pass my formula result, to the action tool, so I can select it on the update field option..

Thanks so much everyone

Blase

[BlaseG]

I'm trying to pass the formula result which is the file_location into the azure data lake input tool's file path.  

So pretty much trying to figure out how I can reference this formula result in the action tool?

[Qiu]

@BlaseG 
I have not use the Azure Datalake tool an dont have a test environment, so tried with the "normal" data input tool.

Maybe we can use a Text Box to input the new path? 

[BlaseG]

So you're saying I should create the filepath in excel, and the action tool is linked to that excel file?  Does this work when running on server gallery as well?

Pretty much I have a formula tool right now that has the path , which is pretty much set to show the previous dates directory.  Then trying to pass that into the action tool as the replace string in the azure data lake file input "File path" field.  

This way everyday it runs, it updates the filepath to the previous days date, to pull yesterday's file.  

[BlaseG]

We found out that the formula result actually is being passed but since this is a app now because of the action tool, when refreshing on designer it doesn't update the field properly.  I was told need to deploy to server then run it from there for it to work- working on getting data lake input installed on our server now as well.