I have a list of employees that includes their names("Title"), their worked hours per month("Hours"), project they worked on, which is based on choices("Project"), Category of project also based on choices("Category"), worked month('Work Month') and work year('Work Year'). I want to make a screen that has search based on the name, project, category, month and year! The search works only on one field!! I have added a textbox for name, month and year and two dropdowns, one for project and one for category!!
For Items of Galley I have this and it is not working!!!
Sort(Sort(Filter('List',TextInput6.Text in "Title" || TextInput6.Text in 'Work Month' || TextInput6.Text in 'Work Year' || DataCardValue3_1.Selected.Value in "Project" || DataCardValue8_1.Selected.Value in "Category"),'Work Month', Descending),'Work Year',Descending)
