web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to get a report of...
Power Automate
Suggested Answer

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

(1) ShareShare
ReportReport
Posted on by 10
I am wanting to extract version links of docs( PPT, Word docs, excels sheets etc. ) from SP library,  and store them to an excel sheet. kindly let me know a best way to do this. 
Best Regards
Madhulika 
Categories:
I have the same question (0)
  • Suggested answer
    chiaraalina Profile Picture
    2,425 Super User 2026 Season 1 on at
     
    Power Automate does not have a built-in action to directly list all historical file versions for multiple documents.
     
    But you can achieve this by leveraging SharePoint’s REST API within Power Automate:
    Uri:
    _api/web/lists/getByTitle('HR Documents')/items(@{items('For_each')?['ID']})/Versions
     
     
    Let me know if it works!
     
     
  • Suggested answer
    11manish Profile Picture
    3,333 on at
    If your goal is to generate a report of SharePoint document version history and export it to Excel, Power Automate can accomplish this, but there are some
     
    limitations and best practices to be aware of.
     
    Key Point
     
    Standard SharePoint actions such as Get files (properties only) do not return version history information. To retrieve document versions, you need to use the
     
    SharePoint REST API via the Send an HTTP request to SharePoint action.
     
    The most reliable solution is:
    • Get files from the SharePoint library
    • Use SharePoint REST API to retrieve version history
    • Extract version metadata (Version, Modified Date, Modified By, Comments)
    • Store the results in Excel, SharePoint, or Dataverse
    • Use the document URL plus version number as your reference, rather than trying to generate direct links to each historical version
    This approach is scalable, supported by Microsoft, and commonly used for SharePoint document audit and compliance reporting.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard