SharePoint Integration

Re: Populate a sharepoint list into respective fields in infopath form

kiranallena — Thu, 08 Oct 2009 20:11:00 GMT

Thank you very much.. Will check it.

Re: Populate a sharepoint list into respective fields in infopath form

TiltnSpill — Thu, 08 Oct 2009 19:49:21 GMT

You need to do two things.

First - Create a data connection to receive data from your SharePoint list.

Second - Create a rule in your list drop-down control to query your recently created data connection, and then set the field values (in your infopath form) according to the list-box entry.

Example - you want to set the phone number field in your infopath form to the Phone number column in your sharepoint list.

Create a rule to "set a field value". In the field box, select your phone number field. In the value box, hit the function button then select "insert field or group". Browse to your share point list and highlight your telephone number box. click on the "filter data" button. Add a filter of Vendor_Name (infopath form) equals Vendor_Name (sharepoint list).

Your field value box should look something like this.

@Phone_Number[@Vendor_Name = Vendor_Name]

Repeat this for each field you want to set in your infopath form.

If my instructions are confusing... try looking at the following article by infopathdev.... it's very similar to what you have to do.

http://www.infopathdev.com/blogs/mel_balsamo/archive/2009/03/24/active-directory-template-part.aspx

Populate a sharepoint list into respective fields in infopath form

kiranallena — Thu, 08 Oct 2009 16:44:04 GMT

Hi,

I am trying to connect a sharepoint list to an infopath form, in my case, its the vendor list. So, I have a drop down box for the vendor company name and the rest of the fields (business phone, vendor name, contact number etc) as text fields. When I make a company name selection, the rest of the fields should be automatically filled in, taking the data from their respective columns in the sharepoint list. Could somebody please help me out?

Thanks,