Calculated value lookup and userProfileLookup on returned value does not work

  • 8 March 2019
  • 5 replies
  • 22 views
M
Badge +1

I'd like to get an email address of a person returned from a sharepoint lookup in a calculated value. The column in the sharepoint list is a person, not a string, but it is returned with prefixed apparently with some index semicolon and hash, and then a Last Name, First Name.  

 

Firstly, parseLookup() does not work on the forth argument to lookup. Only

on Lookup List value types. Second, userProfileLookup() wants a real person field, not some string.

 

Ideally I could do something like:

 

lookup("Projects", "Title", parseLookup(Standard), userProfileLookup("Project Manager", "WorkEmail"))

 

Instead I have to suffer with something quite ugly like this just to get the Last Name, First Name

 

substring(lookup("Projects", "Title", parseLookup(Standard), "Project Manager"), 4, length(lookup("Projects", "Title", parseLookup(Standard), "Project Manager")))

And even this is shaky as the index/id could be 1-x digits, not just 2.

 

Has anyone done this? (Without creating another column in the source list with the desired info)

5 replies

E
Badge +17

Can I recommend using the userProfile lookup function available within the calculated control. You can possible have the lookup control provide the name and then reference that as part of the formula to get the email address or just get the email address directly.

M
Badge +1

Are you suggesting the following?

  • creating a new form field with type Person
  • populating it with the lookup name value (FYI it is in the form last name, first name)
  • Running the userProfileLookup on that Person field  
J
Badge +4
yes I could use the answer to this as well, what is the exact syntax to get the userProfileLookup based on another field / @eharris04 how would you structure it?
D
Badge +2

I just added this to a form myself this morning;  I have a calculated value field that uses the userProfileLookup function to display the Job Title of the person entered into the Employee field on the form (which is a People field).   The configuration for this is as follows...

3960iD13DD82719CBDAD9.png

 

Here is how it appears in the properties of the Calculated Value control:

3961i5C410FC1C12C826D.png

Here is the Calculated value field working in the form:

3963iE3C81364935AFB5D.png

 

Hope this helps.

G
Badge
The internal property name you mentioned is the properties of oser profie as"PreferredName","Manager" etc.not the internal name of the list

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings