Setting lookup column in Update Action

[kannan1]

Hi all,

I had to add lookup columns and other column to an existing list and loop through the list and update all the list item from another list. 

I was able to update all the fields except lookup columns

Here the projectNo is the lookup column i am looping through and updating "ProjectNo" from another list.

While normal field gets updated the lookup column is not updating.

is there a way around it? I even tried to copy past the values directly from an excel file but that didnt work either.

Best Regards

[v-litu-msft · Accepted solution]

Hi @kannan1,

Update the lookup field should use the ID of the mapping list item, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.