
I am new to using Power apps and have been trying to teach it to myself. Using some guides I found online I put together a basic but mostly functional ticket system. On the launch page I have set it up where it will display the tickets of users which can be sorted by date. I would like it to only show the tickets that are in either New, or In Progress status though. So all closed or canceled tickets will not show. I have another section that they can view ALL of their tickets and would like to declutter the launch page. I am attaching the code for the section that shows their tickets. In the sharepoint list I do have a section for the status. So the fields exist I just need to have it filter it. If possible can somebody please assist with a code change that would accomplish this?
SortByColumns(If(varbuscar=true,Filter('Ticket System',StartsWith(Title,TextInputFind.Text),'Ticket logged by'.Email=User().Email),Filter('Ticket System','Ticket logged by'.Email=User().Email)),"DateReported",If(SortDecending1, Descending, Ascending))
Also a more miner thing but help would be appreciated the search bar isn't working yet since I have no idea where to even start on there yet. Admitidly though I havn't worked on the search bar research much since the other is more important to me at the moment. It's code is as follows:
Set(varbuscar,true);