Viewing SharePoint list in a nested repeating table in InfoPath

Last post 08-06-2013 12:10 PM by DennyNichols. 0 replies.

Page 1 of 1 (1 items)
	Sort Posts: Previous Next

08-06-2013 12:10 PM

DennyNichols
Joined on 08-06-2013
Posts 5

Viewing SharePoint list in a nested repeating table in InfoPath

Reply Contact

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))

Page 1 of 1 (1 items)

InfoPath Dev