InfoPath Dev

Hello there, Have any of you attempted to iterate thru a repeating table and capture column values in a text field using concat to parse it later? I have done this umpteen times with Main DataSource and thought would be the same with Secondary DataSource I used below to make this happen eval(eval(RepeatingGroup, ‘concat(my:Field, “;”)’), “..”) Could there be anything different while using a secondary data source? I have a webservice which returns list of Products and Quantities which need to be updated. Issue I am having when I use the above formula is i just get the same value for every row in the repeating table. Just captures the first row value and repeats for the number of rows. not sure what I am doing wrong...any ideas? Ray

 Could you attach a screenshot of the data source you are trying to work with, and the actual full formula you are using?

Attached is the screenshot of secondary data source and the formula below. Appreciate you looking into it I am looping thru and trying to get AuthorityDesc||SupValue from every row eval(eval(SupUserDOAData, 'concat(xdXDocument:GetDOM("GetAllAuthoritiesByUserAndSupervisor")/dfs:myFields/dfs:dataFields/tns:GetAllAuthoritiesByUserAndSupervisorResponse/tns:GetAllAuthoritiesByUserAndSupervisorResult/tns:SupUserGroupData/tns:Subgroups/tns:SupUserSubgroupData/tns:Authorities/tns:SupUserDOAData/tns:AuthorityDesc, "||", xdXDocument:GetDOM("GetAllAuthoritiesByUserAndSupervisor")/dfs:myFields/dfs:dataFields/tns:GetAllAuthoritiesByUserAndSupervisorResponse/tns:GetAllAuthoritiesByUserAndSupervisorResult/tns:SupUserGroupData/tns:Subgroups/tns:SupUserSubgroupData/tns:Authorities/tns:SupUserDOAData/tns:SupValue)'), "..")

Jimmy do you want anymore info to look into this?..Please advise

In your concat, you are using the full XPath instead of the relative XPath. Instead of:

xdXDocument:GetDOM("GetAllAuthoritiesByUserAndSupervisor")/dfs:myFields/dfs:dataFields/tns:GetAllAuthoritiesByUserAndSupervisorResponse/tns:GetAllAuthoritiesByUserAndSupervisorResult/tns:SupUserGroupData/tns:Subgroups/tns:SupUserSubgroupData/tns:Authorities/tns:SupUserDOAData/tns:SupValue

can you try just tns:SupValue?

Thank you so much Hilary ...thanks for pointing this out... You are awesome