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
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
