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!

Report
All responses (
Answers (