Enclosed please find the template
- Unable to get the lookup field value through.xsn
that shows and updates Infopath form of DeliveryList list
I've cleaned unnecessary fields. having created ists:
ClientList with fields::
- ClientName (Single Line of text)
Title_ClientList (renamed the default Title)
RequirementList with fields:
- ClientListID_Lookup (Lookup for ID of ClientList)
ReqDesc (Single Line of text)
TitleRequirementList (renamed from Title)
DeliveryList with fields:
- ReqmtID (Lookup for ID in ReqmtList)
CandID (Single Line of text, where I render ID of chosen
client from ClientList for chosen ReqmtID)
CandName (Single Line of text, where I show ClientName of
chosen client from ClientList for chosen ReqmtID)
Title_DeliveryList (renamed Title)
and filled with some data
Navigated to DeliveryList and pressed "Modify Form" button which opened it for editing in Infopath Designer 2010
Edited and published there the form

Having clicked on ribbon "From Sharepoint List" created the data conncections for 3 lists:
- ClientList_Wizard
- RequirementList_Wizard
- DeliveryList_Wizard
for corresponding 3 lists.
On ribbon clicked Data > Show Fields > Show Advanced View (to switch
from Basic View to Asvanced View)
Having chosen ReqmtID drop-down ListBox created 2 rules "Set a field's value":
- Set CandID
to fill CandID with IDs of ClientList items corresponding to chosen ReqmtID - Set CandName with ClientName corresponding to chosen ReqmtID
The first rule "Value:" expression:
- ClientListIDLookup[ID = ReqmtID]
I simply copy-pasted having in mind it as already "calculated" ClientList item ID for corresponding client name,
getting for a 2nd rule:
- ClientName[ID = ClientListIDLookup[ID = ReqmtID]]
Pressed "Quick Publish" )under File tab) and clicked the link in Publish message box: :
- Open the Sharepoint list in browser
https://gennadyvanin.sharepoint.com/Lists/DeliveryList/AllItems.aspx





Note that I have used only codeless (without any coding) clicking and copy-pasting through Infopath GUI