Hello
I am working on a Canvas app that is using SharePoint lists as the Data Source. The customer would like to have some sort of Auditing of the users how are using the app, and what they are doing. They are looking for Date/Time, User name, what action was being done.
We (the team I am part of) were thinking about using an excel file with a table (Named - Audit_History), that can be saved as an Attachment (all record will have the same file, named - Audit_History.xlsx) within the SharePoint List record.
I am not able to find a way to add a row of data to the excel file with the need information. If I try to use flow to "Add a row into a table" it needs a Document Library, I am using a SharePoint list (unless there is a workaround). If I try to Patch within my Canvas app, I need a Data Source the file name will always be the same in each record. If someone could give me some help with this, it would be greatly appreciated. Also if there may be a better way to achieve what the customer is looking for we are open to suggestion.
