I am using SharePoint Designer workflow to copy data from two identical list(with same column names) to another same list for backup purpose. Backup list created using one of the list's template.
Issue is, data is getting copied but in destination list it has created duplicated columns. For e.g. i have Name, EmpId, Address columns in my source lists. I am running workflow on above lists which is copying data to backup list. Now when workflow runs, backup lists get one more set of same columns created automatically. i.e. Name, EmpId, Address, Name, EmpId, Address. (though their internal names are different but display name is same)
List A data getting copied to fist set of columns and List B data getting copied other set of columns.
Any reason why? or workaround for this?