I have a need to merge 2 SharePoint lists into a third list. I'm using the copy item command in SharePoint designer. I've also tried the create item command.
Both work well until I get to a lookup field. The lookup field doesn't copy. I tried creating a local variable but that doesn't work either.
I'm using SharePoint Designer 2013 for an Office 365 implementation. Any help would be greatly appreciated.