My InfoPath 2010 web-enabled form includes a data connection to
a SharePoint list, which provides a group of choices. As user makes one or more selections, one at a time, a row in a
repeating table is populated.
On subsequent loads of the form, I want to re-query that SP
list to update the a single column in that repeating table for each row (all at once). Was hoping I could use rules with ID = current() in form
load, but all rows are updating with
the data from the last
row’s record ID. My statement in form load looks like this:
xdXDocument:GetDOM("Security Roles")
/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Approvers/pc:Person/pc:AccountId
[../../../d:ID =
current()/my:backOfficeSection/my:fmsFunctions/my:fmsFunction/my:fmsRoleTitle]
Any ideas? I'm unable to use code. Thank you!