InfoPath Video Tutorial: Filter SharePoint list data in an InfoPath repeating table on dates

by S.Y.M. Wong-A-Ton

In this InfoPath video tutorial you'll learn how to use two date picker controls to select a date range that can be used together with conditional formatting to filter data from a SharePoint list contained in a repeating table on dates.


In this InfoPath video tutorial, you learned…

The written solution can be found here: Filter a SharePoint list in a repeating table in InfoPath on a date range.

 Subscribe (RSS | Email)

Related Posts

See more InfoPath 2007 videos »

  1. 4 Responses to “InfoPath Video Tutorial: Filter SharePoint list data in an InfoPath repeating table on dates”

  2. Hi,

    i have a question. Is it possible to store the data of the sharepointlist with the formular? so that the same data(tasks) is displayed later even though the sharepointlist and the tasks in this list are edited.

    Kind regards

    Christian

    By Christian on Dec 1, 2009

  3. Hi Christian,

    Not if the data source is a secondary data source, which it is in this case. To store the data with the form, you’d have to copy the rows from the SharePoint list over to another repeating table that is part of the Main data source of the form. Also see the article Main vs. secondary data sources for the difference between Main and secondary data sources in InfoPath.

    To copy the rows, you could use code that uses XSLT (see Copy a SharePoint list to an InfoPath repeating table using XSLT) or loop through the rows of the secondary data source (see How to loop through items in a repeating table in InfoPath 2007) and copy the rows you want to copy over to a repeating table in the Main data source (see Programmatically copy rows from a SharePoint list to a repeating node in the Main data source in InfoPath).

    I’m currently working on a SharePoint/InfoPath video tutorial that will show you another way of copying rows from a SharePoint list to a repeating table in the Main data source. This solution will use rules (not code) and is kind of a workaround if you don’t want to or cannot write code. The video should be up by the end of the week – if not sooner. I don’t generally announce videos on the main page of my InfoPath blog, only in its RSS feed and on the InfoPath video tutorials page, so you may want to bookmark the videos page or subscribe to my blog to stay updated.

    By S.Y.M. Wong-A-Ton on Dec 1, 2009

  4. Hi,

    many thanks for your reply. i was looking for a solution without code. only with rules. i am following your blog with big interest and use RSS Feed. I have also watched your last video tutorial, but that’s not the solution i am looking for. Nevertheless i will continue reading your great articles.

    Kind regards

    Christian

    By Christian on Dec 3, 2009

  5. Hi Christian,

    No worries, and sorry I couldn’t be of more help. Thanks for being one of my readers and for your kind words. If you need anything else, let me know.

    By S.Y.M. Wong-A-Ton on Dec 3, 2009

Comments to this post were closed 30 days after it was published.

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. Usage of 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.

Working with InfoPath