SharePoint Integration

Re: InfoPath Repeating Section Auto Generate

Ashish Trivedi — Mon, 19 Nov 2012 21:33:57 GMT

Hello,

I am in exactly the same situation. I have a list with data, which I want to populate in a form with repeating table.

As the list grows, I want the the form to automatically add new entry in the repeating table. Currently it adds only the

1st entry of the list. Please help.

Re: InfoPath Repeating Section Auto Generate

ErnestoM — Thu, 11 Oct 2012 13:17:45 GMT

What about the secondary data source - does that have the correct data?

I guess I misunderstood; do you want this data to be loaded into a repeating table in the main data source?

Re: InfoPath Repeating Section Auto Generate

mathiasparks — Wed, 10 Oct 2012 19:05:20 GMT

I am able to query the incoming data connection to 'yogurt'. My problem is that the fields auto-populate with the first version of yogurt only (Number: 4 --- Type: Yogurt --- Color: blue). When I try to add new sections (as the fields are in a repeating section), it keeps returning only the very first instance of yogurt. Ideally, I'd like it to list every unique instance of yogurt automatically (without me having to click the 'add new' on the repeating section).

Re: InfoPath Repeating Section Auto Generate

ErnestoM — Wed, 10 Oct 2012 18:32:00 GMT

SharePoint 2010 allows query parameters, so you could set the query parameter for Type='yogurt', then execute the data connection, and the data fields that are returned will be prefiltered.

Can you try this?

Re: InfoPath Repeating Section Auto Generate

mathiasparks — Wed, 10 Oct 2012 18:13:40 GMT

SharePoint 2010.

Sorry I forgot to mention that earlier. Also InfoPath 2010.

Re: InfoPath Repeating Section Auto Generate

ErnestoM — Wed, 10 Oct 2012 12:36:57 GMT

Is this SharePoint 2010 or 2007?

InfoPath Repeating Section Auto Generate

mathiasparks — Tue, 09 Oct 2012 17:35:18 GMT

Hi!

I'm not an advanced InfoPath user and I'm having a problem that I'm hoping someone here can help me with.

I have an InfoPath form that has a data connection with a SharePoint list. My goal is to have a form that, upon opening, checks the list, gathers parameters, and populates/creates as many repeating sections as it needs to based on a field.

For example:

Say in my sharepoint list I have 3 columns: Number (key), Type, Color.

The example values are as follows:

Number	Type	Color
1	jello	blue
2	jello	yellow
3	pudding	blue
4	yogurt	blue
5	yogurt	pink
6	yogurt	green
7	yogurt	white

I want to create a unique InfoPath form that always looks at this list and pulls the associated values for all "yogurt" fields. Right now, my form pulls the first row of information in the list regarding yogurt (Number: 4 --- Type: yogurt --- Color: blue). However, I when I click the "new item" button for the repeating section, it just adds the exact same values (that is, the first yogurt row over and over). I would like it to move down each unique row and I want it to automatically add new sections (and populate the fields) for each unique yogurt instance.

Can this be done?

I appreciate and thank you very much before hand for your help!