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')]];
Can someone please help me?