Combining Search, Filter, and Sort for a Gallery

(1) Share

Report

Posted on by marshallzart

I have two functions that work on their own.... but can't figure out a way to combine them into one function.

Search(Sort('Permit Management','Project Name',SortOrder.Ascending),'Search Input'.Text,'Project Name','Work Order')

Filter('Permit Management','Project Status'='cmbProject Status Filter'.Selected.Value)

Permit Management = Dataverse table name

Project Status is a Choice Column with a combo box named Project Status Filter

Would you need more info than this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (2)

Report
@marshallzart -

Sort( Search( Filter( 'Permit Management', Len('cmbProject Status Filter'.Selected.Value) = 0 || 'Project Status' = 'cmbProject Status Filter'.Selected.Value ), 'Search Input'.Text, 'Project Name', 'Work Order' ), 'Project Name', SortOrder.Ascending )

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (2)

Report
Can you try this formula:

With( { baseTable: Filter( 'Permit Management', 'Project Status'='cmbProject Status Filter'.Selected.Value ) }, Sort( Search( baseTable, 'Search Input'.Text, 'Project Name','Work Order' ), 'Project Name', SortOrder.Ascending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
marshallzart on at

Like (1)

Report

This worked perfectly, I'm new to this so I will spend some time trying to understand how/why it works

Was this reply helpful? Yes No
marshallzart on at

Like (1)

Report

Thank you, I tried this but it ended up changing a lot of the Project Names from what they are named in the columns. The functions worked (ie sort, search and filter) though.

The solution Amik posted above did exactly what I was looking for though.
Thank you

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (2)

Report

@marshallzart - note that the code offered by @happyume is useful in case you're using SharePoint (the Search function is not delegable with that data source).

Was this reply helpful? Yes No
marshallzart on at

Like (1)

Report

@Amik

I have come back to this formula because I need to only include Approval Status (column name) that equals Approved. There's only 3 choices for that column (Pending, Approved, Rejected). Any idea how I'd add that?

Was this reply helpful? Yes No