AnsweredAssumed Answered

userprofilelookup with multiple people

Question asked by chrissnc on Nov 12, 2015
Latest reply on Nov 13, 2015 by chrissnc

Hi,

 

I have a people picker field on my form that needs to grab multiple people.   I want the ability to pull real names from this information for an email report that is generated in my workflow and it works great using a calculated column and the following formula

 

userProfileLookup(Meetingattendees, "FirstName")+" "+userProfileLookup(Meetingattendees, "LastName")

 

 

the issue I run into is what if I have 2+ names in my field?   This causes my calc column to return the #Value! instead of real names.   Any ideas?

Outcomes