Power Apps

Search, Sort & Filter capabilities

(1) Share

Report

Posted on by OE-03080350-0

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:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Suggested answer

Ravindra Jadhav 342 Moderator on at

Like
a
(3)

Report
Copy link

Link copied!
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
OE-03080350-0 27 on at

Like
a
(2)

Report
Copy link

Link copied!

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!!
Ravindra Jadhav 342 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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 )
OE-03080350-0 27 on at

Like
a
(1)

Report
Copy link

Link copied!

@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??