Selecting fields from a workflow based on fields selected in an interface tool

I have a workflow that populates a Multi-Select Interface tool with field names available in the workflow. I want the user to select which fields they want to see on their output. How can I do this? In my example, if the user selects they want to see Red in the output, the second screen shot is what I'd like to see. I don't know how to tie the two together and from my mainstream workflow (simplified below) select a few required fields like Customer and Region and then only the fields the user wants to see which is Red. I've got a list of about 40 fields the user can select from to determine want end up on the output. ABSOLUTE BONUS if someone can tell me how a user can inform the workflow of the order they want the fields in on the output and I could work that into the workflow (which resides on our gallery).

Input

Output

Interface Tools

Accepted answers

philipmannering

Hi @jjoerger

Does this do what you need?

If not, let me know and I'm sure I can amend

Select Fields.yxzp

All comments

philipmannering

Hi @jjoerger

Does this do what you need?

If not, let me know and I'm sure I can amend

Select Fields.yxzp

jjoerger

This works absolutely fabulous! Thank you. Has anyone ever mastered allowing a user to specify the order of columns of an output (excel spreadsheet.)?

philipmannering

Hi @jjoerger

Glad it works for you!

Not sure. To be honest I never tried before now. Looks like what you can do is select an order manually in the macro, and then connect it to a tool to say if you want to this order (True) or not (False). But you can't give the user complete freedom in choosing the order (as far as I can tell).

See example attached,

Select Fields and Order.yxzp

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167