I am trying to update a column (called zone) in the SP library that is a lookup field on a list (also called zone). I know the ID of the lookup item that I want the column to be updated to but I am unsure how to set/update this value in the SP library.
I have been doing a lot of googling and it seems I need to set the ID of the lookup item to the zone column in the SP library. I am doing the update (as below) but I keep getting the coersion error. What is it that I am missing? I have written out the ID of the item in the list I am looking up and I can see its the correct ID number but I just don't now how to set/update it correctly