Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter gallery from drop-down list

Posted on 25 Nov 2024 21:33:51 by 168
Hello again, please help, I'm trying to filter a gallery, using two fields, one text, which works fine for me and another a drop-down list, but I've tried several ways and they all give me error...
The drop-down list is declared as follows:
 
Distinct('TXXXXXXXXXXXXXX';Estado_Ingreso.Value)
 
Gallery Filter:
 
SortByColumns(
    Search(
        Filter('TXXXXXXXXXXXXXX';
        Estado_Ingreso=Select_Etapa.Selected.Value);
        TextInput3.Text;'Nombre del Servicio');
    varSortColumn;varSortDirection)
 
but I get the following error:
 
  • Verified answer
    jgarciac Profile Picture
    jgarciac 168 on 25 Nov 2024 at 22:36:28
    Filter gallery from drop-down list
     
    I found the error would be like this, thank you very much!!
     
    SortByColumns(
        Search(
            Filter(
                'TXXXXXXXXXXXXXX';
                Estado_Ingreso.Value = Select_Etapa.Selected.Value
            );
            TextInput3.Text;
            'Nombre del Servicio'
        );
        varSortColumn;
        varSortDirection
    )
  • jgarciac Profile Picture
    jgarciac 168 on 25 Nov 2024 at 22:21:33
    Filter gallery from drop-down list
     
    The mistake remains
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 911 on 25 Nov 2024 at 21:50:46
    Filter gallery from drop-down list
    pls try the following:
     
    Ensure your drop-down is correctly populated with distinct values: Distinct('TXXXXXXXXXXXXXX', Estado_Ingreso.Value)
     
    Update the Filter condition to correctly reference the Result column from the drop-down list:: SortByColumns(
        Search(
            Filter(
                'TXXXXXXXXXXXXXX',
                Estado_Ingreso.Value = Select_Etapa.Selected.Result
            ),
            TextInput3.Text,
            "Nombre del Servicio"
        ),
        varSortColumn,
        varSortDirection
    )
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard