How can I add another category on the ticket details page called "duration?" I tried creating a new column called "amount" in the excel data source that will populate the current ticket with a value from a sheet called "Duration" in the same excel file. I tried copying the code and forms exactly from another category such as "area" and re -doing the coding according to the new excel field names. Nothing seems to work and it never updates the excel file data source.
Can you edit an existing data file from a canvas app already created in power apps? What is the simplest way to just edit the ticket records with a new field?
Secondly, How can i add a search function for all the tickets to search for a work or phraze?
Im new to all this and tried learning from the documents and videos but can't seem to get it to work.