Lookup value from different list

  • 28 October 2016
  • 1 reply
  • 0 views

Badge +3

Hallo there!

I have a form where user give there user id.

Is it possible and if, HOW, to lookup this user id in a different SharePoint list and fill in the eg. first name (found in the other list via the user id) into a textfield of the form?

THANKS!!!

Jakob


1 reply

Userlevel 6
Badge +13

Hi,

I presume we're talking about a list of users who don't exist in AD? If the users exist in AD then you can find that information directly from AD rather than maintaining a separate list.

If it's the case that these users do not exist in AD, then you can add a control for your user to enter the ID, and then using the List Lookup control, look up the list with your users in, and there is an option for filtering in that control that will allow you to select the column in your "user list" that contains that ID, and filter using the named control where your user will enter their ID. 

Reply