Unanswered

Want to add an additional filter to my Gallery Code.

(0) Share

Report

Posted on by jamescosten

643

Currently I have a Gallery with a search bar that when blank sorts the table into Priority order Ascending. I would also like to add a filter to this that only shows items with a status of in progress. The status is a text column FYI.

If(

!IsBlank(TextInput2_4.Text),

(Search(

'WTRF Database',

TextInput2_4.Text,

"WTRF_x0020_Number_x0020_Text",

"ToolNumberText",

"Customer_x0020_Text"

)),

Sort(

'WTRF Database',

'Priority Order'.Value,

SortOrder.Ascending

)

Any thoughts appreciated.

Kind Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

timl 37,152 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @jamescosten

If you want to filter the records by status irrespective of whether the search textbox is filled in or not, you could wrap your entire expression around a call to Filter.

Filter( If( !IsBlank(TextInput2_4.Text), (Search( 'WTRF Database', TextInput2_4.Text, "WTRF_x0020_Number_x0020_Text", "ToolNumberText", "Customer_x0020_Text" )), Sort( 'WTRF Database', 'Priority Order'.Value, SortOrder.Ascending ) ), Status="In Progress" )

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report
Copy link

Link copied!

I tried this and it returns nothing on the Gallery, But does not error?

Was this reply helpful? Yes No