Skip to main content
Nintex Community Menu Bar

Hello All,

 

I'm trying to create a simple lookup =

 

 

lookup("DivisionHeads","Title", SelectedDepartment,"PlainText")

 

but I never get the lookup item "PlainText".  Therefore I wanted to see what the "Title" and SelectedDepartment (named property) were so that I could make sure they matched.  Turns out the named property SelectedDepartment (which is a drop down list connected to the title of the list "DivisionHeads" shows up with the prefix 1;#  ,   2;#  , 3;#  etc.   Thus my lookup will never work because Title will never equal the named property SelectedDepartment.  What gives!  why are the selections prefixed?

 

 

 

I found a post where someone states to use parselookup so I changed my lookup statement to:

 

parseLookup(lookup("DivisionHeads","Title", SelectedDepartment,"Lookup:PlainText"))

 

but this does not work either.... bummer

 


parselookup resolved this issue