Update List Item - Lookup field

Discussion created by g.rios on Feb 7, 2020
Latest reply on Feb 13, 2020 by ChristofN

Hello skybow community,


I've built a dossier with Workplan as my main list. When you add a new item to that list you have to add a Risk Register item (lookup on a sublist) to your Workplan item (WPI). At the same time, the Risk Register item (RRI) memorizes which WPI has used this RRI.  

The Update Action was easily configured. My problem is that the old values get overwritten, which is not what I want.

This is how I want it to look like in RR (this can be archived manually): 

I tried to get the values by using this method: 



var values = [[@Web.GetFirstValueForQuery('Risk Register', '<Query><Where><Eq><FieldRef Name="Workplan" LookupId="TRUE" /><Value Type="Lookup">'+[[RiskRegister.Key]]+'</Value></Eq></Where></Query>', 'Workplan')]];

return values;


Can someone please help me?