Populate InfoPath text box based on dropdown list box selection

Following steps will illustrate how to populate InfoPath form text box based on drop down list box selection.

Scenario is, when retrieving data from SharePoint list, we may need more fields to be appear in our InfoPath form based on our selection. The following example will show, how to retrieve items description based on item code selection in SharePoint list.

Steps

Create a data source to retrieve data from SharePoint lits in InfoPath

Add repeating table as follows (You can add any data control from InfoPath controlls)

Change text box to drop down list box in item code column in the repeating table

Double click the drop down list box and select the data source connection you created for the SharePoint list to retreive data from

Click the RULES button to create a rule for this drop down list box

Add rule - add condition - action (select the field's value as) - field (select the field you want have the display. In this case its item description text box)

Click on Fx button to insert formula - click insert field group - select data source (secondary) - select description field - click on filter data button - click add - select ID from secondary data source is equals to Description from the secondary data source

Click on OK button untill you return to following screen

Click on EditXPath (advanced) check box and change the code as follows

xdXdocument:GetDOM("Inventory Item")/dfs:myFields/dfs:dataFields/dfs:Iventory_Item/@Description[../@ID = current()]

Finally when you see the preview of created InfoPath form, you should be able to retrieve Item description by selecting Item code in drop down list box.