cancel
Showing results for 
Search instead for 
Did you mean: 
ArturB
Nintex Newbie

External list lookup

Hi,

I have an external list imported to the SharePoint from SQL Database and what I noticed is that I cannot use the lookup function in the calculation filed within the list form.

I have inside this DB informations about the emplyees and i need to match them with the current user (location, personal numbe etc..). As the funcion dont return en errow while reviewing the form it always give back the '#Value!' - so I'm assuming the sytax is correct.

 

This is my syntax: lookup("xxxxxxxx|CommonDBView","Employee - Domain identifier",CurrentUser,"Employee - Personal Number")

 

Domain indentifier was desinged to be exactly the same as Current user as while I was doing same thing before but not with SQL DB but with updating SharePoint list form Access averything was working well :)

 

Should that lookup function work and I'm doing something wrong? Or it's just a way it is?

Labels: (1)
0 Kudos
Reply