InfoPath Dev

Jimmy,

How did you filter the data for the Display name calculated value field?  I can get the ListItem[ Value = field1] part entered, but I can seem to figure out how to got /Display as part of the formula.

I set up my fields such that ListItem is DS_Choice_ListItems, Value is field67, and Display is field68.  field1 is DataSources choice group.

eval(eval(ListItem[Value = field1]/Display, 'concat(., "; ")'), "..")

Hello supermanKelz,

    Could you attach a screenshot of the relevant data source(s) involved in this formula, and paste the entire actual formula you've been trying (with the Edit XPath box checked), and explain what the specific issue you're encountering is (error message, etc.)?

HI Jimmy , This XPATH Rules dont work when we used List Form Template ? Thanks in advance

Hi InfoPathBeginner,

  I do not have a lot experience with list forms, but I believe it should work even with them. Have you been experiencing an issue trying to get it to work?

Hi,

I am attempting to do pretty much the same action as described the original post but I can't get it to work correctly. I have tried using the sample template but have been unsuccessful.

I have a Multiple-Selection List Box called SelectedPartnerAgencies and I want the selected agencies to be added to the value of a text box (called PartnerAgenciesTextBox). The MSLB is populated from a secondary data source and is set to only show filtered items based on a different field. I have created a rule on the MSLB with the following expression:

substring(eval(eval(SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

XPath: substring(xdMath:Eval(xdMath:Eval(../my:SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

I have the following rule as the default value of the text box (identical to above):

substring(eval(eval(SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

XPath: substring(xdMath:Eval(xdMath:Eval(../my:group3/my:SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

The text box is set to refresh value after formula is recalculated.

The text box is only populated after I have selected mulitple items then unselect an item - i.e. it rarely shows an accurate reflection of what is selected in the MSLB.

I'm using InfoPath 2010 (Filler) form. The form is saved to a SharePoint 2010 library.

Any help would be much appreciated.

Thanks, Ben.

It sounds like the rule isn't working. Where did you place the rule exactly? Is it on the MSLB's group, or on the repeating field? It should be placed on the repeating field.

In your XPath's, you have to refer to the current field as it's full name, not " . " Replace with: substring(xdMath:Eval(xdMath:Eval(my:myFields/my:SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

bhben:

Hi,

I am attempting to do pretty much the same action as described the original post but I can't get it to work correctly. I have tried using the sample template but have been unsuccessful.

I have a Multiple-Selection List Box called SelectedPartnerAgencies and I want the selected agencies to be added to the value of a text box (called PartnerAgenciesTextBox). The MSLB is populated from a secondary data source and is set to only show filtered items based on a different field. I have created a rule on the MSLB with the following expression:

substring(eval(eval(SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

XPath: substring(xdMath:Eval(xdMath:Eval(../my:SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

I have the following rule as the default value of the text box (identical to above):

substring(eval(eval(SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

XPath: substring(xdMath:Eval(xdMath:Eval(../my:group3/my:SelectedPartnerAgencies[. != ""], 'concat(";", .)'), ".."), 2)

The text box is set to refresh value after formula is recalculated.

The text box is only populated after I have selected mulitple items then unselect an item - i.e. it rarely shows an accurate reflection of what is selected in the MSLB.

I'm using InfoPath 2010 (Filler) form. The form is saved to a SharePoint 2010 library.

Any help would be much appreciated.

Thanks, Ben.

Unfortunately that hasn't worked, I get the following error message:

"my:myFields/my:SelectedPartnerAgencies" does not point to a valid location path of a field or group.

I've never directly edited XPath before so apologies if its something really obvious that i'm missing here.

In response to previous post my rule is on the field part fo the control, not the group. The group is called group3. Do i need to reference 'group3' in the XPath? I did experiment trying to do this but still couldn't get it to work. I tried using your formula on the MSLB rule and the text box's default value, but neither worked.

 Thanks for your help.

Hi, I've used Jimmy's sample on Page 1 for the solution I'm looking for, however I'm hitting a different issue. The MSLB data source comes from an external source, if that makes a difference.

The selected values are adding and removing from the text box just fine, however I get a ";" appear before any selections are made, and then my selections are not being separated by a ";" when more than one selection is made so the values are appearing in one long unseparated string in the text box.

Just to confirm, this is the code I'm using in both the rule and the default value.

substring(xdMath:Eval(xdMath:Eval(../../my:group1[. != ""], 'concat(";", .)'), ".."), 2) 

 Any help with this is much appreciated!

 Is group1 the field that the MSLB is bound to, or is it a group higher up in the data source?

Hi,

group1 is from an external datasource, there's a :Value underneath it. but when I change the xpath to ../my:group1/value or ../my:group1/my:value then I get an error saying it's not a valid path.

I thought VALUE was just the value of the selection as opposed to the displayname...if this makes sense!

Never fear, seems to be working now. Think it must have been case sensitive and perhaps I was using lower case v on Value. It now works perfectly on my list form. Thanks for the resource.

 I'm trying to get this example to work in my form but am having issues.  I have a MSLB with a secondary data source connection and want to show the selected display names in another field.  This is the xpath I've come up with so far:

xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("CORE Telephone Directory")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Email = /my:myFields/my:AddAttendeeGroup/my:AddAttendees]/d:Email, 'concat(., "; ")'), "..")

 InfoPath shows no errors when verifying the formula, but when I test it out in preview the field remains blank

 Can anyone assist me with this? 

 I am attaching an example, it shows several ways to accomplish what you are trying to do. save the xsn and look it over. preview it and you can see how it works

Thanks Larry for your response.   I was finally able to figure out what the xpath should look like with a secondary data connection.

 xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("CORE Telephone Directory")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Email = xdXDocument:get-DOM()/my:myFields/my:AddAttendeeGroup/my:AddAttendees]/d:Full_x0020_Name, 'concat(., "; ")'), "..")