How to Pull In SharePoint Lookup Additional Fields Into InfoPath Form
Download The Presentation
When creating an InfoPath form for a SharePoint list, you may need to bring in SharePoint lookup fields into the form.
NOTE: The solution as it’s listed here is for EDIT mode forms. If you would like this to work in READ mode forms, follow the same instructions below but then you will have to do an additional couple of steps (listed at the bottom of this post).
In this example, I have a list called “KPI Actuals” and in its List Settings (below) you can see I did a lookup to a list called “KPI” and I brought in some additional fields from this list, such as KPI Category, Description, Owner, Team, etc. In this tutorial, I will lead you through how to add the “KPI: Team” additional field to an InfoPath form.