Web Services

Re: Having Trouble Getting FirstName and LastName in a text field

Sandy_Wood — Fri, 02 Aug 2013 15:12:52 GMT

I believe I found my problem. I needed to follow some steps exactly when creating my formula. I was successful when adding all the text and fields at creation time. Previously I added the FirstName and LastName fields and then would edit the formula adding 'concat', and all the parentheses, commas, etc. This never worked for me. Adding all the commands and fields at the same time worked.

Re: Having Trouble Getting FirstName and LastName in a text field

Sandy_Wood — Fri, 02 Aug 2013 14:26:27 GMT

Hello Patrick,

Thanks for the note back on my post. I have been using GetUserProfileByName in my form. My issue seems to be with getting the formula right. In Clayton's blog, figure 15, I've been using that formula but it's giving me errors when I check the formula. I'm sure it's something I'm typing or not typing. Let me bang away at it some more.

Re: Having Trouble Getting FirstName and LastName in a text field

Patrick Halstead — Fri, 02 Aug 2013 06:58:09 GMT

Hi Sandy,

If you use SharePoint 2010's http://site/_vti_bin/userprofileservice.asmx and specify the GetUserProfileByName it will return FirstName and LastName.

More info: http://claytoncobb.wordpress.com/2009/06/21/userprofileservice-extended/

Cheers!

Having Trouble Getting FirstName and LastName in a text field

Sandy_Wood — Thu, 01 Aug 2013 22:41:57 GMT

I'm trying to pull username information from the SharePoint User Profile Web service. I can connect to the web service and get the information but the formula is not behaving. I've come up with

"concat(Value[Name = "FirstName"], Value[Name = "LastName"],)"

It gives me this error:

Expected value type: end-of-string

Actual value: name
"concat(xdXDocument:GetDOM("-->GetUserProfileByName<--")/dfs:myFields/dfs:dataFields/tns:GetUserProfileByNameResponse/tns:GetUserProfileByNameResult/tns:PropertyData/tns:Values/tns:ValueData/tns:Value[../../../tns:Name = "FirstName"], xdXDocument:GetDOM("GetUserProfileByName")/dfs:myFields/dfs:dataFields/tns:GetUserProfileByNameResponse/tns:GetUserProfileByNameResult/tns:PropertyData/tns:Values/tns:ValueData/tns:Value[../../../tns:Name = "LastName"],)"

Are both FirstName and LastName in GetUserProfile?