cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How to return TRUE/FALSE if a value does not exist in a list ??

Jump to solution

Hi;

In Nintex Form 365, I would like to return True/False if a user does not exit in a list (Managers)

I have tried : 

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

--> this does not return True or false, because the "Current user email" does not exist in Managers list

What function i can use to return False if Current User(Email) does not exist in Managers list ???

Thank you for your help.

Ahmed

Labels: (1)
Tags (1)
Reply
6 Replies
Workflow Hero

Re: How to return TRUE/FALSE if a value does not exist in a list ??

Jump 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?

Regards, Tomasz 

0 Kudos
Reply
Workflow Hero

Re: How to return TRUE/FALSE if a value does not exist in a list ??

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: How to return TRUE/FALSE if a value does not exist in a list ??

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: How to return TRUE/FALSE if a value does not exist in a list ??

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: How to return TRUE/FALSE if a value does not exist in a list ??

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: How to return TRUE/FALSE if a value does not exist in a list ??

Jump to solution

Thanks for your kind words. Good luck in Nintexing

Regards,

Tomasz

0 Kudos
Reply