Forum Discussion
Sharepoint List Change Tracking
Use Case:
I have a SP list where a user is allowed to change certain fields. I need to identify which fields changed so I can ultimately send those changes to a vendor.
Need:
Identify specifically which field in a SP List item changed, not just that “Something” on the item row changed so that I can:
- Identify the changes in Power BI
- Export the changes into Excel
Key ID | Field A | Field B | Field C | Changed BY | Change Date |
2 | Abc | Jjj | Ttt | User1 | 01/02/21 |
2 | Abc | Lll | Ttt | User1 | 01/15/21 |
2 | Abc | Lll | zzz | User2 | 01/22/21 |
Export or pull into Power BI the changes made since 01/05/21 for Key ID
Key ID | Field B | Field C |
2 | Lll | zzz |
I have replicated the process in this guide : https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=fca4ea13-62a0-4fbf-b546-0e9e70ba6e6d&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
However it still returns the entire row data and not the specific field that changed.