Submit Multiple Values to SP List - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Submit Multiple Values to SP List

Last post 06-04-2015 07:31 AM by Hilary Stoupa. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next
  • 07-09-2012 07:18 AM

    Submit Multiple Values to SP List

    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

    Dean
    Charlotte, NC
    Filed under:
  • 07-09-2012 08:15 AM In reply to

    Re: Submit Multiple Values to SP List

    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.

    Hilary Stoupa

  • 07-09-2012 09:52 AM In reply to

    Re: Submit Multiple Values to SP List

    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

    Dean
    Charlotte, NC
  • 07-09-2012 10:03 AM In reply to

    Re: Submit Multiple Values to SP List

    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).

    Hilary Stoupa

  • 07-09-2012 10:50 AM In reply to

    Re: Submit Multiple Values to SP List

    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?

    Hilary Stoupa

  • 05-27-2015 09:43 AM In reply to

    • klink
    • Top 100 Contributor
    • Joined on 09-15-2014
    • Posts 99

    Re: Submit Multiple Values to SP List

    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!!!!

  • 06-01-2015 05:36 AM In reply to

    • klink
    • Top 100 Contributor
    • Joined on 09-15-2014
    • Posts 99

    Re: Submit Multiple Values to SP List

    Anyone?
  • 06-04-2015 07:31 AM In reply to

    Re: Submit Multiple Values to SP List

    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. :) 

    Hilary Stoupa

Page 1 of 1 (8 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.