Skip to main content

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!

Hi @kgiles 



 



Try putting quotes



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


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


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)


Thank you!


Reply