I have SharePoint List with several columns, which I want to track for changes, and log those changes into another List. Below is example (in Excel, for simplicity) for subset of 2 columns ("->" deontes changing from X to Y):
I have just started to learn SharePoint Flows, and I am a bit stacked here. What I have learned so far is this:
- I should start with SharePoint Trigger "When item is created or modified" modified"
- Use Action "Get Items" to pull data from MyChangelogList
Should I first create and populate MyChangelogList (as first/initial copy of MyList), and then compare it (what Flow Action to use?) with MyList? What Flow Actions to use to update values in MyChangelogList in format as above?
Important Remark: I have requirement not to modify MyList. All changes must be logged into separate list i.e. MyChangelogList.