Cannot you use the query user profile action?
No, cannot. I dont have Enterprise version.
Hi Dave,
Yes, other forests have been configured to synch with my SP env. All users from other domains have MySites.
Hey Kapil,
I've had a similar issue in the past before when I built an InfoPath 2010 Form that was calling the UserGroup.asmx web service. I ended up using UserProfileService.asmx webservice instead due to how MySites worked on SharePoint 2010.
I think you might find this post here on MSDN here informative.
Hi Palesa Sikwane ,
Thanks for providing this link.
When I use UserProfileSerive.asmx, I get a big XML. How can I get the Preferred Name out of this XML format.
<PropertyData>
<IsPrivacyChanged>false</IsPrivacyChanged>
<IsValueChanged>false</IsValueChanged>
<Name>PreferredName</Name>
<Privacy>Public</Privacy>
<Values>
<ValueData>
<Value xsi:type="xsd:string">Joshi, Kapil</Value>
</ValueData>
</Values>
</PropertyData>
I tried some XSLT and XPATH but could not get the value. I tried this in XPATH:
/GetUserProfileByNameResponse/GetUserProfileByNameResult/PropertyData/Values/ValueData/ValueP@Name = "PreferredName"]
Cool beans,
So how about we manipulate the XML result you got to get it in the format we'd like it in?
1) Looking at your sample XML it looks like the Query XML Nintex action breaks when trying to get the value because of this portion xsi:type="xsd:string".Removing this portion makes it easier for us to do an Xpath Query using the Query XML Action.
2) The value in your inner XML for the value seems to be in the format LastName, FirstName so we might have to Put is as FirstName LastName.
So based you your sample XML result from your previous post I built the following test workflow below to potentially solve your issue:
And got the following results (values I logged in my history list:
This worked on my end. Give it a try . I feel there might be a way to simplify it, but for now this does the job. I've uploaded the Exported List Workflow i did above for you here
Let me know if it helps
Thanks a lot Palesa Sikwane .
This was extremely helpful and well explained. (my firstname is Kapil and last name is Joshi
LOL oops! Sorry about that haha!!! Glad I could help tho