Using Sharepoint List as Data Connection

[Vince]

I am designing an InfoPath form that will pull daily information from
mulitple SharePoint lists and email the form to users.
I have created a data connection to a SharePoint list and am able to pull
back certain fields. However I really want to pull back a complete row from
the SharePoint list rather than just a particular field.

The list in question has the following fields in each row:

Date Status Language JobID Description Comment

The data in each row needs to be kept together so therefore if I am pulling
back data from the first row I need all corresponding fields in the same row
to be kept together.

If you think of 'Export to Excel' I would be looking for something like
'Import from Excel'.

Clear as mud??

Any ideas would be greatly appreciated.

Cheers,
Vince

 

[Scott L. Heim [MSFT]]

Hi Vince,

When you setup your secondary data connection to Sharepoint you should have
been able to select the specific columns you need - is this not the case?

Assuming it is, you should then be able to use a "Repeating Table" to
display the data as you need from the Sharepoint connection. Try this:

- Open your InfoPath solution in Design View
- Display the "Data Source" Task Pane
- From the "Data Source" drop-down box, select your Sharepoint connection
- Expand the folders until you get to the name of your list
- Drag that to your InfoPath form and when you release it you should be
prompted to select the type of control - choose Repeating Table

Will this work for you?

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Vince]

Thanks Scott...

That worked perfectly!

 

[Aji]

Similar to Vince I am using IP2003 and data connection with a Sharepoint
list, but I can't get an entire record to load from a drop-down list. I may
not be explaining this correctly.

My sharepoint list has:
Name Address email Status

In the IP form I want to connect the field "Name" to a dropdown list. The
other field from the list will be visible in the form but can't be modified.
When I select a name from the list, I would like the remaining field from
list to populate. This can be automatically or via a refresh button click.

Is this type of functionality with a data connection sharepoint list
possible? If not, is there another way to make this work as described.

Thanks - Aji