Skip to main content
Nintex Community Menu Bar
Solved

UserProfileLookup my email

  • Aug 17, 2022 2:25 PM UTC
  • 4 replies
  • 514 views
  • Translate All

kgiles
Forum|alt.badge.img+4

I know my email should pop because I can recall it in InfoPath 2013. 

When I attempt either of these formulas, I'm returning blank:
userProfileLookup(Current User,"EMail")
userProfileLookup(Current User,"WorkEmail")
I've tried several other variations but my email is not returning. I have not problem returning PreferredName... Please and thank you!

Best answer by Garrett

Hi @kgiles  

 

I place the formula in a Calculated Field. All are working

userProfileLookup(Current User (Email), "WorkEmail") - Working

userProfileLookup(Current User (Email), "UserName") - Working

userProfileLookup(Current User (Email), "PreferredName") - Working

userProfileLookup(Current User (Email), "WorkPhone") - Working

 

Perhaps you should try to hardcode the "current user" instead of using a variable.

 

You can get the list of Profile Property from Microsoft - https://docs.microsoft.com/en-us/previous-versions/office/sharepoint-server-2010/hh147513(v=office.14)

View original

4 replies

Garrett
Forum|alt.badge.img+16
  • Scout
  • Aug 17, 2022 2:39 PM UTC

Hi @kgiles 

 

Try putting quotes

userProfileLookup("Current User (Email)", "WorkEmail")

Translate

kgiles
Forum|alt.badge.img+4
  • Author
  • Rookie
  • Aug 17, 2022 3:14 PM UTC

No luck 😞 I tried flipping workemail and email as well. 

Translate

Garrett
Forum|alt.badge.img+16
  • Scout
  • Answer
  • Aug 17, 2022 3:36 PM UTC

Hi @kgiles  

 

I place the formula in a Calculated Field. All are working

userProfileLookup(Current User (Email), "WorkEmail") - Working

userProfileLookup(Current User (Email), "UserName") - Working

userProfileLookup(Current User (Email), "PreferredName") - Working

userProfileLookup(Current User (Email), "WorkPhone") - Working

 

Perhaps you should try to hardcode the "current user" instead of using a variable.

 

You can get the list of Profile Property from Microsoft - https://docs.microsoft.com/en-us/previous-versions/office/sharepoint-server-2010/hh147513(v=office.14)

Translate

kgiles
Forum|alt.badge.img+4
  • Author
  • Rookie
  • Aug 17, 2022 3:40 PM UTC

Thank you!

Translate