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?