General

Re: Adding rows from list to repeating table

Manju — Mon, 20 Apr 2015 03:22:30 GMT

Hi Hilary, How to do the same thing in sharepoint list template. Is it possible to do in sharepoint list. If so can u attach the template. Waiting for ur reply. Thanks & regards, Manju

Re: Adding rows from list to repeating table

GuyBoswell — Wed, 15 Apr 2015 08:05:13 GMT

We are using cloud solution for SharePoint and have no ability to load code :-(

Re: Adding rows from list to repeating table

Hilary Stoupa — Thu, 09 Apr 2015 14:07:11 GMT

InfoPath freaks all of us out sometimes. :)

So - I've seen this bug before, generally if the schema changes. I check my formulas that are like this and have "current()" in them when I add a field to the main data source....

Re: Adding rows from list to repeating table

GuyBoswell — Thu, 09 Apr 2015 10:40:21 GMT

Thank you so much for all your help Hilary. I'll have to work through the code solution another time.

InfoPath freaks me out sometimes. The filter [count(current()/../preceding-sibling::my:group2) + 1] keeps changing to [count(/../preceding-sibling::my:group2) + 1] when I do something completely unrelated. Fields that don't appear on the repeating table or even on the same view seem to be able to influence the function. Totally bizarre! It took me hours to figure out what was happening. I know now to just rebuild that function as the last thing I do before I publish the form each time but it is a right pain.

Re: Adding rows from list to repeating table

Hilary Stoupa — Wed, 08 Apr 2015 14:26:13 GMT

So - I added rows to my sample and then changed the data connection to include more items and was able to reproduce something similar. So yes, it appears that InfoPath forms services is pickier about this than the filler - sorry this isn't going to work for you in your browser form!

If you decide to use code (or you can use qRules) here is some info on admin approving a template:https://support.office.com/en-za/article/Introduction-to-browser-compatible-form-templates-7a6e40ff-eb1d-4311-945d-169857d340af?ui=en-US&rs=en-ZA&ad=ZA&fromAR=1

Here is some info on sandboxing: https://msdn.microsoft.com/en-us/library/office/ee526360.aspx

Re: Adding rows from list to repeating table

GuyBoswell — Wed, 08 Apr 2015 12:12:09 GMT

InfoPath limits how many values can be updated without manual intervention to less than 16.

The default value Hilary provided is one value. Each time it causes a row to be added it updates one value. So it gets to 15 rows OK and then stops. It is quite happy to let the user keep adding more rows one at a time, the calculation still works correctly each time. But because there is a manual intervention to add a row the count of operations sets back to zero.

I was hitting the error before I got to 15 because I had another field on the row that calculated the total of the row. So adding one row caused two values to update. So the 16 limit was hit if I added eight rows.

So now I understand the problem, And I can increase the limit to 15 by stopping the total calculating automatically, instead setting it to calculate only when a value on the row changes.

But 15 is still the maximum number of rows I can add automatically.

Unless anyone knows a way to change that maximum?

Re: Adding rows from list to repeating table

GuyBoswell — Tue, 07 Apr 2015 20:16:22 GMT

Hi Hilary, I've actually got the data connection set to query only on update of another field which selects the rows available in the list. So the form opens OK. I only get the error when I run the query. Guy *** Right, I just tried amending the data connection to query automatically. Without a filter set the query goes in to an infinite loop. When I OK on the error message it successfully displays eight rows from the list in the repeating table. I took out the reference to the secondary data source in the repeating table and instead added another repeating table just to display the list. It now opens without error and displays all sixty odd rows of the list in the second repeating table. Of course it doesn't display the values from the list in the original table, just eight blank rows as per the defaults. So something about the query of the table and the repeating table together forces the count way up high and causes errors once I get to eight rows in the repeating table.

Re: Adding rows from list to repeating table

Hilary Stoupa — Tue, 07 Apr 2015 16:29:41 GMT

You get the error on form open? Are there any other rules running off the field with the default value? I'll check my sample in our environment later today and see if the same issue reproduces for me.

Re: Adding rows from list to repeating table

GuyBoswell — Tue, 07 Apr 2015 16:23:27 GMT

Hi Hilary, sorry but the wedding is off.

Firstly, I am married :-)

Secondly, your solution works up to seven rows but if I add an eighth default row I get an error,

"An error occurred in the form's code. The number of calls to the Changed event for a single update in the data exceeded the maximum limit."

It works fine in preview. I have added up to 20 default rows with no problems. Even though the preview is pulling data on the same data connections from the same SharePoint list.

But once published and opened in browser it always works with seven or less default rows and always fails with eight or more default rows.

Any ideas?

Thank you so much :-)

Re: Adding rows from list to repeating table

Hilary Stoupa — Tue, 07 Apr 2015 15:34:48 GMT

Hmmmmm.... the second bit makes me think you figured it out? The filter is the square brackets and the stuff inside... :)

Re: Adding rows from list to repeating table

GuyBoswell — Tue, 07 Apr 2015 15:25:03 GMT

Which bit is the filter? Where do I add it?

Ahhhhh! Hilary, I love you. I am a complete idiot but please marry me :-)

Re: Adding rows from list to repeating table

Hilary Stoupa — Tue, 07 Apr 2015 15:18:04 GMT

current() is an XPath function, yes. It refers to the current node. I selected the checkbox to edit XPath in the formula and manually added the filter of [count(current()/../preceding-sibling::my:group2) + 1]

So, select the field that has the value you want from your secondary data source, then click the checkbox to edit the XPath, and manually add the filter. If the field with the default value is in your repeating group, all you should have to change is "my:group2" to be the name for your repeating group.

Re: Adding rows from list to repeating table

GuyBoswell — Tue, 07 Apr 2015 14:44:46 GMT

Nope! Can't work that out at all??? If I touch food in food[count(current()/../preceding-sibling::group2) + 1]/name the whole thing falls apart. Is current() supposed to be a function? It isn't on the function list. What is this text made up of? Because it isn't just text because I can't edit it character by character.

Re: Adding rows from list to repeating table

GuyBoswell — Tue, 07 Apr 2015 14:32:14 GMT

Hilary,

Thank you.

Code just not an option. Sandbox?? I am admin but I can't approve anything.

Preceding-sibling. Great! Where do you get this stuff? I can see it works but I can't for the life of me find anywhere that explains why? Which makes modifying it to match our actual data structure a whole lot of trial and error.

Re: Adding rows from list to repeating table

Hilary Stoupa — Tue, 07 Apr 2015 14:14:59 GMT

So - do you get an error message when you add code to the form and try to publish to the library? I'm guessing the sandbox service may not be running on your form. Browser forms can have code and be published either directly to the library if the sandbox service is running, or can be admin approved if not.

Usually I use a count of preceding-sibling. See attached. Save the form locally, right click and select design, then preview.