cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
connor
Level: Powered On

Search Is Case-Sensitive with Oracle DB

Hi there, 

I am having an issue with the PowerApps Search(). As of right now, my Search() is case-sensitive. My app is connected to an Oracle on-prem DB.  I think the issue is that Oracle is case-sensitive by default. Changing the collation type on the Oracle DB is not an option at this time. 



Do you have advice on a workaround? Is there a way to get the same expected "search" functionality form Filter() or another formula? 

 Thank you



 

1 ACCEPTED SOLUTION

Accepted Solutions
PauwelsSven
Level 8

Re: Search Is Case-Sensitive with Oracle DB

Hi,

 

Filter(Datasource, Upper("Text") in Upper(Column1) || Upper("Text") in Upper(Column2))

 

The Upper() function will case both the words so it won't be casesensitive.

3 REPLIES 3
tchin-nin
Level 10

Re: Search Is Case-Sensitive with Oracle DB

Hi @connor

You can use the "in" operator :

Filter('Data source', "text" in Column1 || "text" in Column2)

 

The "in" operator is case insensitive.

 

Théo

connor
Level: Powered On

Re: Search Is Case-Sensitive with Oracle DB

Thanks for the quick reply @tchin-nin.

Unfortunately, Filter is giving the same result as Search(). Filter is still acting case-sensitive. 

PauwelsSven
Level 8

Re: Search Is Case-Sensitive with Oracle DB

Hi,

 

Filter(Datasource, Upper("Text") in Upper(Column1) || Upper("Text") in Upper(Column2))

 

The Upper() function will case both the words so it won't be casesensitive.