In Nintex Form 365, I would like to return True/False if a user does not exit in a list (Managers)
I have tried :
What function i can use to return False if Current User(Email) does not exist in Managers list ???
Thank you for your help.
Solved! Go to Solution.
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?
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
Yes, lookup returns blank if the position is empty.
if the email does not exit in the list (my case), i cannot return True/False using
if the email exit in the list, i can return True(when position is empty), false if position is not empty
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;