0

I'm new to InfoPath and SharePoint and i also use the trial version of qRules, i have 2 sharepoint lists, with one (let's call it "list1") having a lookup column to the second ("list2"), and this column permit multi-items selection. when i am using the default form i can add an item to "list1" with all the selected items in the lookup column separated with a semicolon. but when want to use a custom form, and a multi-checkbox, and i don't know how the selected items ID's must be submitted to the SharePoint list (i tried separating the items ID's with : ',' , ';' , '.' ; ' ' ...).

I want the selected items to be displayed like this in the lookup column : enter image description here

Thank's for your help.

  • are you using qRules with the SubmitToSharePointList command? – teylyn Sep 23 '14 at 22:40
  • Tried building a string that conforms to the SPFieldLookupValueCollection format using the IDs and lookup value strings? I haven't worked with InfoPath much but with managed code you can set a multi-value lookup field using a string that is specially formatted for use with this overload. So instead of setting the column value using a string containing the IDs and random delimiters, try building a string like "1;#Android;#2;#Language Java;#3;#MySql..." and setting that string as the lookup colum's value. – nsturdivant Sep 23 '14 at 23:20
  • @teylyn yes i am – THEDJA Sep 24 '14 at 20:20
  • @nsturdivant i used qRules because i'm new with C# and i don't have enough time to accomplish this project. i already tried this delimiter but i an error in the command field of qRules – THEDJA Sep 24 '14 at 20:21
  • @THEDJA, Qdabra have very good support. If the issue is related to qRules you should approach them directly on Infopathdev.com – teylyn Sep 24 '14 at 21:07
0

You might be able to use SPD workflow for this. You can make a workflow that breaks them up like that into a different column. For multiple check boxes when updating a list item in SPD, it offers it as a string or a comma separated values. Just an idea.

  • but i need them to redirect to the source list – THEDJA Sep 23 '14 at 18:34
  • Is the purpose of the second list just to hold the selected items? – lazoDev Sep 23 '14 at 18:52
  • Yes, and to show further informations on selected items, on clicking on them – THEDJA Sep 23 '14 at 18:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.