Web Services

Re: How to get values from sharepoint User Profile in Infopath

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 30 Aug 2012 08:35:36 GMT

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

Re: How to get values from sharepoint User Profile in Infopath

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 30 Aug 2012 08:19:31 GMT

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

Re: How to get values from sharepoint User Profile in Infopath

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 30 Aug 2012 08:06:19 GMT

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

How to get values from sharepoint User Profile in Infopath

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 30 Aug 2012 07:41:51 GMT

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

Re: How to get User Organization

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 30 Aug 2012 07:35:42 GMT

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

I want to get it into textbox value in Infopath form

Re: How to get User Organization

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 30 Aug 2012 06:38:21 GMT

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

Re: How to get User Organization

volkandal — Fri, 22 Jun 2012 08:50:16 GMT

Or how i get the company from userprofile or AD ?

How to get User Organization

volkandal — Fri, 22 Jun 2012 07:50:36 GMT

Hİ ,

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

Thanks.