We have a SharePoint list named Invoices + an another SharePoint list named Invoices_Logs
now we have a form which allow users to add/edit invoices. but we want to capture what have been changed when the user update the invoice field and store this info inside the Invoices_Logs list.
let say we have an Invoice item with those values :-
- Invoice_Number = Invoice-1
- Balance = 100
- Type = Personal
and someone edits this invoice and change the values as follow:-
- Invoice_Number = Invoice-1
- Balance = 100
- Type = corporate
then the Invoice_Log list should list this inside a mute-line of text field:-
Field= Type. Old value= Personal / New value = corporate
now i know that i can create a variable inside Power Apps which stores the original item values >> and compare them with the fields before the user submits the form >> but i am asking if Power apps provide an automated way to capture which field/s has been changed inside the form?
Thanks