Solved

UserProfileLookup my email

  • 17 August 2022
  • 4 replies
  • 195 views

Userlevel 1
Badge +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!

icon

Best answer by Garrett 17 August 2022, 17:36

View original

4 replies

Userlevel 6
Badge +16

Hi @kgiles 


 


Try putting quotes


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

Userlevel 1
Badge +4

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

Userlevel 6
Badge +16

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)

Userlevel 1
Badge +4

Thank you!

Reply