AnsweredAssumed Answered

Coercion Failed when updating lookup field

Question asked by camirvine on May 7, 2016
Latest reply on Mar 6, 2017 by chris.ben

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

 

Please help!

 

Thanks

Cameron.

 

Outcomes