cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Lookup function return user display name

Jump to solution

Good day everyone,

I have an interesting question for the form I'm currently working on. I want to display the person occupying a role in a workflow initiation form. Instead of modifying the form each time the person in that role changes, I'd like to perform a lookup on another list to retrieve that person's name.

I'm not having any issues retrieving the information, but the value returned is in [1;#LName, FName] format, but I'd like to get the display name instead. Is this possible or should I just add an extra field in my list to hold their name how I want it displayed?

Thanks,

Daniel

0 Kudos
Reply
6 Replies
Highlighted
Not applicable

Re: Lookup function return user display name

Jump to solution

Hi,

in "Set a variable" action you can click on [...] button and select display name as return type.

i hope this should solve issue. let me know how did it go

thanks,

Reply
Highlighted
Nintex Newbie

Re: Lookup function return user display name

Jump to solution

This would work if I was using the lookup in the workflow, but this lookup is to display the person occupying a role (designated in another list) on an initiation form. I can only connect the calculated value to list columns, and the data can only be saved as string, int, decimal or currency.

Reply
Highlighted
Not applicable

Re: Lookup function return user display name

Jump to solution

[1;#LName, FName], we can store this type of value in workflow variable (type people/group).

and this variable can be used to assign display name or login name to another workflow variable (type string)

Reply
Highlighted
Nintex Newbie

Re: Lookup function return user display name

Jump to solution

Updated explanation:

I am using a Calculated Value Control in my workflow initiation form to show the name of a user in another list. There is no option to pass a calculated value on to a workflow variable. I could pass it to a list column, but my goal is to show the display name on the initiation form, so this does me no good. I was hoping that perhaps there was a way to choose the output column's return type. Perhaps something like:

lookup(list title, column to filter on, value to filter on, output column:return type)

I have 17 roles on the initiation form to choose from.

My initiation form has 17 choices displayed as follows:

[Label]: [Calculated Value] [bool]

Reply
Highlighted
Nintex Newbie

Re: Lookup function return user display name

Jump to solution

Soooo... my workaround was to add an On Modified WF to the Executives (lookup) list to populate a hidden Display Name field whenever the executive is changed. I then return that field in my workflow initiation form calculated value control lookup.

It would be nice if I could have just selected the return type I required...

View solution in original post

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Lookup function return user display name

Jump to solution

You can use the parseLookup() function to get rid of the list ID and ";#" . For Example,

parseLookup(lookup("mylistname", "ID", "10001", "Created By")).   This is much easier than creating another calculated column.

0 Kudos
Reply