I just created a simple workflow to copy the current list item to a list in another site. That works great, except for one challenge. The original list has a lookup field, and when that field is copied into the final list, it results in nonsense data.
as you can see it is simply a string value that was created off of a lookup column (which that column is the hyperlink you would expect)
Destination List, the value of this field is:
(would have put another screenshot to show the difference if i could, but unable to…)
Unfortunately, this field is a key field in the destination list so i can’t just omit the field, it’s critical to the data strategy and architecture that’s being set up. Any ideas or help would be tremendously appreciated!