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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / View previous version ...
Power Automate
Unanswered

View previous version data from SharePoint List Item

(0) ShareShare
ReportReport
Posted on by 79

Currently I have a people picker column within a SP list. The Column name is 'AssignedTo' and allows for multiple users to be selected. When the initial users are assigned, they are notified of being assigned via a separate flow. It was recently brought to my attention that additional users will start to be assigned after the fact. When additional people are assigned to that column I would like to send an e-mail out (just to the newly assigned people) notifying them that they have been assigned, but not notifying the previously assigned users. I have successfully compared the current version of the list to a previous version (19 to 18) but is it possible to see what 18 was originally? 

What I have done so far is 

  1.  When an item is created or modified
  2. Get changes for an item or file (properties only)
    1. Chose Site
    2. Choose List
    3. ID = (Dynamic Content) ID 
    4. Since = (Expression) sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
  3. Then I run a control to target the AssignedTo Column looking to see if its boolean value has changed 

 

No matter what I try though, I am always pulling in both the old users and the new ones. I am assuming I need to put version 18 into its own array and then version 19 into its own array, but I am having no luck on how to target just the version 18 data. Any help would be greatly appreciated. 



Categories:
I have the same question (0)
  • shoog Profile Picture
    2,164 on at

    You can retrieve the previous version of an item using the "Send an HTTP request to SharePoint" action.

    Make sure the method is set to GET and send an Accept header with value application/json

    The url would be

    /_api/web/lists/getByTitle('your list name')/items(yourItemID)/Versions?$filter=IsCurrentVersion eq false&$orderby=versionId desc&$top=1

    replace 'your list name' with the list you are using and yourItemID with the item ID.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard