How do I use an infopath 2007 multi-entry list box with sharepoint?

Posted on 2011-05-05
Last Modified: 2012-05-11

I am creating my first form (hurray) in infopath. Due to my company's sharepoint implementation, the form must be filled out in infopath and not in the browser, just as background.

I need to use a control that lists various options that user can select from, but they need to be able to select one... or none... or some... or all of the options.

Normally (in most systems) there are comboboxes that seem to allow this...but infopath apparently uses a rendition of that with checkboxes.

That's fine, I suppose, it just kills shift- and ctrl- click functionality.   But anyways - when I save my data to a sharepoint document library (as a content type)...  the field/column with multiple selections ends up blank.

Any hints on how to fix this... or what I'm doing wrong?

Question by:runelynx
    LVL 28

    Accepted Solution

    the issue is that SP is a flat data structure, it cannot display repeating elements.  so when you pick a list of three values in one field it cannot represent them.
    best practice here is to make each choice a separate field and then promote each one to your library.  it would also help sorting or filtering the data in SP as well.

    Author Comment

    Ahh, ok!

    I think in this particular case since I need to choose on friendliness in sharepoint or friendliness in infopath, I'll go with infopath and just hide this field in the doc library view

    thanks clay :)

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
    The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now