InfoPath Dev

I am trying to extract data from a repeating table from a secondary data connection based on a filter from the main data source. Then concat that data in text box. My problem is around using current() (I think). When the field I am filtering by on the main data source is blank, the formula works (data populates from all the rows with blank data), but if the data matches the filter condition, only the data from the first row of the table populates in the text box.

What I want is something like this:

Text Box = 45;69;77 (pulls from the row that meets the filter condition)

What I get is this:

Text Box = 78 (pulls from the first row, not the correct row from the table)

Here is my formula:

dMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Workbaskets_US_Assignments")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:US_x0023_ = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:ID], 'concat(xdXDocument:GetDOM("Workbaskets_US_Assignments")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:New_x0020_Assignment_2, ";")'), "..")

Do I need to add current() somewhere?

 Try:

dMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Workbaskets_US_Assignments")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:US_x0023_ = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:ID], 'concat(d:New_x0020_Assignment_2, ";")'), "..") 
 

It is working now, thanks. But the semicolon is not placed between values, only at the end.

It is showing this:

36589;

But it should be showing this:

36;58;9

Weird. Can you paste the full XPath of your formula back in a reply?

Sure, here is the Xpath:

xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Workbaskets_US_Assignments")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:US_x0023_ = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:ID], 'concat(d:New_x0020_Assignment_2, ";")'), "..")

 It looks right to me. I guess you could always try:

xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Workbaskets_US_Assignments")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:US_x0023_ = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:ID]/d:New_x0020_Assignment_2, 'concat(., ";")'), "..")  

I am still getting the same results. When I preview the form in Infopath, the text box is formatted correctly. When I publish to SharePoint, the formula only places the semicolon at the end. Both formulas you provided give the same results.

InfoPath preview: 78;56;45

SharePoint view: 785645;

Oh. I see. I hadn't realized you were saying the form is behaving differently in the browser vs. in the filler. I've never seen that happen w/ a double eval before. When you say "SharePoint view" - you do mean in the form itself in the browser, right? You aren't talking about a promoted property value or anything like that? What version of SharePoint are you using? Is the value a default in a field, in a calculated value, or in a rule that sets a field? I'd like to see if I can reproduce the issue.

The form data source is a SharePoint list on SP2013. I created the list in SP first, then I created the Infopath form. The form is a browser form that opens when a user edits or creates a new a SP list item. I have tried using the Xpath in a calculated field and in a text box with a rule to set the value on form load. Either way I get the same incorrect formatting for the concat...semicolon only at the end.

The SP list in the Eval function, has another SP lookup field. So there are really 3 SP lists:

(1) Main Data (2) Secondary (Workbaskets_US_Assignments) (3) Secondary (Assignments)

The numbers populating from the Xpath are the ID numbers from Assignments (3) SP list. I did see a warning when I ran the design checker in InfoPath, see attached image.

 Weird. I'm not sure I've ever tried double eval in a list form. I may have a chance to try it tomorrow - I'll let you know if I have the same result.