Case-insensitive search in Combobox control

[JanLektonen]

Hi community

Is it posible to make the standard search in the Combobox control case IN-sentitive so that I do not have to only write the seachtext in capitals when searching ? I want to write/search fx. "demo" and not "DEMO" - both should return result...

There is no option for controlling this in the parameteres in the control  - but maybe someon knows how to do it anyway using this STANDARD Combobox dropdown with SEARCH enabled... 

Thanks & 

Best regards, Jan

[timl]

Hi Jan,

What's the data source for your app? Is it SQL Server by any chance?

[JanLektonen]

Hi @timl 

Yes the source database is a table from SQL-server... The column I want to search in have all records in Capital letters...

[timl · Accepted solution]

Hi @JanLektonen 

With SQL Server data sources, PowerApps will carry out case sensitive searches if your database applies a case sensitive collation sequence. 

https://powerusers.microsoft.com/t5/General-Discussion/Search-Case-sensitive/td-p/41098

To work around this problem, you can create a View in SQL Server that CASTs the column that you want to search against to a case insensitive collation (eg SQL_Latin1_General_CP1_CI_AS). You can then add this View to your app, and set the Items property of your Combobox to the view.