cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shashank_p
Regular Visitor

How to get previous changes from a particular column in a share point list using power automate

Can anyone please help me with below requirement. 

 

I have a SharePoint list for the defect tracking. I need to Triger a approval flow when a particular item in that list changes. (which I am able to do), But when sending the notification to the approver of the changes made(I am able to get who made the change & when that particular column is changed) But I am not able to get the previous data which was there before the change made. 

 

I need that to be added in the approval notification to be sent to approver. 

 

for example: Change has been made to the "ID" by "Modified by" in  "Release Date" Previous "Release Date" was "??"

 

All help is appreciated.

 

Regards,

Shashank P

 

 

 

1 REPLY 1
jinivthakkar
Memorable Member
Memorable Member

@shashank_p If you have version history enabled you can get version history of item using flow, here is a link in which a power apps gets version history using flow, I have implemented this in past and this works.

 

https://www.about365.nl/2019/08/08/view-sharepoint-item-version-history-in-powerapps/

 

If you dont have version history enabled, then there is no direct way of doing that but you could add one more column which can be made hidden and store old values and when item is updated you can get the current value and the old value from the column you created to store old values. 

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (52,174)