I have two SharePoint Lists. My primary list consists of Field Names with their definitions. My secondary list consists of all the values and the value's definition for the field on my primary list with a look up column to the ID for the primary list. My intention is that when the user clicks on the Field Name from the primary list, that I could populate the values associated with that field from my secondary list on one Infopath form. I have yet to figure this out. When I add the secondary source to the Infopath form, it brings back every value on the secondary list and not just the values associated with the ID on the first list.

  • Is it like a mapping in your second list. Example Field1-Value1,alue2; Field2-Value1, Value2. On InfoPath form, you need to get value1 and value 2 for field 1. Am I right? May 23, 2017 at 13:22

1 Answer 1


Please make sure to apply the filter (rule) for the secondary list lookup ID.

It can be done by following steps (high level) :

  • Add rule for the property and select set field value
  • In the rule detail you have to select the field value (destination)
  • In the value field, you have to map the source and destination lookup field values to apply the filter like below :

xdXDocument:GetDOM("DatasourceName")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Engagement_x0020_PMM/pc:Person/pc:AccountId[../../../d:PMOPMM/pc:Person/pc:AccountId = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Portfolio_x0020_PMM_x0020__x0028/pc:Person/pc:AccountId]
  • Yes, map all the require fields
    – Palani K
    May 23, 2017 at 13:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.