Filter SharePoint list data in an InfoPath repeating table on a date range

http://www.bizsupportonline.net - In this video tutorial you'll learn: How to add a data connection of a SharePoint list to an InfoPath form template, how to bind a repeating table to a Receive data connection of a SharePoint list (secondary data source), and how to use conditional formatting to hide all of the rows in a repeating table that do not contain items that fall within a date range specified through 2 date picker controls.

The written solution can be found here: http://www.bizsupportonline.net/infopath2007/filter-sharepoint-list-infopath-...

InfoPath 2010 Cookbook:
http://www.bizsupportonline.net/infopath-2010-book.htm

InfoPath 2010 Cookbook 2:
http://www.bizsupportonline.net/infopath-2010-sharepoint-2010-book.htm

InfoPath 2010 Cookbook 3:
http://www.bizsupportonline.net/infopath-2010-write-code-book.htm

Category:

Science & Technology

Tags:

• microsoft office
• sharepoint
• infopath
• 2007
• sharepoint list
• filter
• repeating table
• date filtering
• video
• tutorial
• screencast
• demo
• bizsupportonline
• S.Y.M. Wong-A-Ton
• infopath video tutorial
• data connections
• rules
• conditional formatting
• form template
• walkthrough
• how to
• no code
• codeless

[gastondamian]

Thanks Man! your videos are very useful!

[vladiator2007]

@markevogt That's because the filter sets conditional formatting for the rows to be filtered OUT (hidden) - not the ones to be displayed.

Thanks for the video! It saved me a lot of grief!

[markevogt]

A most excellent video... but I have to wonder if at first glance you didn't mix-up the criteria on your dates? Your filters are looking for a date which "is less than" the stated START date, and "is greater than" the stated END date - shouldn't it be the other way round?

And yet surprisingly it still returns results.

Go figure ;-) ...

[chintandd]

no audio - very difficult