InfoPath Dev

Morning,
Okay, here's the setup... we're using IP 2010 and MOSS 2007.  Our users need to be able to assign requests that come in to different people on different teams who then are notified of the assignment.  We set this up by creating a sharepoint list where people are assigned to groups/teams.  The names are grabbed by the person or group field in sharepoint so we can use the email in the active directory.

Everything works fine using filters on different dropdowns to get the correct list of names BUT an extra comma is added to the names (e.g. LastName,, FirstName).  This then causes a problem because sharepoint/active directory can't find the user's email to send the notification. 

Because we couldn't figure out what was happening to add the double comma, we created a workflow that goes to those fields on submission and finds the  double comma and replaces with a single comma.  It technically works, but the timing is causing problems due to the various times names are added.  I've been playing with how to get the timing to work, but am wondering if finding a solution to the initial double comma issue would be more adventageous.

Has anyone out there run into this issue and found a solution?  Or just have thoughts on where I could start looking to resolve the problem?  The sharepoint list shows the names with just one comma, so there's something happening when the data is pulled into IP.

Thanks!

Jen

No takers, eh?

I've not seen anything like this before. I guess first what I'd do is verify the data is what I think it is in SharePoint - I'd take a look at it in the browser. Since you are using MOSS 2007, I'd use an owssvr.dll URL - they look like this:

http://yourserver/yourweb/_vti_bin/owssvr.dll?Cmd=Display&List={guid}&XMLDATA=TRUE&noredirect=true

With "guid" replaced with your list GUID - if you go to the list settings page, that's in the URL, and you can use an online decoder (like this one) to decode it. Then you'll be able to see the actual data in the list - what's it look like?

Hi Hilary,

I found my GUID, e74ed205-13c1-45ae-8198-20890d6aef50, placed it in the URL you provided, and used that URL in my address bar.  The result was an error stating IE couldn't display the page.  Sorry, perhaps I misunderstood what I should do with the URL.

Thanks

I should have stated to replace the placeholders here as well:

http://yourserver/yourweb

with the actual URL to your SharePoint site where the list is. Did you do that?

Oh the days I wonder where my brain is...  absolutely amazing. 

Okay, I actually followed your directions (correctly this time) and looks like the data from AD does only have one comma.  A snippet of some of the data is below... I'm pulling over the ows_name information.

<z:row ows_Attachments="0" ows_LinkTitle="108MS\aking23" ows_email="45860;#[email protected]" ows_name="45860;#King, Alvin D" ows_group="1;#A&G" ows_active="1" />

Okay, so now in your form, drag the secondary data source data fields onto your form and preview it - I'd like to see a screenshot of the data with the extra comma.....

I'm having this happen. Here's a screenshot. I'm using a People column in SharePoint for presence, then pulling it into a dropdown list via a data connection and displaying the "DisplayName" field.

Has this ever been resolved?  I to am experiencing the same issue with the same view of the drop down already provided.

Actually, this issue was only present in an Infopath client form. Once I published it to SharePoint (web-enabled) the double commas disappeared. This was an acceptable solution for me as it was meant to be a web-enabled form.

Thanks for the tip! I was having this same issue when previewing the form in InfoPath. As soon as a I published it to SharePoint everything worked fine.