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?

1 Answer 1


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.

  • Can you please tell more about this? Or provide links? Thank you for your help
    – shasha0607
    Commented Jun 14, 2018 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
    Commented Jun 14, 2018 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? Commented Jun 14, 2018 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
    Commented Jun 15, 2018 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. Commented Jun 20, 2018 at 13:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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