Answered

How to get a report of Version History in SharePoint using Power Automate

(0) Share

Report

Posted on by elkhawase

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,

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-the-lasts-2-versions-and-what-columns-has-been/m-p/2275223#M134230.

Also checkout this link,
https://stackoverflow.com/questions/10561661/sharepoint-list-version-history-export-to-excel

Hope this helps!

1 people found this reply helpful.

Was this reply helpful? Yes No
elkhawase 51 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
elkhawase 51 on at

Like (0)

Report
Copy link

Link copied!

Thanks

Was this reply helpful? Yes No