My question is: when the user creates a new form and submits it, its data is stored in sql table, however when the user modifies and resubmits the form It just updates the last submitted form in the table. I want to have a way to store the history of all the newly and modified data in SQL. How can I do that?
I have a CreateForm table in SQL which stores the data now everytime user submits the form. I want to have another table which has all the history of the forms, whether if its deleted, modified etc.
Should I create a stored procedure for this and run a flow and how will I call it in powerapps?
Thanks,
Any help is much appreciated.
