Scenario (also posted in MS InfoPath Forum):
-I currently drag SharePoint user info into InfoPath 2010 (browser
forms) via a mixture of the SharePoint User Profile and QdabraAD web
services
-These forms are used to process user additions/edits/deletions for our company and are working fine
-I only use it currently to get a single user's details at any one
time (Using a people picker and then pulling details for the chosen
user) as each form deals with a single user
-I now have the requirement to pull details for multiple users into
InfoPath 2010 based on a set criteria (e.g. Group Membership) as I want
to allow a user to "mass-edit" details for all staff in a specific
group.
-I currently pull a list of the users that I want into InfoPath using
the QdabraAD web-service (using GetMembersOfGroup) but I can't pull in
the additional info from the other data source
How would I go about retrieving the extra info from the SharePoint user profiles web-service?
If it was code I know I need to iterate though the results of my
QdabraAD query and look up each returned user against the SharePoint user
profiles web-service to get additional information such as telephone
number/office etc
Is this possible with InfoPath to "join" two data sources in this way?
I also tried using nested tables/sections and rules to set fields and
query the user-profiles web-service each time but it just didn't work.
Is the only solution a custom web-service?
Any help gratefully received!