Qdabra qRules

Re: Submit Multiple Values to SP List

Hilary Stoupa — Thu, 04 Jun 2015 14:31:55 GMT

http://www.infopathdev.com/forums/p/30062/102743.aspx#102743 is the new post you created for this - just in case anyone else comes across this. :)

Re: Submit Multiple Values to SP List

klink — Mon, 01 Jun 2015 12:36:39 GMT

Anyone?

Re: Submit Multiple Values to SP List

klink — Wed, 27 May 2015 16:43:08 GMT

Glomming onto this old post because I think it is exactly what I was looking for! =) But, I am unclear of what to do when querying for the data and filling the multiselect field. ='(

What I have:

InfoPath 2010
qRules 7.1

SP List with lookup for ICP Numbers. Secondary source has:

ICP Num
:Value

I created a multi-selection list box in my form.

ObjICPNums
ObjICPNum

Currently, after query, I am setting ObjICPNum to :Value (which, of course, is wrong). It does check the correct first item, but only one item.

I obviously could use a little help...

Thanks in advance!!!!

Re: Submit Multiple Values to SP List

Hilary Stoupa — Mon, 09 Jul 2012 17:50:57 GMT

So, here's what you need to submit:

ID;#;#ID;#;#ID

That is, the list item id of the lookup item, then;#;# followed by the next id. Here's where I found the right syntax. Are you using browser forms? If so, test in preview, then publish and test in the browser - I've checked this with web services (using the U2U CAML Query Editor) but not in the browser.

So, practically, this means you'll set up your mapping to submit a different field than the one bound to your multiselect - if you are submitting a repeating group, you'd want the field to be a non-repeating child (the field bound to your multiselect will be repeating). You'll need to be using the list item IDs for the value in the multiselect. You can use the DelimitedList command to aggregate those with ;#;# as a delimiter. Does that make sense?

Re: Submit Multiple Values to SP List

Hilary Stoupa — Mon, 09 Jul 2012 17:03:21 GMT

It may just be a matter of figuring out the correct syntax and then having another field that aggregates your selctions with whatever the correct delimter is (I'm thinking it will be ID; ID; ID; etc - so the List Item ID of the lookup item, then a semi colon, then the next item, etc).

Re: Submit Multiple Values to SP List

dlgross — Mon, 09 Jul 2012 16:52:25 GMT

ok thank you, i'm wondering if i'm wasting my time trying to do something that cannot be done, if so, i'll need to come up with and alternate approach

Re: Submit Multiple Values to SP List

Hilary Stoupa — Mon, 09 Jul 2012 15:15:09 GMT

Wow - I've not tried that scenario (and I don't think it was one we tested for). I'll check it out in the next day or so and get back to you on it.

Submit Multiple Values to SP List

dlgross — Mon, 09 Jul 2012 14:18:35 GMT

How caan qRules be used to submit data from a Multiple Selection List Box to a SPList Lookup column that allows Multiple Values?

TIA
Dean