Hi,
I am getting error
Why am I getting this? I am trying to be able to alter:
1) the Column name from the formula tool dropdown
2) the column name in the formula tool
3) the special character to replace with ""
Ie it should go from String-sfs-asda-te to Stringsfsasdate
any help would be appreciated.
Solved! Go to Solution.
Hi @wonka1234 ,
There error is caused by action tool 5. By selecting to replace the underscore in your formula, this action tool will also replace the underscore in "CCOA_String" causing the formula to have an error since it cannot locate the updated column name:
I plugged in "6" as my replacement character and now the formula looks like this:
@phottovy ah thanks, not sure how i missed that... what would be the best to put in here instead of "_" ?
I guess you were trying to replace "-" with your test. Since the column name also has "_", when the workflow runs, it changed your formula to Replace([CCOA-String], "-", ""), which [CCOA-String] doesn't exist.
To resolve that issue, I updated your Action (5) to replace "_". When you run the app you need to input as "-"(with quotation mark around the character).
I also updated your Action (3), in case you want to apply to a different column.