Answered

How to combine a SearchBox with my Sort, and Filter functions (snippet included)

(0) Share

Report

Posted on by honganhuynh1

302

Sort(Filter('MySharepointList',
 //Filter by ddCompleted value
Completed.Value=ddCompleted.Selected.Value,
 //Then filter by ddName if All is not selected
ddName.Selected.Result="All"||AssignedTo.Value=ddName.Selected.Result),ID,If(SortAscending,Ascending,Descending))

This is my current Gallery code but I added a text input box called "Searchbox" and would like to incorporate it to my code.
Watching Shane Young's video my search code would be

Search('MySharepointList', SearchBox,TicketNumber)

Just not good at combing it into my pre established statement

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

zmorek 3,272 on at

Like (0)

Report
Copy link

Link copied!
Sort(Search(Filter('MySharepointList', //Filter by ddCompleted value Completed.Value=ddCompleted.Selected.Value, //Then filter by ddName if All is not selected ddName.Selected.Result="All"||AssignedTo.Value=ddName.Selected.Result),SearchBox.Text,"TicketNumber"),ID,If(SortAscending,Ascending,Descending))

You're close. Just wrap the Search() around the Filter() statement.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@honganhuynh1

This will work only if "TicketNumber" is a text type column. Search does not work with numbers.

Sort( Search( Filter( 'MySharepointList',Completed.Value=ddCompleted.Selected.Value, ddName.Selected.Result="All"|| AssignedTo.Value=ddName.Selected.Result),SearchBox.Text, "TicketNumber"), ID, If(SortAscending,Ascending,Descending))

Otherwise you will need to add it to your filter

Sort( Filter('MySharepointList', Completed.Value=ddCompleted.Selected.Value && IsBlank(SearchBox.Text)||TicketNumber=Value(SearchBox.Text) && ddName.Selected.Result="All"||AssignedTo.Value=ddName.Selected.Result ),ID,If(SortAscending,Ascending,Descending) )

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (0)

Report
Copy link

Link copied!

It is a text column and that first set of code didn't work.

TicketNumber is a text column within my SP List

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (0)

Report
Copy link

Link copied!

Hey @zmorek , that didn't work unfortunately. Error was Incompatible types for comparison, These types can't be compared: Error, Text.

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (0)

Report
Copy link

Link copied!

Hey @Drrickryp , the second option worked when I instead of Ticket number compared it to ID but then it broke my filter by Completed and by Name

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@honganhuynh1

What is your current items property?

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (0)

Report
Copy link

Link copied!

Completed is a Choice
Assigned is a Choice

ID is Number (I'm assuming)?

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (0)

Report
Copy link

Link copied!
Sort(Filter('MySharepointList', //Filter by ddCompleted value Completed.Value=ddCompleted.Selected.Value, //Then filter by ddName if All is not selected ddName.Selected.Result="All"||AssignedTo.Value=ddName.Selected.Result),ID,If(SortAscending,Ascending,Descending))

@Drrickryp
Did you mean what my current items looks like for the Gallery? If so its that

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@honganhuynh1

This should prefilter your list by completed items and then further filter it by the AssignedTo individuals. Then sort it by ID.

With({_items:Filter('MySharepointList',Completed.Value=ddCompleted.Selected.Value)}, Sort( Filter( _items, ddName.Selected.Result="All" || AssignedTo.Value = ddName.Selected.Result ), ID,If(SortAscending,Ascending,Descending) )

FYI The ID metadata of a SharePoint list is unique in that it looks like a number but doesn't act like one with respect to PowerApps functions and operators. For example, you cannot use >, <, <=, >= operators with it, only "=". SharePoint also makes sure ID values are not reused if the record is deleted and cannot be duplicated in a list.

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (0)

Report
Copy link

Link copied!

Hey @Drrickryp, that returned what I had before but what about the Searchbox searching by ID

Searchbox's name is Searchbox
and Id is ID

Was this reply helpful? Yes No