General

Re: Limit Secondary Data Connetion to Specific Number of Rows

chasquad — Wed, 17 Jun 2015 14:47:48 GMT

So, on Form Load I have the Status field of the query of the secondary data connection being set to "approved" so that I only bring in approved posts. Then I have the secondary data connection being queried. The secondary data connection is set up to sort descending on Announcement Start Date field.

Then on the repeating table properties, I have added the formatting rule

count(preceding-sibling::d:SharePointListItem_RW) + 1 <= count(/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW) - 6

AND

count(/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW) > 6

Re: Limit Secondary Data Connetion to Specific Number of Rows

chasquad — Wed, 17 Jun 2015 14:40:47 GMT

I just discovered an issue.

So, I have this secondary data connection set to sort by date showing the last created entries first. Without the conditional formatting rules applied, new entries appear, but I get all of them! With the conditional formatting rules applied, new entries do not appear, but I get the row limits that I wanted.

Really what I need is for the last 6 entries to be posted to be displayed. But with the rules applied, I guess I get 6 entries, but not necessarily the last 6 to be posted.

Help!

Thanks!

Re: Limit Secondary Data Connetion to Specific Number of Rows

chasquad — Tue, 16 Jun 2015 15:21:05 GMT

It WORKS!

Thank you both!

Re: Limit Secondary Data Connetion to Specific Number of Rows

Hilary Stoupa — Tue, 16 Jun 2015 14:42:29 GMT

Patrick's formula for your form would be (on a condition on the repeating d:SharePointListItem_RW group):

count(preceding-sibling::d:SharePointListItem_RW) + 1 <= count(/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW) - 4

*AND*

count(/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW) > 4

Re: Limit Secondary Data Connetion to Specific Number of Rows

chasquad — Tue, 16 Jun 2015 13:29:23 GMT

Thanks Patrick

It's been a long time.

I've attached my form for reference. It uses a secondary data connection. I'm not sure if this works with those. The xpath is /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW

thanks for your help!

Re: Limit Secondary Data Connetion to Specific Number of Rows

Patrick Halstead — Mon, 15 Jun 2015 06:01:06 GMT

You can add a formatting rule to the repeating row that hides the control; the key is the condition for the rule:

count(preceding-sibling::my:group2) + 1 <= count(/my:myFields/my:group1/my:group2) - 4

*AND*

count(/my:myFields/my:group1/my:group2) > 4

Note: this assumes that you have a form with a stock data source root node of myFields and group1->group2 underneath it where group2 is repeating.

You will need the change the fields to your form to make it work.

Check out the attached sample.

Limit Secondary Data Connetion to Specific Number of Rows

chasquad — Fri, 12 Jun 2015 18:49:29 GMT

I have InfoPath 2013 form that uses SharePoint Secondary Data Connection. The data connection is sorted descending by date and filtered to show only approved items. The form is being displayed in a SharePoint Online web page using the InfoPath Form Web Part.

I don't want to show all approved items. I just want to show the last 4 items. This would be easy if it were not in SharePoint Online and had to be a InfoPath Web based form, but those are the requirements. Sorry!

Any help would be appreciated.

Thanks!