Macro gives error "Unknown Field Type"

Question

I've made a macro to cleanse and capitalize certain name types and it works fine with the _test_field_

However, when I try to use it in a normal workflow I get the error "Unknown Field Type" regardless of whether its a file (xlsx or csv) I'm using as input or like the below text input (I have attached this test program)

Tool 8 is the first of my multifield formulas (titlecase and cleanse punctuation) and I cannot see anywhere that it's configured wrong, but it must be.

I have attached the macro to this post and hopefully someone can help me get this working.

test name cleanse.yxmd

Cleanse_Names.yxmc

DataNath · Accepted Answer

@LFerg in your macro, you're currently using an action tool to change the field incoming field type that the List Box looks for:

When using the List Box in select mode, you ought to be able to just plug this straight into the Q anchor of the tool in question:

Upon doing so, the flow should run as expected: