Hi Everyone,
I'm trying to create an audit log for a list, similar to the Version History feature. However, the audit log of changes would be a completely seperate list to the list that I want to monitor.
The seperate "audit log" list will have the following columns:
| Date/time of change | Name (user that made change) | Name of field | Previous field value | Latest field value |
| | | | | |
I'd like the flow to do the following:
- Trigger when an item is created or modified on the list that is being monitored
- Determine which fields have changed
- For each field that has changed, write the required info (see table above) to the "audit log".
So far, my flow does the this:
- Determines which fields have changed and outputs a list of those field names
- Gets previous version values for the complete item.
I'm struggling to do the following:
- I need to take the list of field headings that I have and use them to get the current value of the field and the previous version of the field.
Any nudges in the right direction would be much appreciated!
