AnsweredAssumed Answered

get values from another sharepoint list

Question asked by sangel40 on Dec 23, 2016
Latest reply on Dec 23, 2016 by m.fostyak

I have a form that makes use of three lists:

 

List1 - Purchase Request

List 2 - Purchase Request Details

List 3 - Project Business Unit

List 4 - Project 

 

The form has List 1 as the primary list with List 2 as the sublist.

 

List 2 has a column Project Business Unit that is a lookup to List 3 column ProjectBU. The Project Business Unit column has a value like 1111 - CORP which consists of a project code and business unit joined together. List 3 also has the values for project and business unit as separate columns.

 

From the project column on List 3 I need to access List 4 to retrieve some values using the project column on list 4.

 

I need to retrieve each of the values seperately and show them in the List 2 on the form as soon as the project / business unit is selected.

 

I have tried doing this via a calculation on the sublist column using a CAML query but I always get a null returned.

 

window.projectCode = [[@SubListCurrentRow.EPFRDetails.PCMU]].toString();
window.project = window.projectCode.substring(0,4);

return  [[@Web.GetFirstValueForQuery('Project', '<Where><Eq><FieldRef Name="Title" /><Value Type="Number">[window.project]</Value></Eq></Where>', 'StrategicPriority')]];

 

Any help would be appreciated.

 

Thanks Sandy

Outcomes