You’re offline. This is a read only version of the page.
Announcements
2
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
As I was finishing off the above post, I may have found an answer to my own question... My Gallery Items was set to:
Share
Report
All responses (
Answers (
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?
