Case-insensitive string comparison?

[Meneghino]

PowerApps is case-sensitive, and this extends to string comparisons, hence

"AAA" = "aaa" -> false

One way to make string comparisons case insensitive (useful when checking email addresses for example) is to use the Lower function, so that

Lower("AAA") = Lower("aaa") -> true

But is there another way?  The problem is that Lower is not (yet!) delegated so that this cannot be used in a filter expression for an external data source.

PS I raise this question following this post by @johandeweerdt

[v-monli-msft]

Hi,

After some researching and testing around, I think this cannot be achieved so far in PowerApps. 

You could post this idea in the PowerApps Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Mona Li

[Anonymous]

You can use the IsMatch function with the matching option IgnoreCase

[JRaasumaa]

---

@Anonymous wrote:

You can use the IsMatch function with the matching option IgnoreCase

---

IsMatch doesn't allow comparing two strings to each other, only a string to an expected format 😞

It's close but not quite, would be worth putting this in the Ideas Forum for voting.