When creating a workflow to copy content from one list to another, do the columns have to be in the same format?
Background: I have already created a workflow to copy column information from one list to another, once the origination list entry is approved. Everything works fine, with the exception of one column. The columns in the originating list and destination list are the same, except for one exception. I have one column in the originating list using a lookup (from another list), and that same column needs to be set in a Text format, in the Destination list. I need this destination list column in a text format so it will be available as a lookup in an infopath form, for a 3rd list (where observation data will be collected).
When this one particular column was in the same format between the list (meaning the lookup in one list was also set up with the same look up in the other list) this column's content copied over with no issue. When both list were set up this way, this column's content would not show up as a lookup in the 3rd list used for data collection and needing this columns input as a selection.
In the current configuration, I have no problem manually copy and pasting the missing column data from the origination list to the destination list, even though the columns are not in same format (Lookup in origination list and text in destination list). Not sure why I cannot get the workflow to do that for me.
Any assistance would be greatly appreciated.