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
Solved! Go to 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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
202 | |
100 | |
61 | |
59 | |
58 |
User | Count |
---|---|
254 | |
163 | |
90 | |
79 | |
70 |