I have a InfoPath form which has a lookup and allows user to select multiple options from the lookup. After selection, the values are getting stored in a single field of my SharePoint list, separated by semicolon. I want them to be stored as different fields. Is there a solution possible?


In your InfoPath form you would have to create separate fields and then use function to populate them with the selection from the lookup and then promote those fields to SharePoint list.

|improve this answer|||||
  • Can you please tell more about this? Or provide links? Thank you for your help – shasha0607 Jun 14 '18 at 10:26
  • The user can select as many options from the list as he wants. So I cannot create many fields in the InfoPath form at once. – shasha0607 Jun 14 '18 at 10:33
  • you wrote 'I want them to be stored as different fields' so you will have to create as many fields equal to how many options users can select, or have I misunderstood? – Marek Sarad Jun 14 '18 at 12:44
  • My doubt is that, if a user selects only 5 out of, say, 10 options, then 10 fields will be created in the SharePoint list right? – shasha0607 Jun 15 '18 at 5:23
  • well your requirement is "I want them to be stored as different fields" so yes if you have 10 options you will need 10 fields. – Marek Sarad Jun 20 '18 at 13:23

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.