Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Emanshu
Advocate I
Advocate I

Sharepoint List - Track Changes on a individual field level

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! 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

Hello,

I dont see a solution here.

Can you please help ?

 

Thanks 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors