PowerApp Case Insensitive Search in ComboBox

If you wonder, why you can’t get the search box to lookup the values of the search term by ignoring the case you will have to find out, that you have to configure your datasource to allow this case insensitive filtering. I spend almost 1 hour to figure out the issue – anyhow – here is the solution:

ALTER VIEW [dbo].[V_DIM_LEDGER_CHART]
AS
SELECT 
	*,
	Type + ' ' + CCCUPJId + ' ' + Name <strong>COLLATE Latin1_General_CI_AS</strong> as Label
FROM (
Code-Sprache: PHP (php)

In bold you can see the important step – pls. be aware, that according to your encoding you have to change to the correct base – anyhow with the “_CI” we handover the information to the server, that we wanna allow power apps to query the data without strict text comparisson behaviour.