cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JanLektonen
Advocate III
Advocate III

Case-insensitive search in Combobox control

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

3 REPLIES 3
timl
Super User
Super User

Hi Jan,

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

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...

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,870)