InfoPath Dev

I see. Does the error occur when you try to execute the data connection, or at some other time? Does the form use any custom code? Would it be possible to open up the SharePoint logs immediately after the error happens to see if you can find some related error?

Hi Baseball17Bucks,    I think that, if anything, [count(preceding-sibling::*) + 1] would refer to the last row of a repeating group, but there's an easier way to do that as well. First row of a repeating group:    my:YearlySpendingPlan[1] Last row of a repeating group:    my:YearlySpendingPlan[last()]

When you get that error message in the browser, does it provide a correlation ID? If so, would you be able to fetch the associated error from the SharePoint logs?

In the first one, you should use the condition editor to select the DepartmentName from the secondary data connection on the left side and the one from the form on the right side of the comparison. Likewise for the DeptID.

2. I believe the formula would look something like row[@DepartmentName = DepartmentName]/@Dept_ID You can achieve this by selecting the @Dept_ID field and adding a filter with the condition @Department_Name = DepartmentName (from the main data source). 3. I believe the formula would look something like row[@Role = "Approver" and ...

Please give this a try:      translate(field, '"', " ") Note that this part '"', " " is apostrophe double-quote apostrophe comma double-quote space double-quote.

Please give the attached form a try. The important parts are the conditional formatting on the second repeating table, and the formula in the Calculated Value box in the Value column.

It sounds like the rule isn't working. Where did you place the rule exactly? Is it on the MSLB's group, or on the repeating field? It should be placed on the repeating field.

Just to make sure, could you attach a screenshot of your source and destination data source?

Could you clearly describe what it is you want to do? It's not clear from your post or from your example.