web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Want to add an additio...

Power Apps

Unanswered

Want to add an additional filter to my Gallery Code.

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (0)

Sort by

timl 36,901 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

Join the conversation