[Server name]/_vti_bin/userprofileservice.asmx?WSDL

while [server name] is your SharePoint host server

SharePoint – Smackwagon Design

4. after doing its connection to the web service, you will see a dozen of web service in a  list like below, choose (GetUserProfileByName) and click next

SharePoint – Smackwagon Design

5. go to your textbox and double click its field property in the ‘Default Value’ part, click the ‘fx’ button next to the ‘Value’ field. this opens up the formula builder dialog like below and click insert field or group button, from the Fileds drop down list select our data connection

SharePoint – Smackwagon Design


6. Expand all groups under the ‘dataFields’ group, and choose the ‘value’ field. Don’t click OK yet! just click filter data and then click add..

SharePoint – Smackwagon Design


7. In the first drop down (value) select ‘Select a field or group…’ and choose the ‘Name’ field under the ‘PropertyData’ group.

SharePoint – Smackwagon Design


8. Leave the middle drop down as is (‘is equal to’) and in the last drop down choose ‘type a text…’. and type carefully (FirstName) it’s case sensitive, i’ll bring a list of properites which you can use to retrieve user data at the end of this topic.

9. finally your formula will look like that ;

SharePoint – Smackwagon Design


10. Now test your form by publishing it to SharePoint form list or even by previewing it you will retrieve your current user first name, but be sure that in user profile service this user have a first name property .

Here you are the list of properties:

  • AboutMe
  • AccountName
  • Assistant
  • CellPhone
  • Department
  • Fax
  • FirstName
  • HomePhone
  • LastName
  • Manager
  • Office
  • PersonalSpace
  • PictureURL
  • PreferredName
  • PublicSiteRedirect
  • QuickLinks
  • SPS-Birthday
  • SPS-DontSuggestList
  • SPS-Dotted-line
  • SPS-HireDate
  • SPS-Interests
  • SPS-LastColleagueAdded
  • SPS-MasterAccountName
  • SPS-MySiteUpgrade
  • SPS-OWAUrl
  • SPS-PastProjects
  • SPS-Peers
  • SPS-ProxyAddresses
  • SPS-ResourceAccountName
  • SPS-Responsibility
  • SPS-School
  • SPS-SipAddress
  • SPS-Skills
  • Title
  • UserName
  • UserProfile_GUID
  • WebSite
  • WorkEmail
  • WorkPhone

Some important notes that you may face during this scenario:

  • This scenario is applicable with both SharePoint 2007 and 2010
  • a common error you may face while publishing to SharePoint and try to insert new form this error is:

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.
Log ID:5566
the solution to this error is headache a bit,for a good diagnostic try the below solutions one by one:

  1. Made sure all the data connection files have the environment specific List GUIDs, URLs and so on
  2. Made sure all the settings related to InfoPath Forms Services under Central Admin are proper: Enable web service proxy, Enable cross-data connections, Disable Anonymous access
  3.  Made sure all the relevant user profiles are properly imported under SSP
  4.  Made sure that the authentication Loopbackcheck registry entry is disabled on the WFE server

you will do so by the following steps:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey:






3. Right-click Lsa, point to New, and then click DWORD Value
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Exit Registry Editor.
8. Restart the computer.
9. Made sure the alternate access mappings or managed paths are not breaking the web service calls in the interim.

After trying all the above solutions your application will retrieve the web service data.

By |2016-11-02T17:15:31+00:00June 21st, 2012|Our 2 Cents, Our Blog, SharePoint 2010, SmackTalk|0 Comments

Share This Story, Choose Your Platform!

About the Author:

Leave A Comment

You must be logged in to post a comment.

Toggle Sliding Bar Area

Did You Know….

GWEN-GARCIA-LEETS-IMAGEN-OFICIAL-SWN..Gwen Is the official spokeswoman of Smackwagon Design! GWEN Garcia Leets, is also sponsored by other internationally renowned companies. GWEN Currently is a host on an entertaining television program in Mexico called Marathon TeleHit

Interested in learning more about this beauty ? Click here to view GWEN's website to & keep you always informed of her most recent projects and events


Sharing is Awesome, Do It!

Share Smackwagon's web design company with your friends