I think your approach is correct. Using it, you're trying to get the Position for a user, whose email is equal to one of the emails on the list.

Have you tried to debug it? Ex. by adding that formula to a calculated field, to see what output gives the Lookup function?

Regards, Tomasz 

Yes,the formula is in calculated value field, and it gives nothing (just blank) its should give true/false as the function return true/false value.

if the user email exist in the list and position field empty it returns True, and false if position field is not empty.

i need to return False if the user does not exit in the list !! any idea ?? looks like lookup is not the right function that we need in this case !!

thank you Tomasz for your help

Does the Lookup function return blank if no position is defined for a looked user or its value if it is?

Yes, lookup returns blank if the position is empty.

lookup("Managers", "email", Current User (Email), "Position") 

if the email does not exit in the list (my case), i cannot return True/False using

isNullOrEmpty(lookup("Managers", "email", Current User (Email), "Position"))   

if the email  exit  in the list, i can return True(when position is empty), false if position is not empty

isNullOrEmpty(lookup("Managers", "email", Current User (Email), "Position"))   

thank you

Hi Tomasz;

the function is working fine, i had a local issue with the user email a was testing with. my bad, sorry, and thank you for your help as always;

thanks

Ahmed

Thanks for your kind words. Good luck in Nintexing

Regards,

Tomasz