I am trying to create a Time Log program for our Student Workers to use to keep track of their time worked. I have a list in our department's SharePoint page designed with the columns: Name, Signed_In, Signed_Out, Hours_Worked. I have one screen that has a button tied into a Flow which creates a new item in the list and populates the Name with the Students Name and the current date (Now) into the Signed_In field.
I also have a button that takes the user to a second screen that uses a Gallery to show all the time records for the user which uses SortByColumns(Search('Student Time Log',NameBox.Text,"Name"),"Signed_In",Ascending) to populate the gallery. This function is currently working just fine.
I have third button that goes to another screen and here I want to show all records where the student hasn't signed out for the day. So the logic I want here is where the name = student's name, Signed_out is empty, and Signed_In >= Now-1. My problem is that I don't think the Search function can support multiple columns/variables.
Is there a way that I can tell PowerApps gallery to query a table for 2 to 3 variables?