Infopath 2010 Multiple Selection ListBox on browser

Question

I may be missing something. I have a Multiple Selection List box in a Section. See attached pic. When I right click on the grpApplications and copy XPath it gives me /my:myFields/my:grpAccessOfficeEquipment/my:grpApplications when I right click for XPath on the fldApplicatins it gives me /my:myFields/my:grpAccessOfficeEquipment/my:grpApplications/my:fldApplications

In the code (code posted below) I am referencing the /my:myFields/my:grpAccessOfficeEquipment/my:grpApplications/my:fldApplications and I get no value. but I used /my:myFields/my:grpAccessOfficeEquipment/my:grpApplications I get a value for selected item in the listbox.

But I am still getting error NullReferenceException "object reference not set to an instance of an object" on string appName line. The AppID looks like this "\n\t\t\t262265264143\n\t\t" instead of whole number in debug. but when I click on the binocular is shows 262265264143 but with spaces/lines before and after this.

XPathNavigator MainDS = MainDataSource.CreateNavigator();
XPathNodeIterator iterApp = MainDS.Select("/my:myFields/my:grpAccessOfficeEquipment/my:grpApplications", NamespaceManager);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
while (iterApp.MoveNext())
{
    string AppID = iterApp.Current.Value;
    //int lookupID = Convert.ToInt16(value);
    XPathNavigator secAPPDS = DataSources["SupportEscalationList"].CreateNavigator();
    string appName = secAPPDS.SelectSingleNode("/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[@ID = '" + AppID + "']/@ApplicationProcess", NamespaceManager).Value;
    sb.Append(appName);
    item["ApplicationProcess"] = sb.ToString(); // because applicationprocess column in target sp list is single text type column
}

Answer 1

First, change

while (iterApp.MoveNext())

to

iterApp.MoveNext();
while (iterApp.MoveNext())

because at the beginning iterApp is positioned before the first item, i.e. at no item at all.

Then, if you change Value: in Multiple-Selection List Box Properties (Data tab) from ID to d:ApplicationProcess of field fldApplications, i.e. from your current

Fig.1. Your Current Multiple-Selection List Box Properties

to

Fig.2. Multiple-Selection List Box Properties after "Value:" changed

and change the code to

//with Multiple-Selection List Box Properties of fldApplications according to Fig.2. 

XPathNavigator MainDS = MainDataSource.CreateNavigator();  
XPathNodeIterator iterApp =  
    MainDS.Select    
     ("/my:myFields/my:grpAccessOfficeEquipment/my:grpApplications/my:fldApplications",    
          NamespaceManager);   

System.Text.StringBuilder sb = new System.Text.StringBuilder();

iterApp.MoveNext();
while (iterApp.MoveNext())
{
    string AppName = iterApp.Current.Value;

    sb.Append(appName);  
    sb.Append(";");//this should be useful for debugging
    //the next line is out of question, so I commented it out  
    //item["ApplicationProcess"] = sb.ToString(); 
}

//this inserted to check the code  
MainDS.SelectSingleNode("/my:myFields/my:TxtBox",
          NamespaceManager).SetValue(sb.ToString());

then it should work without errors.

If you still want to make it differently or it does not work, please send me your SupportEscalationList, for example as STP file (better with included conet)

Update:

So, I understood that this buggy code came from

• S.Y.M. Wong-A-Ton.
  2nd part "Retrieving the display names of selected items"
  of
  "How to programmatically retrieve selected items in a Multiple-Selection list box in InfoPath (Infopath 2007)"
  http://www.bizsupportonline.net/blog/2009/03/programmatically-retrieve-selected-items-multiple-selection-list-box-infopath

I tested it in Infopath 2010 + Sharepoint 2010 Online (Office 365)

If to return to perverted overcomplicated way of doing it, then code should run with following code (afteк removing all errors with quotes, etc.)

//with Multiple-Selection List Box Properties of fldApplications according to Fig.1. 

XPathNavigator MainDS = MainDataSource.CreateNavigator();  
XPathNodeIterator iterApp =  
    MainDS.Select  
        ("/my:myFields/my:grpAccessOfficeEquipment/my:grpApplications/my:fldApplications",    
         NamespaceManager); 

System.Text.StringBuilder sb = new System.Text.StringBuilder();

iterApp.MoveNext();
while (iterApp.MoveNext())
{
    string AppID = iterApp.Current.Value;

    XPathNavigator secAPPDS =   
            DataSources["SupportEscalationList"].CreateNavigator();
    string appName =  
         secAPPDS.SelectSingleNode
            ("/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:ID =" 
            + AppID + 
            "]/d:ApplicationProcess", NamespaceManager).Value;

    sb.Append(appName);  
    sb.Append(";");//this should be useful for debugging
    //the next line is out of question, so I commented it out  
    //item["ApplicationProcess"] = sb.ToString();   
}

//inserted this to check that code works    
MainDS.SelectSingleNode("/my:myFields/my:TxtBox",
          NamespaceManager).SetValue(sb.ToString());