InfoPath Dev

Hİ ,

How I get the User Organization value in Infopath 2010 witout coding ?

Thanks.

Or how i get the company from userprofile or AD ?

volkandal:

Or how i get the company from userprofile or AD ?

In my sharepoint online (Office 365) site, I do not see how I can get, set or view a company or organization in a sharepoint user profile.

The most close to question properties which I can get from (set in) user profile are:

•  WorkPhone
• Department
• Manager
• WorkEmail
• CellPhone
• Fax
• HomePhone
• Office
  
• SPS-Location
  

In setting a user profile I do not see how to set Office but if I set Office Location: field there, its value is appearing in SPS-Location 

The full list of properites of UserProfileService.asmx web service which I could get:  

 UserProfile_GUID
AccountName
FirstName
SPS-PhoneticFirstName
LastName
SPS-PhoneticLastName
PreferredName
SPS-PhoneticDisplayName
WorkPhone
Department
Title
SPS-JobTitle
Manager
AboutMe
PersonalSpace
PictureURL
UserName
QuickLinks
WebSite
PublicSiteRedirect
SPS-Dotted-line
SPS-Peers
SPS-Responsibility
SPS-SipAddress
SPS-MySiteUpgrade
SPS-DontSuggestList
SPS-ProxyAddresses
SPS-HireDate
SPS-DisplayOrder
SPS-ClaimID
SPS-ClaimProviderID
SPS-LastColleagueAdded
SPS-LastColleagueAdded
SPS-OWAUrl
SPS-SavedAccountName
SPS-ResourceAccountName
SPS-ObjectExists
SPS-MasterAccountName
SPS-DistinguishedName
SPS-SourceObjectDN
SPS-LastKeywordAdded
WorkEmail
CellPhone
Fax
HomePhone
Office
SPS-Location
SPS-TimeZone
Assistant
SPS-PastProjects
SPS-Skills
SPS-School
SPS-Birthday
SPS-StatusNotes
SPS-Interests
SPS-EmailOptin

 So, suppose, having set "Office location:" in Sharepoint user profile:

I want to get it into textbox value in Infopath form

 So, I create a Infopath form template in Infopath Designer 2010 and insert into a text box.

For the sake of this topic, I want to avoid to deepen into publishing, I am going to view results in Preview, so I set Full Trust 

 On ribbon, under Data tab, I launch Data Connection wizard and create receive data from SOAP Web Service <your_sharepoint_subsite_URL>/_vti_bin/UserProfileService.asmx selecting operation GetUserProfileByName and clicking Next to accept all other choices

 In textbox properties (Alt+Enter), click fx against Value:> Insert Field or Group: > GetUserProfileByName (Secondary) > select Value field

Press Filter Data... button > Add

In left combobox navigate click Select a Field or Group... and choose Name field from GetUserProfileByName (Secondary) data source 

In right listbox  choose  Type text... > type SPS-Location > press OK few times to close all dialog windows

That's it, on clicking F5 (Preview), it should work