How to set dynamic field to be "replaced and found"

[Carrot_WinWin]

Hi Team,

I'm trying to figure out whether I can combine the "action" tool to "find and replace" tool. so can dynamically select the field used as "find within field"

I'm unable to upload the link, so allow me to describe my imagine workflow:

1. the list box allow user to pick 1 column

2. action box

3. find and replace. and the "find within field" part is using the user choosing column from the 1. 

Thank you so much. 

[binuacs · Accepted solution]

@Carrot_WinWin Sample workflow attached

[ShankerV]

Hi @Carrot_WinWin 

Please try the below workaround.

Collect the value using Formula tool and use the value against Find and Replace tool.

Many thanks

Shanker V

[Carrot_WinWin]

Brilliant Solution! Thank you so much for your quick and accurate response.