We have created a form which contains 4 different multiple people picker controls (example: Assigned, Backup, OriginatingContact and ShippingContact.) When we promote the AccountIds of these controls to the associated SharePoint list, the AccountIds have the same name (ie, AccountId.) We are then trying to use these AccountIds to populate associated Sharepoint created people fields with presence using workflows. There are 4 workflows - 1 for each AccountId.
Issues:
- In the Sharepoint list there are 4 fields all named AccountId and there is no easy way to differentiate. In Sharepoint, is there a way in Sharepoint to tell which AccountId is associated with which Infopath people picker?
- Each workflow reads an AccountId and then popluates the associated Sharepoint people field. This seems to work but when the user updates a picker selection using the form or creates a new record using the form - it appears that the form wants to populate a different account id at random.
Example:
User selects joesmith on the InfoPath form from people picker control Backup and submits.
Sharepoint BackupWorkflow copies Accountid1 value joesmith to sharepoint field BackupId. (all looks good at this point)
User goes in an changes the Backup selection to fredsmith.
BackupWorkflow copies nothing to sharepoint field BackupId
BUT now ShipWorkflow populates ShipContactId using the AccountId1 value.
Alternatively,
User creates another record using form and populates the Backup ffield with the value henryjames.
BackupWorkflow copies nothing to sharepoint field BackupId
BUT ContactWorkflow populates ShipContactId using the AccountId1 value henryjames
It seems like the workflows are confused by the AccountIds since they all have the same name AND it appears that the order in which the user enters the people picker names in Infopath determines which AccountId is being used. I say "appear" and "seem" because it is look random to use.
Since we see InfoPath forms using multiple people picker controls with Sharepoint all the time, there is probably a simple answer and we are just not understanding something critical. Any and all help is appreicated!
(Note: also posting on http://social.technet.microsoft.com/Forums/en-US/newthread?forum=sharepoint2010customization)