Sharepoint List - Track Changes on a individual field level

[Emanshu]

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-...

However it still returns the entire row data and not the specific field that changed. 

Thank you in advance for your time! 

[watkinnc · Accepted solution]

Hey there. I would consider using a Power Automate flow to capture the changes on an Excel sheet or email . I can't see any way to do it with just Power Query. 

--Nate

[sonia123]

Hello,

I dont see a solution here.

Can you please help ?

Thanks