Update List Item - Lookup field

Rios, Gloria

• Created February 07, 2020 09:48

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?

0

• 

  Christof Nussbaumer

  • February 13, 2020 19:32

  Hi Gloria Rios

   

  From a entity relationship model perspective is your diagram not exactly representing the description and includes double listed entities like Workplan - or when it's just a field/column it should have another notation.

   

  I would interpret your description there is always one Risk Register per Workplan but a Risk Register can be related to many Workplans. This would bring up the Risk Register above Workplan in the ERM.

   

  

   

  In that approach you can simply work with single lookup fields.

  Hope this helps.

  0

Please sign in to leave a comment.