You’re offline. This is a read only version of the page.
Hi Everyone,
I need to get a report (like an excel report) to see who updated an item and what has been updated in a sharepoint list without the need to click on Version history everytime to get the details. Is there a way in power automate to do it?
BR,
Hi @elkhawase ,
So , for the first one , you have to create a file in your OneDrive or SharePoint document library with a table with all columns that you want to store including the SP list item ID. then use the add a row action every time the list item is modified (which should be your trigger).
So you open the file and filter the list by ID , you should see all SP list item versions.
2. the second one is little tricky as you have to get list id and view id(which you can get if you go to edit view and grab the value between %7B and &7D.
You can try the first approach
Hi,
so in the first link, it's not showing how to store the versions in an excel file.
and in the second link I stuck at the below step and the link is not opening when I paste the URL
Hi @elkhawase ,
Your requirement is similar to the below thread. You can use the trigger when an item is created or modified. Once you get the item version history you can create a new row in excel with List Item ID and other columns that you want to see.
Also checkout this link,
https://stackoverflow.com/questions/10561661/sharepoint-list-version-history-export-to-excel
Hope this helps!
#1
Pstork1
18
Most Valuable Professional
#2
rpersad
16
#3
David_MA
10
Super User 2025 Season 1
Share
Report
All responses (
Answers (