Search function issue: Needs to search on capital as well as Proper case

(0) Share

Report

Posted on by SearchingYT

107

Hi power apps experts,

I have a text column with customer names, and I am performing search in this way:
Search('CustTabel', Proper(TextSearch.Text),"CustomerName")

I am using proper, as names are normally written that way. But, we also have some Company names that are written in capitals, for example "BBC ..."

How can I perform search on the same column with proper as well as upper?

Search('CustTabel', Proper(TextSearch.Text) || Upper(TextSearch.Text) ,"CustomerName")
But this doesn't work.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

Hey @SearchingYT

I am not sure but I thinkt that you dont need the "UpperCase" code because I have an app and the user has names witch capital letters and others without capital letters and he can search both.

Try this:
Search(CustomTabel;TextSearch.Text;"CustomerName")

Plus, if you use "," it will not work, now in Power Apps you need to use ";" instead of ","

If this solved your problem, please mark it as a solution 🙂

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SearchingYT

As @Nogueira1306 says, Search typically carries out a case-insensitive search by default. Are you finding that's not the case for you? If so, what data source are you using? SQL Server?

Was this reply helpful? Yes No
SearchingYT 107 on at

Like (0)

Report

Hey @Nogueira1306
; and , depends on what regional language we use in power apps. In english, its stille a , between arguments.

I need the case code because:
If CustomerName is "Abc" and I type "abc" in my search. It does not give me a match. Hence, if I use proper it changes my "abc" to "Abc" and searches and findes a match.
The same applies with capital letter. If CustomerName is "ABC" and I type "abc" it does not give me a match. If I use Upper it changes my "abc" to "ABC" and searches and findes a match.

Hence, I want my search to have both capabilities.
Or, the best solution, I want my seach function to be case insensitive...

Was this reply helpful? Yes No
SearchingYT 107 on at

Like (0)

Report

Hi @timl I am using SQL, and I can confirm that search function is not case-insensitive.

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @SearchingYT

The reason for this is most likely because your SQL Server uses a case sensitive collation.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Search-Case-sensitive/m-p/41098

The way that I would build a case insensitive search feature would be to create a SQL Server view, and to cast the target column to a data type that uses a case insensitive collation. This will work well, and will avoid the delegation problems that you could experience with other workarounds.

This is the view that you would create (Latin1_General_CI_AS is case-insensitive and accent-sensitive).

CREATE VIEW vwCustomerSearch AS SELECT [CustomerName] COLLATE Latin1_General_CI_AS AS [CustomerName], [Address1], [Address2], [etc] FROM dbo.Customer

From Power Apps, this should now carry out a case insensitive search:

Search(vwCustomerSearch, TextSearch.Text, "CustomerName")

Was this reply helpful? Yes No
SearchingYT 107 on at

Like (0)

Report

@timl Amazing!!! That was the issue. The solution was in the collation of my sql column. Thank you, this has helped me to really optimize searching in my app!

Was this reply helpful? Yes No