Viewing SharePoint list in a nested repeating table in InfoPath

DennyNichols — Tue, 06 Aug 2013 19:10:48 GMT

In InfoPath 2010 I have a nested repeating table (one parent, one child)…Each table is bound to a separate external data connection (SharePoint 2010 List) so that I can view data from the respective lists. The Parent Table filters off a field from Main (myFields) (ie if office_parent_repeating_Table != office_main, then hide control), that works fine and will display a list of names from a chosen office in that repeating parent table Now I want to filter the child table based on the name in the current record of the Parent table. (i.e. if Name_Parent_Field_in_repeating_Table !=(or contain) Full_Name_child_field_repeating table, then hide control.)

However, my check condition is only keying off the first visible record from the parent table. How do I add a ‘check current() record’, into my filter condition?Current XPath code (these aren’t my field names I expanded them for clarity)
not(contains(d: Name_Parent_Field_in_repeating_Table, xdXDocument:GetDOM("My_2ndList")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Full_x0020_Name))

SharePoint Integration

Viewing SharePoint list in a nested repeating table in InfoPath