Power Apps - Building Power Apps

Search, Sort & Filter capabilities

(1) Share

Report

Posted on by CU01090320-1

I have a SharePoint list with 9 columns.

The columns are:

Activity Date
Client
Country Program
Activity
Details
Activity Category
Application Stage
Staff
Status
Attachment

Columns 2, 3, 6, 7, 8 & 9 are choice fields with dropdowns. Columns 4 and 5 are free text.

I am working on a Power App. How do I build Search, Sort, Filter & Bulk/Multiple entry capabilities into the app?

Thank you!

Categories:

Using Apps Using Formulas

General Questions

Connecting to Data

All responses (4)

Answers (0)

CU01090320-1 12 on at

Like (1)

Report

Search, Sort & Filter capabilities

@Ravindra, here's the code I used

Sort(

Search(

Filter(

'SM Daily Act',

(IsBlank(Dropdown_Client.Selected.Value) || Client.Value = Dropdown_Client.Selected.Value) &&

(IsBlank(Dropdown_CountryProgram.Selected.Value) || CountryProgram.Value = Dropdown_CountryProgram.Selected.Value) &&

(IsBlank(Dropdown_ActivityCategory.Selected.Value) || ActivityCategory.Value = Dropdown_ActivityCategory.Selected.Value) &&

(IsBlank(Dropdown_ApplicationStage.Selected.Value) || ApplicationStage.Value = Dropdown_ApplicationStage.Selected.Value) &&

(IsBlank(Dropdown_Staff.Selected.Value) || Staff.Value = Dropdown_Staff.Selected.Value) &&

(IsBlank(Dropdown_Status.Selected.Value) || Status.Value = Dropdown_Status.Selected.Value)

),

TextSearchBox1.Text,

"Activity", "Details"

),

'Activity Date',

Descending

)

Here's the error message

The expression was intended to filter the 'SM Daily Act' table based on various dropdown selections and a text search, then sort the filtered results by 'Activity Date' in descending order. However, there are multiple errors in the expression related to incorrect variable names, invalid arguments for functions like IsBlank and Search, and incompatible types for comparisons. These errors prevent the expression from executing correctly.

What's wrong please??
Ravindra Jadhav 263 Super User 2025 Season 1 on at

Like (1)

Report
Search, Sort & Filter capabilities

You have to use this formula on item property of gallery and you have to Chnages the names and Search TextInput Box name

below is revisited formula

Sort( Search( Filter( YourSharePointList, (IsBlank(Dropdown_Client.Selected.Value) || Client.Value = Dropdown_Client.Selected.Value) && (IsBlank(Dropdown_CountryProgram.Selected.Value) || CountryProgram.Value = Dropdown_CountryProgram.Selected.Value) && (IsBlank(Dropdown_ActivityCategory.Selected.Value) || ActivityCategory.Value = Dropdown_ActivityCategory.Selected.Value) && (IsBlank(Dropdown_ApplicationStage.Selected.Value) || ApplicationStage.Value = Dropdown_ApplicationStage.Selected.Value) && (IsBlank(Dropdown_Staff.Selected.Value) || Staff.Value = Dropdown_Staff.Selected.Value) && (IsBlank(Dropdown_Status.Selected.Value) || Status.Value = Dropdown_Status.Selected.Value) ), TextSearchBox.Text, "Activity", "Details" ), ID, Descending )
CU01090320-1 12 on at

Like (2)

Report

Search, Sort & Filter capabilities

Hello @Ravindra,

Thank a lot for your help. I have not entered the formular yet.

Want to ask where I plug this in - in the Items property of the Gallery where my data is or in the Onselect property of TextSearchbox1??
Also, does this formular also allow users of the app to sort using Activity Date (Ascending/Descending order)?
Last but not least, how do I build the capability for multiple entries, so users do not have to enter data one at a time?

Thank you!!
Suggested answer

Ravindra Jadhav 263 Super User 2025 Season 1 on at

Like (3)

Report
Search, Sort & Filter capabilities

Hii Hope you are doing great ❤,

To build Search, Sort, Filter, and Bulk/Multiple entry capabilities in your Power Apps gallery using Power Fx formulas

Search(Filter( YourSharePointList, (IsBlank(Dropdown_Client.Selected.Value) || Client.Value = Dropdown_Client.Selected.Value) && (IsBlank(Dropdown_CountryProgram.Selected.Value) || CountryProgram.Value = Dropdown_CountryProgram.Selected.Value) && (IsBlank(Dropdown_ActivityCategory.Selected.Value) || ActivityCategory.Value = Dropdown_ActivityCategory.Selected.Value) && (IsBlank(Dropdown_ApplicationStage.Selected.Value) || ApplicationStage.Value = Dropdown_ApplicationStage.Selected.Value) && (IsBlank(Dropdown_Staff.Selected.Value) || Staff.Value = Dropdown_Staff.Selected.Value) && (IsBlank(Dropdown_Status.Selected.Value) || Status.Value = Dropdown_Status.Selected.Value) ), "Activity", "Details" )

You can Follow this Approach

If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping

Thank You

Ravindra Jadhav