4

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?

Improve this question

2 Answers 2

Reset to default
1

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

Improve this answer
1

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).
Improve this answer

Your Answer

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

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