Newbie Questions

Re: Multiple Selection Listbox - Get Index number?

Hilary Stoupa — Thu, 12 May 2016 22:27:28 GMT

Your "Value" node didn't have a namespace prefix. My "field2" node did - the "my:" prefix. That's why I asked for your exact XPath - so the XPath to the preceding sibling was correct.

Re: Multiple Selection Listbox - Get Index number?

ljuliusson — Thu, 12 May 2016 22:20:19 GMT

Yahooo!! That worked! Thank you SOOO much!! Wow, so I'm trying to understand what made the difference. I realize I forgot the incrementer "+ 1" in my original try, but don't quite understand why your original formula didn't work. It looks like the only difference was not having the "my:" before the second value. Can you explain, or is this just a case of very sensitive formatting rules. Lara

Re: Multiple Selection Listbox - Get Index number?

Hilary Stoupa — Thu, 12 May 2016 21:57:16 GMT

This works for me (pick the initial "Value" with the field picker): eval(eval(Value[. != ""], 'concat(., count(preceding-sibling::Value[. != ""]) + 1, ", ")'), "..")

Re: Multiple Selection Listbox - Get Index number?

ljuliusson — Thu, 12 May 2016 19:54:33 GMT

Here it is: /dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:group1/Value

Re: Multiple Selection Listbox - Get Index number?

Hilary Stoupa — Thu, 12 May 2016 18:38:37 GMT

Can you copy the XPath for the "Value" field? Set the Fields pane to advanced view, right click on the Value node and select "Copy XPath"?

Re: Multiple Selection Listbox - Get Index number?

ljuliusson — Thu, 12 May 2016 18:32:10 GMT

I should also say that all of these (myFields > dataFields > my:SharePointListItem_RW > Field Office > Value) except for my:SharePointListItem_RW are locked. Not sure if that matters.

Re: Multiple Selection Listbox - Get Index number?

ljuliusson — Thu, 12 May 2016 18:00:54 GMT

Hi Hilary, That works great in the form you sent, but when I try to implement it on my form, it doesn't work, and I get "The formula contains one or more errors". I've tried it as a rule on the Field Office control, and as a default value in my receiving text box field. Is there a specific reason why you put it on a button? Also, in my Fields, I have several layers starting with: myFields > dataFields > my:SharePointListItem_RW > Field Office > Value. Is there a problem hidden in there somewhere, do you think? I'm rather new to this, but think I'm really close, since the other two formulas (double eval and count) work independently. I wish I could upload my form to you, but I'm not able to. Thanks again for your time! Lara

Re: Multiple Selection Listbox - Get Index number?

Hilary Stoupa — Thu, 12 May 2016 15:12:41 GMT

See attached - there is a rule on a button that sets another field that I think does what you want.

Re: Multiple Selection Listbox - Get Index number?

ljuliusson — Thu, 12 May 2016 14:19:16 GMT

Hi Hilary, thanks for getting back. I want to build a string that has all of the selected field offices delimited by a running count, so something like this: Colorado Field Office1Kansas Field Office2Nebraska Field Office3. My Multiple-selection list box is named "Field Office", in the Advanced view of my fields it looks like a folder, with "Value" MSLB inside of it. This works to build a comma delimited list: eval(eval(Value, 'concat(., ", ")'), "..") and this works to provide me with a final count: count(Value[. != ""]) so I thought I could put the two together to get what I want, like this: eval(eval(Value, 'concat(., count(Value[. != ""]))'), "..") However, I get a message that the formula has errors. Lara

Re: Multiple Selection Listbox - Get Index number?

Hilary Stoupa — Thu, 12 May 2016 00:03:18 GMT

I'm confused! So - is the count the total of selected field offices? It isn't like this multiselect is inside a repeating section or something, right? The count is just a ... running count?

Re: Multiple Selection Listbox - Get Index number?

ljuliusson — Wed, 11 May 2016 23:41:44 GMT

Hi Hilary, I am wondering if you can help me. I've seen you giving great answers to a number of people on here. I'm using InfoPath 2010 and posting to a SharePoint list. I've tried following this thread, but am not able to get the formulas to work. Also, I don't need the HTML formatting that Nino needed. What I want is the selected Field Offices from a multiple-selection list box, to be concatenated together with index numbers between them, so that I can easily pull them out into separate fields, so that I can do something with them in a SharePoint Designer workflow later on. Basically I want something like this: Colorado Field Office1Kansas Field Office2Nebraska Field Office3 I am able to successfully run a double eval on my Field Office values and put commas between the values using: eval(eval(Value, 'concat(., ", ")'), "..") I am also able to successfully count the number of field offices selected using: count(Value[. != ""]) But when I try to put these together in the way that seems to make sense: eval(eval(Value, 'concat(., count(Value[. != ""]))'), "..") I get a message that I have errors in my formula. I've tried this many ways, and can't get it to work. eval(eval(Value, 'concat(., "count(Value[. != ""])")'), "..") eval(eval(Value, 'concat(Value, count(Value[. != ""]))'), "..") and everything else I can think of. Any thoughts? Many thanks for any help. Lara

Re: Multiple Selection Listbox - Get Index number?

neeenz — Wed, 24 Jun 2015 19:08:23 GMT

Worked like a charm! This gave me more understanding with the referencing part, I kind of had an idea that the grouping and variable location is a factor just not sure how to use the correct syntax for it. Thank you so much AGAIN Hilary :D

Re: Multiple Selection Listbox - Get Index number?

Hilary Stoupa — Wed, 24 Jun 2015 18:54:03 GMT

I think that you may be counting the number of preceding sibling nodes inside the repeating group? I'm not sure.

Is the field with the default formula inside the repeating group? You may want to use something like count(../preceding-sibling::my:RepeatingGroup) with "my:RepeatingGroup" replaced with your actual repeating group XPath.

Re: Multiple Selection Listbox - Get Index number?

neeenz — Wed, 24 Jun 2015 14:54:22 GMT

Hi Hilary,

Ran into a weird scenario:

I have a repeating table, I keep track of the number of items through an integer where it has the formula: count(preceding-sibling::*) + 1, this formula works for keeping track of the number of items. BUT it starts on 4. Any ideas why it's starting at 4? On other instance counter I have, count(preceding-sibling::*/<counter variable>) + 1 works.

** To remedy the above, i just added a -3 to my counters when being used to add tags to the repeating items, i know it's not a good remedy but just want to get an idea what's causing the 4 default number.

Re: Multiple Selection Listbox - Get Index number?

neeenz — Tue, 23 Jun 2015 22:19:18 GMT

Hi Hilary,

That worked! Thanks a lot! I kind of have a basic understanding how the reference works now, thanks to you! :) Thank you so much Hilary!