I've tried searching for this as I'm sure others have had the question but can't find a way to word it to find a result.

I have two lists setup - one with a list of people and their data (IDs, First, Middle, Last, etc) and another list for incidents. I wanted to use a lookup at first so I could point to the list of people and pull in multiple fields - Sharepoint does this great.... however it doesn't allow you to sort the list which is why I went the InfoPath route.

I currently have a dropdown list setup to get choices from an external data source (the People list) and it's does a fine job... I just can't figure out a way to also pull in additional fields from the people list. For example, I can choose John Smith on the list, but how can I automatically pull his additional fields into the Incident list?

1 Answer 1


Using SharePoint default forms you can use a dropdown for lookup from People's list and extend additional fields in Incidents list(But extended fields will not be shown on forms and they will populate after selection of dropdown).

However according to Microsoft's article all types of fields are not supported in lookup columns.

But, If you want to use infopath forms and show additional fields on form, then follow steps given here:

How to show additional field lookup column

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.