cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Champion
Community Champion

Case-insensitive string comparison?

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

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Case-insensitive string comparison?

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Case-insensitive string comparison?

You can use the IsMatch function with the matching option IgnoreCaseignorecase.PNG

Highlighted
Memorable Member
Memorable Member

Re: Case-insensitive string comparison?


@Anonymous wrote:

You can use the IsMatch function with the matching option IgnoreCaseignorecase.PNG


 

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.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,229)