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

Show items with personalized string by SortByColums with BDD

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:

image.png

 

1 REPLY 1
lucia
Level 8

Re: Show items with personalized string by SortByColums with BDD

Hey,

 

This part of your code does not make sense.

 

Search(
        Filter(
            '[dem_circulacion].[clients]';
            'cliNumero' in "SUS"
        );
        TextSearchBox1.Text;
        "cliNumero";
        "cliNombreCompleto";
        "cliTelefono"
    );

You are filtering datasource 'cliNumero' in "SUS", meaning that 'cliNumero' should be in the string "SUS".

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 335 members 6,419 guests
Please welcome our newest community members: