Skip Ribbon Commands
Skip to main content

Colorado SharePoint Users Group (COSPUG)

:

InfoPath & SharePoint Designer:Filter repeating table - secondary data sourceSharePoint list :FlatUse SHIFT+ENTER to open the menu (new window).Open MenuOpen Menu

Please feel free to ask your InfoPath and SharePoint Designer questions here for both 2007 and 2010.  Clayton Cobb will be here to answer them or ensure they get answered...
Posted ByUse SHIFT+ENTER to open the menu (new window).
  
Post
Started: 1/22/2010 9:18 AM
Picture Placeholder:
Filter repeating table - secondary data source/SharePoint list

​Hi,

I'm trying to filter a repeating table based on a selection from a drop-down list. I've setup the data source connections, but setting up the filtering is a little tricky.

Could you please do a blog post on this issue?

Thanks,
Brian

Posted: 1/22/2010 9:24 AM
Picture: Clayton Cobb
Clayton CobbNo presence information

Brian,

 

That is a good idea for a blog post and shouldn't require too much text or steps.  In the meantime, this should answer your question:

 

1) Open the properties of your table

2) Click the Display tab

3) Click Conditional Formatting

4) Add a condition that says, "Where FieldInRepeatingTable is equal to DropdownField, hide this control."

 

What this does is it hides all the rows of the repeating table where the two fields do not match.  You just have to be sure that the syntax of the data in the comparison fields are exactly the same.

 

If you can't get it to work from these instructions, then attach a stripped version of your XSN file here, or send it via email.

 

Thanks!

Clay

Posted: 1/25/2010 3:44 AM
Picture Placeholder:
Thanks Clayton,

This got me back on track (knew I was overlooking something pretty obvious). One minor change was to use "not equal" instead of "equal" (the results being returned with equal where not the desired results).

-Brian


Posted: 1/25/2010 4:33 AM
Picture: Clayton Cobb
Clayton CobbNo presence information
Good stuff - glad it worked.