x-Post: I can't access all the columns from my SharePoint list in Infopath.

msgirl — Thu, 19 Feb 2009 22:10:41 GMT

Hello,

I am running into an issue with built-in fields in MOSS.

I have created a document library in MOSS containing just pictures (no other valuable information). (Note: I have also attempted this with a Picture Library to no avail).

In my Infopath form, I have a dropdownbox.

I want to populate the dropdownbox with the names of the pictures in the library.

Here is the problem:
I am trying to make this as stream-lined as possible for the end-user. I want the end-user to simply upload a picture to the library, and then be able to select the picture in the Infopath form.

The problem is that when I make a data connection to this library, the field I am interested in (name) is not available to me. I have tried binding the dropdownlist to every other field in the list, but there is nothing meaningful other than the ID. Unfortunately, the ID (1,2,3, etc.) won't mean anything to the end-user.

I don't want the end-user to have to re-enter the name into another column in the list. I just want him/her to upload the picture, and not have to specify anything else. Through the UI of MOSS, I can see that the list is generating a Name column off of the original filename. This is ideally what I'd like to access in Infopath.

Please help!

SharePoint Integration

x-Post: I can't access all the columns from my SharePoint list in Infopath.