Sharepoint Designer Workflow - Problem Using A "Person Or Group" Field In A Lookup.
Hi
In a workflow, I'm setting a field in the current form based on a lookup to a "Person Or Group" field. The problem is that this returns the network ID ( network\user), rather than the name.
I want to get the actual name instead. As a work around, I just used a Text field instead, which obviously allows me to get the field contents as it's just text, but then i can't use it to send emails to.
I there any way around this? Is there some way of getting the name from the network ID? Javascript maybe?
I could just have 2 fields for each person (1 Text type to get the name and 1 Person type to email), but that would be pretty clumsy and not ideal.
A computed field that provides a text version of the name as well could be an option, if it's possible?
Thanks.
In a workflow, I'm setting a field in the current form based on a lookup to a "Person Or Group" field. The problem is that this returns the network ID ( network\user), rather than the name.
I want to get the actual name instead. As a work around, I just used a Text field instead, which obviously allows me to get the field contents as it's just text, but then i can't use it to send emails to.
I there any way around this? Is there some way of getting the name from the network ID? Javascript maybe?
I could just have 2 fields for each person (1 Text type to get the name and 1 Person type to email), but that would be pretty clumsy and not ideal.
A computed field that provides a text version of the name as well could be an option, if it's possible?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. That project looks very interesting.
i tried to insall the looking for info action, but got a "no WSS 3.0 installed" error. Any ideas?
i tried to insall the looking for info action, but got a "no WSS 3.0 installed" error. Any ideas?
Did you try to install it on your own PC or the SharePoint server? I think the installation instructions may not be very clear, it's something you install on the SharePoint server, when you open SharePoint designer on your local pc and connect to the server it will then download the list of available actions, including these new ones, from the server.
ASKER
Thanks.
The alternatives would be to either A: create the workflow using visual studio instead using .net code which would allow you look up the name from active directory using the login, or B: create a custom action for SPD which would again lookup the name from AD based on the person field, and maybe store the result in a variable you could use. Again this would be .Net code