I am stuck using workflows, so no C# is allowed - I'm trying to copy only certain items, on which the workflow will be triggered, to another custom list within the same domain
The workflow can do the mapping of the different items, so that say column1, column2 and column3 of Test list end up in column2, column5 and column8 of Final list.
The question is how can I read the data from the external list within the workflow? I though that external content types would allow me to load an external library into a local library that would auto-update itself, but it seems to be disabled. Should it be turned on, to allow this type of behavior?