Case sensitive on search bar

(0) Share

Report

Posted on by JukeNuke

Hello, I currently have an App that is connected to a SQL database to search part numbers from SAP. The issue I am having is that when searching its case sensitive where everything has to be typed in capital letters to return results. Anyway to go about making it not case sensitive?

SortByColumns(Search(Filter([@'[ep1].[MARD]'],WERKS="1005" Or WERKS="1000", LGORT = "0001" Or LGORT= "0002"),TextSearchBox1.Text, "DISKZ","DLINL","ERSDA","WERKS","MATNR"), "DISKZ", If(SortDescending1, Descending, Ascending))

SortByColumns(Search(Filter([@'[ep1].[MARD]'],WERKS="1005" Or WERKS="1000", LGORT = "0001" Or LGORT= "0002"),TextSearchBox1.Text, "DISKZ","DLINL","ERSDA","WERKS","MATNR"), "DISKZ", If(SortDescending1, Descending, Ascending))

Categories:

Building Power Apps