Share
ReportApologies, I'm fairly new to powerapps and I'm having a little trouble.
I have a SQL Server Temporal table which is connected to my app. I am using collections for a responsive grid and within there I have a delete function where rows are moved to a delete collection before all being patched to said SQL table. All of that is working fine, however what I am trying to do before an item is deleted from the table, update that item with the last user and then delete so in my temporal table it will effectively show me who deleted the row. I've tried updating collections etc and it does not update as I believe it is just using the primary key to find the records to delete and taking no notice of the data in the collections.
On my final patch I think I need to lookup the IDs in deletion collection and update the field in the main collection then patch before I delete but I just cannot get it to work.
Any ideas would be much appreciated.
All responses (
Answers (
395
