I recently converted an InfoPath 2003 Form that I used to publish as a form library. I converted and saved the form to an InfoPath 2007 Web Browser Form. I’ve been playing with the form and noticed how different these two formats work. I have been able to get most of the form working but I’ve been stuck for three days now trying to figure out why GetUserProfileByName does not work properly. GetUserProfileByName pulls UserName just fine but I can’t figure out how to get LastName, FirstName, or Email. So, substring-after(userName(), "xx") works fine but “concat(Value[Name = "LastName"], ", ", Value[Name = "FirstName"])” does not work at all.
I tried following tutorials (https://claytoncobb.com/2009/06/21/userprofileservice-extended/ and http://eimagine.com/using-infopath-and-the-web-service-getuserprofilebyname/) but they both say to run query GetUserProfileByName when the form is open but that creates a LogID:5566 Error “Correlation ID:17a5589e-68d2-5001-355c-c68bd60879d8”. I also tried creating a button to run running the query once the form has loaded but I get the same error.
Any help would be greatly appreciated. Thanks in advance.