Answered

filter Galerry with button and text box

(0) Share

Report

Posted on by CarlosN

Hi,
I have a gallery that uses a Sharepoint database, in the database there is a column called "Status" with New and Done values, I have two buttons to filter by new and done, but I also want to include a text box to filter by other columns "Customers", "References".

this is my code:

SortByColumns(Filter('Solicitudes Expres';
 StartsWith(Estatus;EstIng2)); "Estatus"; If(SortDescending3;Descending;Ascending))

Categories:

Building Power Apps

Captura9.PNG

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@CarlosN

Give this formula a try:

SortByColumns( Filter( AddColumns('Solicitudes Expres'; "SearchText"; Customers & References); StartsWith(Estatus;EstIng2) && yourTextInput.Text in SearchText ); "Estatus"; If(SortDescending3;Descending;Ascending) )

Substitute the name of your Text box in the "yourTextInput" in the formula and it should give you what you are looking for.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

CarlosN on at

Like (0)

Report
I don't know where the code error is.
SortByColumns(Filter(AddColumns('Solicitudes Expres';"Cliente"; Cliente & Referencia); StartsWith(Estatus;EstIng2) && TextSearchBox1.Text in Cliente); "Estatus"; If(SortDescending3;Descending;Ascending))

Captura10.PNG

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@CarlosN

You already have a column called Cliente. You can't add a column with the same name.

Please make it a different name:

SortByColumns( Filter( AddColumns('Solicitudes Expres'; "Buscar"; Cliente & Referencia); StartsWith(Estatus;EstIng2) && TextSearchBox1.Text in Nuscar ); "Estatus"; If(SortDescending3;Descending;Ascending) )

Was this reply helpful? Yes No