web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Using Search with Filt...
Power Apps
Answered

Using Search with Filter, DatePicker and SortByColumns

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Guys,

I asked for help on this earlier here Solved: Datepicker to filter Gallery - Power Platform Community (microsoft.com)

And PG_WorXz10  kindly helped me sort that particular issue out. 

 

The next thing I have been trying to add is a Searchbox to the Gallery and use "Search(". I have been at it for the last 6 hours, researching every thread I could find, and still am not able to figure out what I am doing wrong. I say that because I don't want anyone to think that I am posting without trying to figure it out myself. I really have tried.

 

I have tried to add Search( to the formula below, and have tried it every way I can imagine. I'm just not getting the syntax correct.

 

 

SortByColumns(Filter('Right Start Attendees',Text('RSO Date',"dd/mm/yyyy")=Text(DatePicker.SelectedDate,"dd/mm/yyyy")),"Title",If(SortDescending1,Descending,Ascending))

 

 

I believe it should look something like this, however, I'm not sure if the "SearchBox.text" is in the right location? and if/where I need to put "Title" for the name of the column I want to search.  The database is a Sharepoint list.

 

SortByColumns(Search(Filter('Right Start Attendees',SearchBox.Text, Text('RSO Date',"dd/mm/yyyy")=Text(DatePicker.SelectedDate,"dd/mm/yyyy")),"Title",If(SortDescending1,Descending,Ascending))

 

 

As always, thanks in advance for your help!

Categories:
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I was able to figure this out by putting the search at the front of the code and the Searchbox.Text at the end.

    Search(SortByColumns(Filter('Right Start Attendees',Text('RSO Date',"dd/mm/yyyy") =Text(DatePicker.SelectedDate,"dd/mm/yyyy")),"Title",If(SortDescending1,Descending,Ascending)),SearchBox.Text, "Title")

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard