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
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
You can use the IsMatch function with the matching option IgnoreCase
@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.
User | Count |
---|---|
224 | |
100 | |
94 | |
57 | |
31 |
User | Count |
---|---|
281 | |
114 | |
110 | |
63 | |
57 |