InfoPath Dev

I'm trying to filter a single SharePoint list using the FilterOwssvr command. It worked with no problem when I created a test list with City and State.  However, now in trying to filter on an actual list, I am getting the error "Parameter count mismatch for filter and value. Please verify each parameter has the same number of comma-separated values."  I have confirmed that both parameters have the same number of values.  I have removed 'show only entries with unique values' and that does not help.  Here's what I'm using for the rule:   concat("FilterOwssvr /dsname=FilterOwssvr /filter=EvaluatorFilter /value=", .)  Any help would be appreciated.

 Hi!

The rule pasted above looks ok but it would be helpful to look at it in the context of the form. Can you attach your form via the Options tab when you reply?

Thanks!

Hello Lolly,

As the error message indicates, the most likely issue is that the value referred to by the dot in your formula most likely has one or more commas in it.  Can you see if that is the case?

Or maybe the issue is that EvaluatorFilter is a field in your form that has commas in it, but you have it here as text in your command instead of concatenating it in?

Hi - FilterOwssvr command has an optional "delimiter" parameter that you can use for specifying what delimiter you wish to use instead of commas. That way you can use something that doesn't appear in your text (like "~") for a delimiter and your commas should be okay.

I will try changing the delimiter and will let you know my results.  Thanks for responding so quick.

What would be the syntax then?  I'm not sure how to do this. 

concat("FilterOwssvr /dsname=FilterOwssvr /filter=EvaluatorFilter /value=", ., " /delimiter=~")

for example...