I have an InfoPath form with a drop-down list that needs to be populated with a field from an external SharePoint list. However the field is a Look-up Field and when I get it to populate the drop-down all I get are the ID numbers of the item that it is referencing.

How can I get it to grab the text or display name of that field?

2 Answers 2


Here are the step-by-step instructions on how to do just that.

Let me know if you have any questions or need help.

Get InfoPath to display lookup column value, not ID


If you are referring to a lookup field (association) on an External Content Type (ECT) then the method I use is...

  1. Right Click on the field and go to External Item picker properties
  2. Select the 'General' tab
  3. In the 'Display Field Name:' field put the name of the target column from the database (in my case sql).

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.