There is a problem that I am experiencing with a InfoPath form I am creating.

I have two SharePoint Lists. 1 - Contains the database of assets 2 - Will contain the test logs for each of the assets in List 1

I have designed the InfoPath form in List 2 to look up data from List 1. It is a simple rule based lookup on the serial number of the asset in List 1.

When I get the results back in List 2 the fields in List 1 which are Dropdown boxes are looked up but comes back as the ID number not the name.

Does anyone know why this is happening? If you need more info please just ask. Thanks.

1 Answer 1


Go to List Settings -> click on your Lookup Field -> check if this setting is set to Title:

enter image description here

  • Yep that's all set correctly. In List 1 you can select the name from the dropdown but when List 2 is referencing the dropdown in List 1 it appears as a number. Jun 30, 2016 at 14:58

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.