I have a functional Power App that displays a SharePoint list containing project data. I have a functional search field that searches three columns (Pursuit-Name, SFDC-ID, & Bid-Manager). I have added a drop down menu to further restrict search results based on the SharePoint created date. The SharePoint list only contains 2019 and 2020 projects and therefore the drop down will contain three items (all years, 2020, 2019).
How can I incorporate this drop down menu to work with the existing search function to further restrict the search results?
My gallery is displaying the SP List data and the Items property contain the code shown below. I have one text input control that allows user to search either by Pursuit-Name, SFDC-ID, or Bid-Manager. Any recommendations are greatly appreciated.
SortByColumns(
Filter(
collTeamsSites, StartsWith( 'Pursuit-Name', txtSearch.Text ) || StartsWith( 'SFDC-ID', txtSearch.Text ) || StartsWith( 'Bid-Manager', txtSearch.Text )
) , "Title"
)