Filter SharePoint list on dates in InfoPath 2010

Learn how you can use rules to filter items from a SharePoint tasks list to display only those tasks that lie between two dates in a repeating table on an InfoPath 2010 form.

There are several ways you can filter SharePoint lists in InfoPath 2010 (see recipes 50, 51, and 52 in InfoPath 2010 Cookbook 2). However, there aren't many of these methods that allow you to filter a SharePoint list on a date range.

The method described in the InfoPath video below uses a formatting rule to filter rows in a repeating table that is bound to a SharePoint tasks list on a date range. This method is suitable for SharePoint lists that contain a limited amount of items.

In this InfoPath 2010 tutorial video, you learned...

  • How to add a data connection for a SharePoint tasks list to an InfoPath 2010 form.
  • How to lay out controls on an InfoPath form.
  • How to add date and time picker controls to the view of an InfoPath form template.
  • How to bind a repeating table control to the data source for a SharePoint list.
  • How to add a Formatting rule to a repeating table.

See more InfoPath 2010 tutorial videos »

 
 Subscribe for updates via RSS or Email

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services