Action Tool - Can't Update Cell Value with Action Tool and Foruma Tool

[T_Lina]

Hi there, 

with the Action Tool, I'm choosing a value from a drop-down list. I want this value to update cells in my workflow, for one of the columns. 
I'm connecting the action tool to the formula tool to do so. Is this the right approach? It doesn't seem to work, the cells in the required column are not updated... I seem to miss the connection between the value chosen from the dropdown and the formula tool.

Do you have any hints on how to solve this? 

Thanks a lot for your help. 

Regards

T_Lina

[christine_assaad]

Hi @T_Lina 

Will you be able to share the app or how the 3 tools were configured?

Cheers!

[Maskell_Rascal]

Hi @T_Lina 

If its just a simple field value update from for the entire column based on the drop down, you can get rid of the Action tool and connect the Drop Down tool straight to the Formula tool like below:

The Formula tool will need to be configured to the column you are updating, and the formula itself will be the name of the connection. In the example above it is [#1]. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[grazitti_sapna]

Hi @T_Lina,

Can you please share the configuration of the tools? Is it a part of the formula that needs to be updated ?

[T_Lina]

Formula Tool configuration (goal: change the value for "Input_Dropdown"):

Action Tool Configuration:

Drop Down Configuration: 

[grazitti_sapna · Accepted solution]

Hi @T_Lina,

Can you please select the highlighted portion as shown in the screenshot below:

Once you select this in the Replace a Specific String Keep only Input1, remove everything else from there. Then try and run the workflow again.

I hope it works for you.

[grazitti_sapna]

Hi @T_Lina ,Please refer to the screenshots for better understanding.

I hope this helps.

Thanks.

[T_Lina]

Thank you very much, it worked !! 🙂