Power Platform – Power Automate – Run a flow on Edit Item – Getting recent updates of SharePoint list item

Hi All,
Greetings for the day!!!
I learned something new in Power Automate and so this article.
Background / Use Case
- We have SharePoint list having column “status” with possible values
- New
- In Progress
- Completed
- On every status change we need to send an email to respective teams
- For status – New its very easy, on item creation we can send an email
- For update on status column we need to send an email so looking for solution
Solution – SharePoint trigger – “When an item or a file is modified”
- In Power Automate we have a trigger in “SharePoint” call “When an item or a file is modified“
- This trigger made lot easier to get the changes / updates when item or file is updated
- We need to specify details
- Site Address
- List or Library Name
- Now, next thing is how to get updates
- We have an SharePoint action “Get changes for an item or a file (properties only)“
- This action returns information about columns that have changed within a given time window
Note : This action requires versioning is enabled for list or library
- Add the action “Get changes for an item or a file (properties only)”
- This action requires following details
- Site Address
- List or Library Name
- Id – Id of the item for which we need to get the changes
- Since – Possible values are
- Trigger Window Start Token OR
- an item version label OR
- ISO 8601 date , for ex – YYYY-MM-DDhh:mmz
- Until – Possible values are
- Trigger Window End Token OR
- an item version label OR
- ISO 8601 date , for ex – YYYY-MM-DDhh:mmz
- Trigger Window Start Token and Trigger Window End Token returns the changes since last update
- Based on “Since” and “Until” values, updates are returned
- The action outputs tokens such as “Has Colum Changed:<Column name>” for every column
- These tokens can be used to filter the column which we want to use in our flow
- As shown in below fig, we are checking if item title is changed – “Has Column Changed: Title“
Complete Demo

Thanks for reading. If its worth at least reading once, kindly please like and share !!! SHARING IS CARING 🙂
Enjoy the beautiful life !!! Have a FUN !!! HAVE A SAFE LIFE !!! TAKE CARE 🙂
You must log in to post a comment.