08-01-2022 05:16 AM
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
watch?v=Ek4oYWPWfT0
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!
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.