Before I start I'm totally new to Sharepoint My question is, I want to look up a person on a list and return another coloumn with lookup function. I use people picker but it returns domain\user and can't match with person . "Currentuser" sunvtion returns the right data like "0#.w" but I want to select another user , not current user . I hope I explained well , thanks in advance
Solved! Go to Solution.
Name your people picker control e.g. person, create a calculated value control with formula person:
Form looks like:
For a list of properties for userProfileLookup see Default user profile property mappings in SharePoint Server 2013
Once you have named the control as Manfred says above, You could also try using Runtime Controls of "lookup" and "parseLookup" to create a calculated value in a formula? This way you can reference other columns.....
lookup and parseLookup are GREAT controls...... Very useful.