General

Re: Comparison of two values case insensitive

malkovich — Fri, 27 Oct 2017 13:27:08 GMT

It's just perfect! Thank you for your help.

Re: Comparison of two values case insensitive

Hilary Stoupa — Thu, 26 Oct 2017 22:42:26 GMT

Oh, will this be used in the browser? You'll have to use translate instead (sorry, it's icky): count(xdXDocument:GetDOM("CNSS")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ListSiteNames[translate(current(),'ABCDEFHIJKLMNOPQRSTUVWXYZ', 'abcdefhijklmnopqrstuvwxyz') = translate(.,'ABCDEFHIJKLMNOPQRSTUVWXYZ', 'abcdefhijklmnopqrstuvwxyz')]) > 0

Re: Comparison of two values case insensitive

malkovich — Thu, 26 Oct 2017 19:51:40 GMT

In InfoPath Filler, this expression works -> count(xdXDocument:GetDOM("CNSS")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ListSiteNames[msxsl:string-compare(current(), ., "", "i") = 0]) > 0 but when I publish, I've got an error : "an invalid expression has been detected : msxsl:string-compare(current(), ., "", "i") = 0"

Re: Comparison of two values case insensitive

malkovich — Thu, 26 Oct 2017 19:10:22 GMT

You are great! It works! Many many thanks.

Re: Comparison of two values case insensitive

Hilary Stoupa — Thu, 26 Oct 2017 14:52:52 GMT

Yup, I see the issue - see the attached sample form. Save it locally, right click and select design and you can see in the validation on field1, I'm using a count of matches. The XPath I gave you returns a value from a field if it matches, so instead of true / false, you'd be getting the value of the field. I added a calc'd value to my form to help me debug the formula. I left it there so you could also see that technique (I hate working in the dark, you know?)

Re: Comparison of two values case insensitive

malkovich — Thu, 26 Oct 2017 14:48:44 GMT

The expression is accepted but the condition is not fulfilled, and the error is not indicated.

Re: Comparison of two values case insensitive

Hilary Stoupa — Thu, 26 Oct 2017 14:35:21 GMT

I'll try it on a test form, see what I've got wrong there. When you say "it doesn't work" - do you just mean the formatting doesn't hide things as expected?

Re: Comparison of two values case insensitive

malkovich — Thu, 26 Oct 2017 09:31:27 GMT

Hi Hilary,

Thank you for answering.

When I replace the expression in the rule by "xdXDocument:GetDOM("CNSS")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[msxsl:string-compare(current(),ListSiteNames, "", "i") = 0] ", it doens't work.

Best regards.

Re: Comparison of two values case insensitive

Hilary Stoupa — Wed, 25 Oct 2017 18:19:01 GMT

I wonder if you move that filter - something like this:

xdXDocument:GetDOM("CNSS")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[msxsl:string-compare(current(),ListSiteNames, "", "i") = 0]

Comparison of two values case insensitive

malkovich — Wed, 25 Oct 2017 14:51:38 GMT

Hello,

My request is simple. In a form, I would like to compare if the value of a field already exists in a sharepoint list.

I've created a data connection (with a sharepoint list) that I can use for some treatment. For a field, I made a validation rule which compares his value with the values of the existing sharepoint list.

The rule is : if SiteName is equal to ListSiteNames -> display of a message Error! . But this rule is only case sensitive (if "Utaka" is equal to "Utaka -> Error! )

For the moment, the rule (if "utaka" is equal to "Utaka") is not an error, but I would like that it's an error.

I've created another condition : if the expression "msxsl:string-compare(.,xdXDocument:GetDOM("CNSS")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/ListSiteNames, "", "i") = 0"

This condition works but compares only with the first element of the list, I can compare with the thirth element if I want when changing with SharePointListItem_RW[3] but never with the whole list.

I call on your expertise to help me.

Thanks in advance.