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?