Answered

Filter gallery from drop-down list

(0) Share

Report

Posted on by jgarciac

172

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:
 

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

jgarciac 172 on at

Like (0)

Report
Copy link

Link copied!

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

)

Was this reply helpful? Yes No
jgarciac 172 on at

Like (0)

Report
Copy link

Link copied!

The mistake remains

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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
)

Was this reply helpful? Yes No