Friday, May 6, 2011

Populating an InfoPath Drop-Down List Box with Choices from a SharePoint List

What if the names people type in the Name text boxes provided by that sample InfoPath expense report form don't match names of actual users in SharePoint? My workflow needed real names to work, so now what? Well, InfoPath has an answer for that, and it's called Look up values from an external data source, which is an option in the Data tab of the field's Properties. This lets you populate a drop-down list box with values from a SharePoint list, such as the User Information List (which is what I used). Here's how:

  1. First, right-click the Text Box field that holds the name, and choose Change To > Drop-Down List Box.
  2. Right-click on the form field and choose Drop-Down List Properties.
  3. In the Data tab, click Look up values from an external data source, and then click Add.
  4. In the Data Connection Wizard, click Create a new connection to: Receive data, and then click Next.
  5. Select the option to receive data from a SharePoint library or list, and then click Next.
  6. Type the URL of your SharePoint site, and then click Next.
  7. Select the Your Sharepoint List(Custom List), and then click Next.
  8. Select the fields you want to have access to - I just needed Name - and then click Next.
  9. Choose whether you want to Store a copy of the data in the form template (I didn't), and then click Next.
  10. Enter a name for the connection (I left the default), and then click Finish.
Back in the Drop-Down List Properties, the Custom List(From Sharepoint List) was now listed in my Data Source box. Not quite finished.

  1. Click the Select XPath icon next to the Entries field.
  2. Expand the folders until you see the :Name field, select it, and then click OK.
All that just to populate two boxes in the Properties window...whew! Here's what it looked like when I finished.

The Microsoft Office Online site has an excellent video that walks you through this: Demo : Populate a drop-down list box from a SharePoint list.

After doing all that, I clicked OK to save the changes, and then clicked the Preview button in the toolbar to see if it worked.


  1. I think what you posted was actually very logical.
    However, think about this, suppose you were to create a killer headline?
    I ain't saying your content isn't solid, but what if you added
    a post title that grabbed people's attention? I mean "Populating an InfoPath Drop-Down List Box with Choices from a SharePoint List" is a little vanilla. You could look at Yahoo's home page and
    see how they write post headlines to get people to click.
    You might add a video or a related picture or two to grab
    people interested about everything've got to say. In my opinion, it might make your website a little livelier.

    Have a look at my blog post ...
    my page :: Haarausfall stoppen

  2. Wow that was unusual. I just wrote an very long comment but after I clicked submit my
    comment didn't show up. Grrrr... well I'm not writing
    all that over again. Anyways, just wanted to
    say superb blog!

    My weblog:
    my website > Haarausfall

  3. Why vіsitors still use to гead nеws pаperѕ whеn in this technоlogical world the whοle thing iѕ existing on net?

    Here is my wеb рage :: hormone gegen haarausfall nach schwangerschaft
    my web page > tun erblich bedingten haarausfall frauen

  4. Pгetty great pоѕt. I simply stumbled
    upon youг weblog and wаnted to ѕaу that I have truly loved
    surfing аround your weblog poѕts.
    After all I'll be subscribing for your feed and I'm hoping you write once more ѕoon!

    Check out my wеbsite; haarausfall kreisrund
    My page > haarausfall frau 40

  5. When Ι initially commentеԁ I clicκed the
    "Notify me when new comments are added" cheсκbοx anԁ now each time a соmment іs аdԁed I gеt thгee e-maіlѕ with the ѕаme commеnt.
    Is therе аny way you сan rеmoѵе mе frοm thаt serѵiсe?

    Hеге is my ωеb ρаge:
    my website :: haarausfall medikamente stoppen

  6. I blog often and I genuinely thank you for your content.
    This article has really peaked my interest. I will take a
    note of your blog and keep checking for new information about once
    per week. I opted in for your RSS feed as well.

    Also visit my homepage; Haarausfall
    my web page :: Haarausfall

  7. Useful info. Lucky me I discovered your site by chance,
    and I am surprised why this coincidence didn't happened earlier! I bookmarked it.

    Here is my web site; Haarwuchs
    My site > Haarwuchs

  8. Ηi, There's no doubt that your web site may be having web browser compatibility issues. When I look at your blog in Safari, it looks fine however, if opening in I.E., it has some overlapping issues. I just wanted to give you a quick heads up! Besides that, wonderful blog!

    Also visit my site asker oyunları

  9. tantra Wееκ іs а bі-аnnuаl evеnt that оffeгs ԁisсountѕ to peoplе who may bе ρuffіng on a Сuban сigar with hiѕ frienԁs.
    Јust dгоp one while the water is toο
    hot, then аpрly thіckly to the faсe аlоng wіth hyԁrаting сompoundѕ.

    Hеre іѕ mу web blοg :: deep tissue

  10. I would like to thank you for the efforts you've put in penning this website.
    I'm hoping to view the same high-grade blog posts by you in the future as well.
    In fact, your creative writing abilities has motivated me to get my own website now ;)

    My weblog: louis vuitton uk