Unanswered

Combining Filter, Sort and Search

(0) Share

Report

Posted on by Rama96x

149

I want to be able to sort, filter and now also search with an InputText. I'm just a little bit confused of how that can be done, when I already have a Filter and Sort function in the Gallery Item property.

If(
 Gallery5.Selected.Value = "All" And TextInput1.Text = "",
 SortByColumns(
 SortByColumns(
 'Job Instruction - Feedback App',
 "DateCreated",
 Ascending
 ),
 "FeedbackCompleted",
 [
 "Not started",
 "On going",
 "Completed", 
 "Cancelled"
 ]
 ), 
 Filter(
 'Job Instruction - Feedback App',
 FeedbackCompleted = Gallery5.Selected.Value
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!
Try:

If( Gallery5.Selected.Value = "All" And TextInput1.Text = "", SortByColumns( SortByColumns( 'Job Instruction - Feedback App', "DateCreated", Ascending ), "FeedbackCompleted", [ "Not started", "On going", "Completed", "Cancelled" ] ), Filter(Search( 'Job Instruction - Feedback App', SearchBox.Text,"ColumnToSearch"), FeedbackCompleted = Gallery5.Selected.Value ) )

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Please Subscribe to my Youtube Channel

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report
Copy link

Link copied!

@eka24 This works if "All" button has not been picked., however, I would like this to be applicable for all buttons. How would I do it inside GAllery5.Selected.Value = "All" as well?

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report
Copy link

Link copied!

Idealy I just want it to be above the IF statement, because you should be able to search whether you have picked "All", "On going" etc.

Was this reply helpful? Yes No