Power Platform Community Forum Thread Details

Hi, I have a connection with a BDD in MySQL and I have in a table "Customers", different records and different codes like "CLI0001" and "SUS0001". the problem is that I need to show customers whose code starts with "SUS".

THIS IS MY CODE: (This code is programmed in the event "Items" of "BrowserGallery" control)

SortByColumns(
 Search(
 Filter(
 '[dem_circulacion].[clients]';
 'cliNumero' in "SUS"
 );
 TextSearchBox1.Text;
 "cliNumero";
 "cliNombreCompleto";
 "cliTelefono"
 );
 "cliNumero";
 If(
 SortDescending1;
 Descending;
 Ascending
 )
)

THE IMAGE: