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

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Gallery / Power Automate - Webinars and Video Gallery / Power Automate SharePoint I...

Power Automate SharePoint Item Modified flow | Track Column Changes (Version History)

Views (1426)
RezaDorrani Profile Picture Posted by RezaDorrani 12,143

This Power Automate video is a step-by-step tutorial on how to track column changes (version history) for SharePoint by using "when an item is modified trigger" in flow. We can track to see the column changes for the modified item, leverage the send an http SharePoint action to get previous values of item based on previous version & also leverage the "Get changes for an item or file" action to get the information of which columns have changed.
The video will showcase some interesting patterns to get the "Version History". Video will have something for everyone from beginners to advanced users. Trying the CRAWL, WALK, RUN & SPRINT technique in this video.

Video covers the following:
✅ When an item is modified trigger in flow
✅ Add trigger conditions in Power Automate
✅ Get SharePoint column changes based on Version Number in flow
✅ Get previous column values using versions SharePoint REST API
✅ Create HTML data with column change information
✅ Send email notification of SharePoint column changes tracked

 

Helpful Links 🔗:

 

Learn flow expressions:
https://www.youtube.com/watch?v=O97IdCbfMQI 

 

Download flows shown in video (*only for learning purposes):
https://github.com/rdorrani/Microsoft-Flow/tree/master/ColumnChanges 


Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Categories:

Comments

  • preeter Profile Picture preeter
    Posted at
    Power Automate SharePoint Item Modified flow | Track Column Changes (Version History)

    Hey Reza, 

    I'm trying to get your "Complex flow Track Changes with HTML Table" to work but it seems that there's something I'm missing on the "Columns That Have Changed" step. As you can see, the "Select Updated Fields" step grabs all items that are true, but it appears that the intersection and join steps aren't working.

    The HTML table that's produced is always blank. Can you point what's missing? Thank you sir!

    intersection(body('Select_Updated_fields'),body('Track_Field_Keys'))
    join(outputs('Columns_that_have_changed'), ',')





    fail.png

    fail2.png

  • MLCarter1976 Profile Picture MLCarter1976 51
    Posted at
    Power Automate SharePoint Item Modified flow | Track Column Changes (Version History)

    Do you have instructions on how to get the previous value and the current one?  I didn't see it at the end of the video.