Is it possible to create a new item in a different list (same site) and populate the lookup column back to the original item? My initial test gave me this error: "Unable to transform the input lookup data into the requested type." Thanks!
Solved! Go to Solution.
This is correct. You need to set the ID value for a lookup like you described.
In addition, I would recommend clicking the ellipse (...) and selecting proper data type. The default is integer, which will work, but I've found that selecting List ID has provided more consistent results This can help prevent some data conversion issues like the error you saw initially. It isn't a hard requirement, just something I've observed overtime.