SQL Case Sensitivity

(0) Share

Report

Posted on by benhorder-c1

Hi all,

Firstly, my apologies because I know this question has been asked and answered on a number of occasions, I'm hoping to get some current advice.

I'm having difficulty with Case Sensitive search in a Power App linked to an (on-premises) SQL Database.

Database collation is set as SQL_Latin1_General_CP1_CI_AS, Column collation is set as database default. Column in question was originally set to a data type of text, but has been changed to varchar(MAX).

I've also tried creating a view and specifically setting the columns in that view with Case Insensitive collation, and it still searches as Case Sensitive only.

Does anyone have any suggestions?

Cheers,

Ben

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

benhorder-c1 2 on at

Like (0)

Report
Copy link

Link copied!
As I was finishing off the above post, I may have found an answer to my own question... My Gallery Items was set to:
Search(Filter(Sort(Company,CompanyName,Ascending),CompanyStatus = StatusDropdown.Selected.Result And (EntityDropdown.Selected.Value="All" || CompanyTerritory = EntityDropdown.Selected.Value)),SearchBox.Text,"CompanyName")

If I clean this up and just have the Search and Sort rather than the filters:
Search(Sort(Company,CompanyName,Ascending),SearchBox.Text,"CompanyName")
Then it works!
So, revised question. How do I Search AND Filter AND retain case insensitivity?

Was this reply helpful? Yes No