Need an urgent help with a Sharepoint site I'm trying to finish up.
I'm using Infopath 2010 forms on browser, binding to data from a SharePoint 2010 list.
Two fields are of "people" data type, without multi-value.
The major problem is our company's user database is abit messy, some users' display name are "Doe, Jane", while some are "Doe; Jane". Using the semi-colon ";" is ugly to begin with, but now I found out whenever the item data contain people who's display-name has a ";", the InfoPath form will fail to load (get Sharepoint error showing a correlation ID).
Is this known issue? Is there any hotfix or any workaround for it?
And if I enable allow multi-values for the people picker field in Sharepoint, the Infopath forms will fail for any user's name in the fields. How do we get multi-people field to work in InfoPath, if at all possible?
Any help and suggestion needed.... Thanks