Hi All,
I have recently upgraded from Infopath 2007 and Sharepoint 2007 to the 2013 versions.
I had a repeating table where users entered a date, expense type, and cost of an expense.
The expense type came from a Sharepoint library called Expense GL's.
Previously I was able to set a 4th field called GL based on the Expense Type the user selected and the company there were from.
The old xpath code looked like this:
xdXDocument:GetDOM("Expense GLs")/dfs:myFields/dfs:dataFields/dfs:Expense_GLs/@GL[../@Company = xdXDocument:get-DOM()/my:myFields/my:Company and ../@Title = current()/../my:Expense_type]
However I cannot get the function current() to work in the new Infopath form to filter the result to the current row (node).
I have tried putting current() everywhere but it won't work. Here is what I have so far.
xdXDocument:GetDOM("Expense GLs")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:GL[../d:Company = xdXDocument:get-DOM()/my:myFields/my:Company and ../d:Title = xdXDocument:get-DOM()/my:myFields/my:Expenses_Sec/my:Expenses/my:Expense_Items/my:Expense_type]
I would expect to put current() right after the ../d:Title = but this does not work. Any thoughts?