asked on

How do I bring in First,Last name instead of domain/inc in my . . . ModifiedBy%] action?

My workflow is pulling up the AD domain/co. in my. . . (list):ModifiedBy%] instead of First,Last name. The actual Modified By column is displaying the correct First, Last Name, which is what I need to display in my Send email action. Is there some kind of code or variable that I need to add to the workflow to make this display the user's full name instead of profile AD? You would think that this would be included in the Send email action pop-up as an editable area.

Thanks

zephyr_hex (Megan)

there's a project on Codeplex that will allow you to do this.

Check out the Lookup User Info activity.
http://spdactivities.codeplex.com/Wikipage

then see my workflow below. i am using the Lookup User Info activity to lookup the employee name in the Employee column and storing that value (without the domain) in another column called Employee Name so i can re-use it without having to constantly look it up.
lookup.jpg

MelodyJT

ASKER

I am using Sharepoint Designer 2007 and am working in Moss 2007, I cannot see any option for a Lookup LinkTitle property in the Actions. Is this 2010 only? Where is this option? It seems that it would solve my problem. I read all the codeplex blogs and it is confusing.

ASKER CERTIFIED SOLUTION

zephyr_hex (Megan)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MelodyJT

ASKER

Sorry it has been a while - out of town. Anyhow, I just tried this solution, it downloaded fine and I was able to install and see the new actions. But the Lookup LinkTitle property is not working for the Modified By column. I want to take the info in that column which displays properly in the list (fist name, last) but does not display in workflow email I am sending correctly domain/name user.
I followed your instructions and set my workflow to the following and it set to run when an item is changed in this list, but the workflow is not even running. Any ideas?

MyPicture459.jpg
MyPicture460.jpg

MelodyJT

ASKER

This never really worked, but I found my own solution.